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.

Instruction

Step 1.  Open or create a new ad hoc view (refer to the Creating Ad Hoc Views article for further information) Step 2. Click on the Select Visualisation Type icon in the top menu

The Select Visualisation Type window is displayed

Step 3. Select Range from the Chart Types list There are 5 Range charts available:

• Heat Map
• Time Series Heat Map
• Dual-Measure Tree Map
• Tree Map
• Parent Tree Map

Each chart type displays your data in slightly different ways. Heat Maps display individual values as colours. The Time Series Heat Map Chart displays individual measures across dates/times as colours Step 4. Click on Tim Series Heat Map 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

Further Information

For further information on Ad Hoc Views and Charts, refer to the following articles:

• Ad Hoc Views
• Ad Hoc Views – Charts
• Ad Hoc View – Filters
• Ad Hoc View – Heat Map
• Ad Hoc View – Parent Tree Map
• Ad Hoc View – Dual-Measure Tree Map
• Ad Hoc View – Tree Map