Kia ora,
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!
Hey Jo,
Does something like Milestones work for you?
There is a repost in Analytic Coffee Wiki HERE
Hi Heath - thanks so much for your reply. This is totally what I'm after! Brilliant!
So while this does work for me (see below using weeks & a set value) it would be soooo much better if I could set a date range - especially for the summer break which is 6 weeks which means having 6 additional values down the bottom of the widget. Any ideas on how to change the formula to do that?
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} )
updated
Thanks Chris Wallingford - I don't know what we'd do without you! Appreciate the help!