The Heat Map widget shows the relationship between two dimensions in a matrix. The first dimension represents the rows in the matrix, the second dimension the columns. The requirements for Heat Map widgets are the same as described above for the Pie Chart widget with these exceptions:
-
Heat Map queries, or Dataspies if you use a grid, must return two columns but may return additional columns up to a total of 50.
-
The first column defines the values for the first dimension.
-
The remaining columns must be numeric and determine the value displayed in the matrix cell. For these columns it is recommended you define a column alias. This alias will be displayed on top of the matrix above each column and identifies the second dimension.
Heat Map widgets are also equipment or organization sensitive, like the Pie Chart widget.
For some sample queries to get you started see later in this document.