see the attached - I had to use the US format for date
place on the filter shelf and set to
and build the viz
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
I'm going to go with this, but just of of interest, could you think of a more elegant solution? At the moment I've only got data for two years and I don't mind hard-coding all bank holidays for that period. But going forward, it will be quite annoying for the person taking over from me to add the holiday dates for every new year.
I thought of that when I was writing the formula -
the one thought would mean maintaining a separate "bank holiday" file that you would join with your data file - it would be like adding a column to the data that either had bank holiday, Easter, or null in it -
and yes that is some work but it is the same calendar your clients HR department puts together annually so you could probably leverage that
You can maintain a holiday calendar in the database for next 5 to 10 years. If your ultimate goal in the future is to connect to a database data source.