Creating stacked bar charts

Use stacked bar charts to compare categories of data, such as unencrypted devices by location, with the ability to break down and compare the parts to the whole.

Mock-up of stacked bar chart

For example, in a stacked chart, the unencrypted devices in a location can be broken down into segments that show the names of users who have an unencrypted device in a specific location.

Procedure

1. From the menu, click Dashboards. 
2. Click Add Widget.
3. Select Stacked bar chart   as the chart type. 
4. Enter the chart name.
5. Choose who can view the chart. By default, the chart is visible to all users who have dashboard privileges.
6. Select Allow table view. When selected, users can switch from chart to table view.

Data source and Measurement y-axis

1. From the Object list, select a module such as Assets.
2. Select an object or a saved search to add data to the chart.
3. Enter the name of the label that you want to show on the y-axis.
4. From the Calculation type list, choose an option.
5. From the Field list, select a field.

Dimension x-axis

1. Enter the name of the label that you want to show on the x-axis.
2. From the Field list, select a field.
3. In the Empty value title field, enter the name of the label that you want to show when no data is available.
4. Choose the selection type, the number of items that you want to be shown in the chart, and the display order.
5. Optional: Select Other.  

Decomposition

1. From the Field list, select a field. Let's say you want to create a stacked bar chart that shows the number of unencrypted devices on the y-axis, the location on the x-axis, and you want to break down each column by the name of the user that has an unencrypted device. In this scenario, you select Assigned to as the field. 
2. In the Empty value title field, enter the name of the label that you want to show when no data is available.
3. Click SAVE.

Tip
The bar chart is created. You can click on the bars to get a detailed view of the information.

Reference information

General information

Chart name

The name of the chart.

Visible to

Specify who can view the chart.

Data source

You can select an attribute of an object or you can use a saved report to filter the data that is shown in the chart.

Measurement (Y-Axis) settings

Name

The name of the  label for the y-axis.

Calculation type

You can choose total, sum, or average. If you select sum or average,  you must select the field.

Dimension (X-Axis)

Name

The name of the label for the x-axis.

Field

The data source for x-axis values.

Empty Value Title

The name of the label for the column in bar charts or slice in donut charts that you want to show when values aren't retrieved. 

Selection Type

You can choose one of the following options:

• Top by. Select items with the highest values.
• Bottom by. Select items with the lowest values.
• Manual. Choose the items that you want to show in the chart.

Show

Available for top by and bottom by selection and for bar charts, stacked bar charts, and donut charts.

Specify the number of bars or slices that you want to show in the chart. 

Display Order

Choose one of the following display orders:

• A-Z
• Z-A
• Ascending
• Descending

Empty value title

If the field that you selected for the x-axis, doesn't contain a value, the bar shows the average, sum, or total, depending on the calculation type that you chose, of the fields that contain no values. 

Other

Shows aggregated information that was not selected by user, but is stored in the system.

Decomposition

For stacked bar charts, you add a right-sidebar that shows additional information about the chart. Let's say, you create a stacked bar chart for assets by location. And, you want to have a breakdown of the assets that are shown by status.

In the Decomposition section on the Widget Configuration field, you select Status as the Name.

You can also add an Empty Value Title. For example, if the status value for an asset is unavailable, you might add Status Unavailable in the Empty Value Title field.