You are currently reviewing an older revision of this page.
From HERE
Jenna Whitnall (Royal Collection Trust)
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.
Chris Wallingford (Tessitura Network)
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.
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.