Bar Matrix Charts uses a matrix or grid layout to represent data using bars. Each cell in the matrix corresponds to a unique combination of two categorical variables, and the height or length of the bar in each cell indicates the value of a quantitative variable.

For the Bar Matrix Chart example below we are looking at incidents by state by priority.

Each chart represents the state of the incident, wether it's cancelled, on hold, in progress, or new. The bars represent the priority of each incident.

Now let's look at data and chart options for this Bar Matrix Example.

Conditions: Setting conditions allows you to query the table you are building the chart off of, in this case, the Incident table.

Group by: allows users to organize and aggregate data based on specific fields or criteria. For this example we want the incidents grouped by state by priority. So for our Group by input we select state, which first groups incidents by state.

Second Group by: This input groups and displays the data as the bars on the Bar Matrix Chart. For this example the second group by input is set to priority. So the Priority is first grouped with the corresponding state of the incident and then the different levels of priority are represented by the bars.

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.