A Horizontal Grouped Bar Chart is a type of bar chart that displays grouped bars horizontally, making it easy to compare values within and across different groups. In this chart, each group consists of multiple bars representing individual categories or sub-groups, and the bars within the same group are typically grouped closely together.
The Horizontal Grouped Bar Chart example below displays incidents by state by priority.
Let's look at the Data and Chart options for this Horizontal Stacked Bar Chart. This chart is displaying incidents by state by priority, so this chart will be using the incident table.
Conditions: Setting conditions allows you to query the table you are building the chart off of. This Horizontal Grouped Bar Chart has two conditions set. One is Active is true and the other is State is one of New, In Progress, or On Hold.
Group by: allows users to organize and aggregate data based on specific fields or criteria. The Group by is set to State therefore displaying the different states of incidents along the Y-axis.
Second group by: allows users to organize and aggregate data based on specific fields or criteria. Second group by is set to priority, therefore the incidents are grouped together by priority and then state, and displayed as the bars along the X-axis.
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.
Maximum: Determines the maximum 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.
Let's look at the style settings for this Horizontal Grouped Bar Chart that have been changed from the default style settings that will give this chart more clarity. First a custom title is set to Incidents by State by Priority to provide quick understanding of what information the chart is displaying.
Next, the the Display legend and Data values toggles are engaged to display the Legend along with the Data values at the bottom of the chart.
Next, click the Data Labels dropdown, and engage the Labels, Total Data Value, and Individual Values toggles.
Finally, the Display grid toggle is engaged.
