A Treemap Chart uses nested rectangles to represent data, with larger rectangles indicating higher values and smaller rectangles indicating lower values. This makes it easy to compare the relative sizes of different categories or subcategories within the hierarchy and identify areas of focus or interest.
The Treemap example below is displaying open incidents by priority by state.
Let's look at how the Data and Chart options are set up to display this data. This Treemap is displaying incident data, therefore the incident table is being utilized.
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.
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.
In the style settings a custom title of "Open Incidents by Priority by State" is set to provide a quick understanding of the data being displayed.
