Stacked Bar Chart

A Stacked Bar Chart is a type of bar chart where each bar is divided into multiple segments (or "stacks"), with each segment representing a different category or part of the whole. The total height  of each bar represents the combined value of all categories within that bar. This chart is useful for comparing both overall totals and the contributions of individual components within each category.

The X-Axis shows the main chart field and the Y-Axis shows the cumulative value, representing the sum of all segments for each bar.

Creating a Stacked Bar Chart

• Select StackedBar as the Chart Type.

• This chart has two unique features that can be toggled on or off with checkboxes:

  1. Show Table: When enabled, this feature displays a table alongside the chart. The table provides detailed information on each stacked bar, with columns and rows representing the main and extra chart fields. Each cell shows the value for each combination (i.e., the value of each bar segment).

  2. Show Subtotals: This option adds subtotals for each row and column in the table, offering a quick overview of totals across categories for deeper insights.

• The Main Chart Field lets you choose the primary field for your stacked bar chart, which forms the values along the horizontal axis and the whole bar represents this main category.

Note:

When the Main Chart Field is a datetime field, you can set the time interval for displaying it on the axis. The available interval options are Year, Month, Day and Year and Month, allowing you to customize the granularity of data shown on the chart.

• Choose the Extra Chart Field that forms the segments within the bar. This will be the sub-category for the stacked bar chart.

• By default, the system assigns colors to the chart. However, if you want to customize colors for specific values, use the Chart Color Mapping option. If there’s an Extra Chart Field, color mapping will apply to its values; otherwise, it applies to the Main Field. Click the + icon to add a new color mapping, then:

  1. Select the value you want to color.

  2. Use the color picker to choose the color.

• Aggregate Type: Choose the type of statistic that will be used to create the chart. The available options are:

  1. Count displays the number of objects.

  2. Sum shows the total of all values.

  3. Average displays the average value of the data.

When "Sum" or "Average" is selected, an additional dropdown appears, allowing you to choose the specific field for these calculations.

• Date Range: To narrow down data to a specific period, select a date range. You can either set a custom interval or pick a predefined interval, such as the current year, month, week, or day.

• Date Field: After selecting a date range, choose the relevant date field for which you want to apply the time interval.

Stacked Bar Chart

This is a stacked bar chart displaying the count of RMAs over various time periods (from 2020- 10 to 2023-01). X-axis represents different time periods when these RMAs were recorded, ranging from October 2020 to January 2023. Y- axis shows the total count of RMAs, with values going up to a maximum of 18. Each bar represents the count of RMAs created during a specific month. The colors within each bar indicate different states. The legend identifies which color corresponds to each province, allowing you to toggle individual provinces on or off to adjust the chart view. For a more detailed breakdown, the accompanying table displays the data for each bar segment, making it easy to analyze RMAs by both time and location.