A Horizontal Normalized Stacked Bar Chart is a type of bar chart that represents data in a horizontal orientation where each bar is composed of multiple segments stacked on top of each other. The height of each stacked bar represents a total value, and each segment within the bar represents a proportion of that total value. Additionally, the bars are normalized, meaning that each bar is scaled to have a total height of 1, making it easier to compare proportions across different categories or groups.
The Horizontal Normalized Stacked Bar Chart example below is looking at Incidents by Priority by State.Incident Priorities are represented along the Horizontal axis and the Incident States are represented by the bar segments.
Now, let's look at the Data and Chart options for the Horizontal Normalized Stacked Bar Chart example. The chart is displaying Incident data so it will be 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. Group by determines what will be displayed along the horizontal axis and the Second group determines what data will be represented as the segments of the bars in the chart.
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 look at the styling options that have been changed from the default settings to provide more clarity to this chart. First a custom title of "Incidents by Priority by State" to provide quick understanding of the data the chart is displaying.
Next, the Display Legend and Data percentages toggles are engaged to display the legend along with data percentages at the bottom of the chart.
Finally, the Data Labels and Data Values toggles are engaged to display the values of each bar in the chart.
