Hello all,
Just a quick one, I'm looking to try to plot a unique data point according to an x-axis or y-axis and then label it. A hypothetical example would be, I'd like to show a timeline of ticket sales with a marker showing when further COVID restrictions were announced, for example: 1 July-- COVID Restrictions announced. If the timeline was something like Perf Date, can anyone suggest an approach to try to achieve this?
Another example might be like "breakeven point" for ticket sales or something along those lines.
Grateful for any advice from any of you experts out there!
Jenna
Hi Jerry,
If you still want to set a specific Date, and then have it annotate a given Week in Date, this is probably the most reliable approach:
For each date in the given x-axis week, see if that date is the desired annotation date, and if so, return a 1 to the Week. If the max value in any given week then is 1, render the RSUM( [Total Ticket Count] ) annotation value.
IF ( MAX ( [Days in Date] , IF ( MAX( [Calendar Year]*10000 + [Calendar Month]*100 + [Calendar Day Of Month] ) = 20210722 , 1 , NULL ) ) = 1 , RSUM ( [Total Ticket Count] ) , NULL)
That's worked a treat. Thanks Chris!
JH.