Hello Jamil - I have analyzed the required and though, something of this would be helpful. Geographically it is being presented when schools are in Vacation / Open. You have a Date selector at the top the Dashboard and selected data is displayed in bold on top the dashboard.
Only Two colors are being used to identify the pattern of the vacations in various cities.
Vacation Identifier.twbx 99.8 KB
Thanks for the reply Manideep. While this is an interesting view, I am more interested in seeing an aggregate view showing a calendar overview. This way, it is easier to see where the majority of the cities are on vacation vs not on vacation.
Something that looks like this or even a bar graph on a continuous date line.
The darker the green, the more cities are on vacation. (Please note, this is not accurate as I manipulated the view to get it to look like this.)