A Heatmap is a graphical representation of data where values are depicted using colors. It is particularly useful for visualizing complex data sets and identifying patterns or trends. Each data point or cell in the data set is assigned a color based on its value.
The Heatmap example below is displaying Incidents by Priority by State. Incidents Priorities are located along the Vertical axis and the Incident States are located along the Horizontal axis.
Now, let's look at the Data and Chart options for this Heatmap example. The Heatmap is displaying Incident data so it will be utilizing the Incident table.
Conditions: Setting conditions allows you to query the table you are building the chart off of.
Group by and Second Group by: allows users to organize and aggregate data based on specific fields or criteria. First Group by input will be the data that is along the Vertical axis and the Second group by will be the data that is displayed along the Horizontal axis.
Aggregate Type and Second aggregate type: Refers to a data aggregation method or function used to combine or summarize data from multiple records. They allow users to perform calculations on sets of records to derive meaningful insights. Some common aggregate types include:
Count: Calculates the number of records in a set.
Count Distinct: counts the number of unique, non-duplicated values in a field.
Sum: Adds up the values of a specified field for a set of records.
Average: Computes the average value of a specified field for a set of records.
Minimum: Finds the minimum value of a specified field in a set of records.
Maximum: Determines the maximum value of a specified field in a set of records.
Now, let's look at the styling options for this Heatmap that give it more clarity. First a custom title of "Incidents by Priority by State" is set to provide quick insight into the data the Heatmap is displaying.
Next, Data label toggles are engaged to display values in the Heatmap.
