Configuring the Pivot Chart 100% Stacked Bar Visualization

The 100% Stacked Bar chart shows how different constituent parts contribute to a whole, with the total size of the whole always normalized to 100%. You can easily compare the relative magnitude of different categories or groups visually.

Each individual bar in the chart represents a total category (the "whole"), and the segments stacked within that bar represent the different sub-categories (the "parts").

Use the chart to compare the relative proportions or percentage distribution of values across different categories. It shows shifts in asset distribution, changes in status over time, or other measures.

Managers can compare the progress of different departments. Instead of absolute task counts, you can view the percentage of solved versus open tasks per department, facilitating easier resource allocation decisions.

You can switch seamlessly between absolute and relative views.

To configure a 100% stacked bar chart:

1. On any editable dashboard, click Add Chart or edit an existing chart.

2. In the Name field, enter a descriptive name for the chart.

3. From the Widget list, select Pivot Chart.

4. Under Visualization, select Stacked.

5. Under Data, select an asset module and the query that will define which assets to include.

6. Under Dimensions Row, select the field whose values will be on the rows of the chart. You can select multiple dimensions.

7. Under Dimensions Column, select the fields whose values will constitute the columns.

8. Under Metrics, select the fields whose value is measured per the axis and the function. Multiple metrics can be configured.

9. Under Calculation, you can configure these options:

   • Use historical data

   • Include entities with no value

     • Display Name - When Include entities with no value is selected, you can set a custom value to display in that table cell.

10. Under Presentation, you can configure these options:

    • Set threshold colors
    • Show title - The chart title in the Name field is displayed on the chart.

11. Under Segment by, select Percentage and Show Percentage. To switch to an absute value bar chart, select Number and Show Number. The chart preview updates with other option selections maintained.

12. Click Save.

Example of a 100% Stacked Bar Visualisation

Here is an example of a 100% Stacked Bar Visualisation.

1. On any editable dashboard, click Add Chart or edit an existing chart.

2. In the Name field, enter a descriptive name for the chart.

3. From the Widget list, select Pivot Chart.

4. Under Visualization, select Stacked.

5. Under Data, select Devices and leave the query empty to include all device assets.

6. Under Dimensions Row, select OS: Type as the axis.

7. Under Dimensions Column, select OS: Distribution.

8. Under Metrics, select Assets as the measure.

9. Under Calculation, you can configure these options:

   • Use historical data

   • Include entities with no value

     • Display Name - When Included entities with no value is selected, you can set a custom value to display in that table cell.

10. Under Presentation, you can configure these options:

    • Set threshold colors
    • Show title - The chart title in the Name field is displayed on the chart.

11. Under Segment by, select Percentage and Show Percentage.

12. Click Save.

Hover over a bar to see the breakdown in both percentage and absolute values.

Exporting Chart Information to CSV

When this chart is exported, the data with the percentage values is exported.