Ad Hoc View – Time Series Heat Map
Time Series Heat Map charts display individual values across dates/times represented as colours.
Charts allow you to graphically display your data. There are a number of different chart types available in various ways.
Range charts display values as heat maps.
Step 1. Open or create a new ad hoc view (refer to the Creating Ad Hoc Views article for further information)
Step 2. Select Chart from the drop-down at the top of the screen.
By default, a column chart is selected.
Step 3. To change the chart type, click the options drop down in the top left corner of the chart area.
Step 4. Select Chart Types and select Heat Map chart.
Hover your mouse over the chart thumbnail to see the chart type name.
There are 5 Range charts available:
Each chart type displays your data in slightly different ways.
Heat Maps display individual values as colours.
Select Time Series Heat Map Chart.
The Time Series Heat Map Chart displays individual measures across dates/times as colours
Step 5. Click and drag a measure from the measures area on the left-hand side pane to the column area.
e.g. Count of Clients
Tip: All charts must have at least one measure. Time Series Heat Maps require one measure in the columns area and one datetime type field in the rows area.
Step 6. Click and drag a date time field to the rows area.
e.g. Date modified
As the chart requires the date time field to be grouped ‘Hour by Day’ you will need to adjust the grouping for the information to appear.
Step 7. Right click on the Date Modified field label.
Click on Change Grouping.
Select Hour By Day.
The chart is displayed
For further information on Ad Hoc Views and Charts, refer to the following articles: