A Vertical Stacked Bar Chart is a type of bar chart where multiple data series are represented as stacked bars, each segment of the bar corresponding to a sub-category or a part of the whole. These charts are used to visualize the total and how it is divided among different components.

For the Vertical Stacked Bar Chart example below, we are looking at projects by state by priority. The x-axis shows the state of the project, and the segments of bars shows the priority of each incident in that state.

Let's look at the Data and Chart options for this Vertical Stacked Bar Chart below.

This Vertical Stacked Bar Chart is looking at projects, so we want data pulled from the project table, as pictured below.

Conditions: Setting conditions allows you to query the table you are building the chart off of, in this case, the project table. The chart only wants to see active incidents so the conditions are set to Active is true.

Group by: Allows users to organize and aggregate data based on specific fields or criteria. For this example we want the projects 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 segments on the Vertical Stacked Bar 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 segments of the Vertical Stacked Bar 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.