2 of 2 people found this helpful
I've attached a sample workbook (made using 10.2) that has some ideas for a dashboard you can use as well as a revised copy of the Excel data source.
The main thing that needed to be added to your data source in order to create these was a worksheet in the Excel file that has the date for every day in 2018, like this:
I've named this worksheet "Dates 2018".
Once we've got this worksheet in the data source, we can do a Left Join to bring each of the different holiday or meeting data sources, like this:
School Holidays -
Bank Holidays -
This will leave us with 3 separate data sources that we can use to build out a dashboard. I've made a calendar to track the meetings and timelines to show the school and bank holidays. You can select any of the Dark Blue days to load up a details sheet to the right that shows which meetings are being held on that day:
Hopefully this will be a good place to get you started brainstorming on how you want to show your calendars
Let me know if you've got any questions on the formatting or setup of the dashboard.
Thank you so much Dan. I will surely get back if I require any help.
Thanks a lot again for the great solution on Calendar before.
I have a question on how can we colour\format all the dates between 2 dates on calendar. This is to show holidays, ex: Half term school holidays. Please let me know.