Still trying to find my way around Analytics so apologies if this is obvious / I'm fundamentally misunderstanding something about how the platform works.
We're trying to build an Indicator Widget which can show us how much money we'd need to take each week between today and the end of the season in order to hit target. ( i.e. Target - Ticket Paid Amount / Number of Weeks Until End of Season ) As this would be for a Season Dashboard I'm happy to manually input the Target itself, but I'm still having trouble getting the 'Weeks Until End of Season' part to work.
My thinking is I'd like to filter within the Edit Formula window specifically on the Performance Date 'Weeks in Date' criteria using the calendar tool to filter from Today to the date of the last performance in that season. However, I'm currently having two problems with this approach;
1) I can't see a way, either in the Calendar or Time Frame tabs, to filter from a relative date (i.e. Today) to a specific date. (in this case 4th Jan 2020)
2) If I ignore the first problem and just manually input From 14/05/2019 To 04/01/2020 into the Calendar filter tab, then my criteria no longer counts Weeks and automatically switches to Days in Date but with a count that isn't even right. (It's counting 1597 unique days between the two dates)
I don't know if anybody has any ideas where I might be going wrong?
Thanks loads. Much appreciated.
Lawrence