Heat Map Report on Events (Sick Leave / Vacation / Training etc)
Estimated reading time:3 min
Heat Map Report of Events
How to see a ‘heat map’ style of report when people are off or sick or on vacation/annual leave. So our suggestion here would be to use an Event Report from the Heat Map Report folder. We’ll also show you the additional options we can add to customize the report the way you want it. Here are step by step instructions on how to generate an events heat map report.
Open Reports Folder
Heat Map Reports
Alter Date Range as necessary
To alter the frequency go to
We can adjust how we show the data in terms of the dates. By default, the report will show us a daily breakdown of the data over the current month. We can adjust that to show is a weekly breakdown instead. Options include Daily, Weekly, Monthly and Yearly. It’s handy to adjust the date range to view more data. In this example we will adjust from daily to monthly so that we can view the 12 months of the year on the one page.
Choose desired frequency (Day / Week / Month etc)
To add Conditional formatting
Conditional formatting can be super helpful in highlighting important data in a report. We can add multiple conditions to the reports see below for steps on how to add to your report.
Apply rules as necessary
The report will look something like this:
To alter the events you report on:
Perhaps you want to filter to just view Annual Leave or Sick Leave in the report. You can do this via the data tab in the report builder.
Select what Events you wish to report on
Dig deeper and show breakdown of Event to Resource
By adding a secondary grouping will allow us to breakout the data even more. Our primary grouping will be the event, and the secondary grouping will be the resources. This means that we see each event broken out by resource and their individual time against the event.
Add Secondary Grouping to Resource/Unassigned
Now you have a breakdown of resources and events.
Save for Future
Suggest that you save this report for future reference. Saves you having to repeat the process each time. The date range will update accordingly. When it comes to saving a report, there are two options available. You can save privately or internally. Privately will save to My Saved Reports folder, and saving internally will save to the Internal Reports folder. To do so:
Click ‘Save’ within the Report Toolbar.
Opt to save to your own folder ‘My Reports’ or alternatively save within ‘Internal Reports’ which gives all colleagues access to this report.