Hello all
Im trying to take two date dimensions and stack them on top of each other, the aim to to established how many cancellations and new signups we have had in 2020. Additionally a net gain figure which would be calculated by taking the new signups 'tm_added' and subtract any cancellations 'tm_cancelled'
Thanks for your help!
Hi Arron,
Here is your solution using the updated datasource. In addition to the monthly view I have
also shown you a weekly view. It does look a lot better and now I am relieved . I also wished
to show the Added and Cancelled values so I have shown them as Bubbles in addition to the
vertical Bars showing the Net Gain (Amount Added - Amount Cancelled).
Also here is the weekly view which gives a bit more insight as to which weeks have been good
(Higher Net Gain).
Interestingly Week 6 and Week 16 seem to show the highest value for Net Gain compared
to other weeks. I wonder why ?
Wait ! Isn't Week 6 close to Valentine's day, but "what's love got to do with it" (great song ).
Also here is your twbx file and hope this was helpful and entertaining and I am glad, I did get by
'with a little help from my friends' as 'there are places I remember', as 'words are falling off like
endless rain into a paper cup...","Obladi Oblada life goes on", never mind "Let it be". I guess
it's time for a musical break.
Do let me know if you have any questions. Take care and Best wishes !
Sincerely,
Soumitra
