A Vertical Grouped Bar chart is a type of bar chart where bars are grouped together based on categories, and each group contains multiple bars representing different subcategories or data series.
The Vertical Grouped Bar Chart example below is looking at Incidents by Priority by State.
Now, let's look at the Data and Chart options for this Vertical Grouped Bar Chart. This chart is displaying incident data so the chart is 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.
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.
Sort by and Second Sort by: Allows user to determine the order of the list. Sort by can set as Value Descending, Value Ascending, Alphabetically Descending, Alphabetically Ascending.
Now let's looking at the styling options that have been changed from the default styling settings to give this Vertical Grouped Bar Chart some more clarity. First a custom title of "Incidents by Priority by State" is set to provide quick understanding of the data being displayed on the chart.
Next, the Display Legend and Data values toggles are engaged to display the legend and data values at the bottom of the chart.
Finally, the Labels and Individual Values toggles are engaged to display the values of the bars in the chart.
