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 Jenna,
I typically do this with a dedicated value that turns the axis date into a number and then compares that to a hard-coded number representing the desired annotation date. E.g.
IF ( MAX( [Calendar Year]*10000 + [Calendar Month]*100 + [Calendar Day Of Month] ) = 20210722 , RSUM ( [Total Ticket Count] ) , NULL )
Then rename the value to "1 July-- COVID Restrictions announced". You can replace the RSUM( [Total Ticket Count] ) with any other value, and can change the chart type for just this value to a column, or whatever changes help make the label visible and distinguished from the primary value, without being overly invasive visually.
Hey Chris - trying to use this magic forumla again :-) This time with days in date. I've tried pasting the above formula into analytics but the criteria is going in as plain text, so I need to replicate it. Are 'calendar year', 'calendar month' & 'calendar day of month' performance date criteria?
Hi Jerry,
It's whatever you have on the x-axis. For a a sales curve over order dates those fields would come from the ORDER DATE dimension. For an attendance trend over performance dates those fields would come from the PERFORMANCE DATE dimension.
Ah, thank you Chris.