Ad Hoc View – Time Series Heat Map

  1. Home
  2. Ad Hoc Views - Charts
  3. 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. Select Chart from the drop-down at the top of the screen.

Select Chart

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.

Select Chart Options

 

Step 4. Select Chart Types and select Heat Map chart.

Chart Types Option

Hover your mouse over the chart thumbnail to see the chart type name.

Time Series Heat Map

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.

Time Series Heat Map selected

 

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

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

add date

 

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.

Select Hour by Day

 

 

 The chart is displayed

Heat Time Map

 

Further Information

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

Related Articles