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.
.
In case you need a range instead of a discrete Milstone the IF() statement can use > and < operators as well as AND and OR within its conditions...
eg: Jo Bramley Auckland War Memorial Museum
Visitation for our museum is very dependent on a few things like weather, weekends, school holiday breaks etc. What I'd love to be able to do is to have those dates - like school holidays indicated or noted on some of our widgets. For example - a simple bar chart below that show ticket sales to an exhibition by day. Currently I have this conditional on if the daily sales target was reached which is all fine but what I'd love to overlay or indicate somehow on this widget was that from 1st July - 16 July there were school holidays - does anyone do this already & can fill me in on how?
Many thanks!
Hi Jo,
Share you're formulas if you like, but from that wiki Heath shared, the IF() statement can use > and < operators as well as AND and OR within its conditions...
IF ( MAX([Day of Week]) <= 5 AND MAX( [Calendar Year]*10000 + [Calendar Month]*100 + [Calendar Day Of Month] ) >= 20230723 AND MAX( [Calendar Year]*10000 + [Calendar Month]*100 + [Calendar Day Of Month] ) <= 20230916 , {true value} , {false value} )