Waffle Charts use a grid of small, equal-sized squares to represent the proportion of a whole. Each square in the grid typically represents a unit or percentage of the total, and the filled squares visually indicate the magnitude or proportion of a category or value.

For this example we are looking at active incidents by priority. The waffle chart below will provide data that is easily and quickly consumed.

Let's look at the data and chart options for this waffle chart.

This Chart is displaying incidents, so we want to use the incident table.

Conditions: For this example we only want to look at active incidents. The conditions in the Chart Options is set so that only active incidents data is being retrieved.

Group By: Use Group By to determine what the squares in the Waffle Chart will represent. For this example the Group By input is set to priority, therefore the squares of the Waffle Chart are grouping based on the priority of each incident. Each square in the waffle chart represents one percent of the whole waffle chart.

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:

Aggregate Field: refers to a field that displays an aggregated value based on the data from other fields. These fields are used to perform calculations or summarize data from related records.

Now let's look at the styling for this Waffle Chart. A few changes were made to the default style setting to make the chart easily consumed.

A custom title of "Incidents by Priority" is set to provide a quick understanding of what data the waffle chart is displaying.

Next the Display Legend toggle is engaged to display the legend of the chart. The legend shows what each priority color in the Waffle Chart represents. Next the data percentage toggle is engaged to display the percentage of incidents by priority.