Overview
The 100% Stacked Chart is a section designed to visualize aggregated Attribute/Metric data in a stacked column format, showcasing proportional data and percentages of the whole. The chart consists of columns based on categories such as Region, Workstream, Lifecycle Stage, or Strategic Objective alignment. The column slices can be based on an Association, Checkbox attribute, Item Name, or Pick List attribute.
When reviewing charts, you can:
- Hover over any data series in the chart to view the value and percentage for that slice.
- Export your chart as a PNG file by selecting the settings gear on the section and choosing the “Export” option.
Adding a Chart
- On a layout in Configure mode, open the Add Section dialog.
- Select the Chart option from the left panel.
- Choose the 100% Stacked option under the Multiple Axis category. The Chart will be added to the layout.
Configuring 100% Stacked Chart Settings
After successfully creating a new Chart section, follow the steps below to fully configure the section. These options can be edited on an existing Chart section via the Settings dialog while in Configure mode on a layout.
Data
- Click on the Settings icon (gear) on the Section Controls of the Chart.
- Define the Datasource: the template(s) where the data is defined. In the Type field, open the drop-down menu to see all available templates. Select one or more templates to define the type.
- Optionally, locked Filters can be set when configuring a Chart section. These filters will apply to all content in the Chart and cannot be seen or edited by end users viewing the Chart. Page Filters can be referenced using the injected expression syntax: {!toFilter(API_Name__f)}. Refer to the Page Filtering article for more details on configuration.
- The Attribute drop-down menu will show attributes from the template(s) type selected. Select an Attribute.
- If the Attribute has Data Sets enabled, define the Data Set. Otherwise, it will default to ‘Actual’.
- Enter a value into the Value field. Filtering syntax can be found here.
- Add another filter by clicking Add Filter.
- Remove a filter by clicking the trash icon next to the filter.
Display
On the Display tab, you can select the values to display, format the values, and configure additional chart display options.
Follow the steps below to configure the Chart Display:
- Define the X Axis grouping (group by either Item Name, Association, Pick List attribute, or Checkbox attribute). Optionally, format these values to reorder, change labels or hide certain values.
- Determine the Y Axis Column Values in the Chart. Add as many values as desired by selecting the ‘+ Add Value’ option. The aggregate attribute/metric values are derived from the specified template(s). Select the Attribute (Number, Name/Value Pick List, Name/Value/Icon Pick List) or Metric and Data Set.
- Select a Slice By from the drop-down menu. This setting determines the slices of the Chart. You can slice by Association, Item Name, Pick List, or Checkbox. Depending on your selection, you will be able to format the values via the toggle.
- Sliced by Association: Enable the ‘Label for Empty Values’ checkbox to include items with empty Association values and define their Label & color.
- Sliced by Pick List: Pick List options can be re-ordered by clicking and dragging on the grabber icon. Individual Pick List options can be disabled from being displayed in the Chart by de-selecting the checkbox left of the Value. Labels and colors can be modified as well.
- Sliced by Checkbox: Options can be re-ordered by clicking and dragging on the grabber icon. Labells and colors can be set as well.
- When slicing by an Item Name or Association, the Out-of-the-box Color attribute will be used for the respective work item’s value in the chart.
- Note: If multiple Values are selected then the Slice By will be the Value Name.
- Under the Options accordion, you can define whether the chart values or labels are displayed at all times.
- Save and Publish your changes.
Drill Down
Drill Down is always enabled on all 100% Stacked Charts, displaying a table of work items based on the selected column slice.
When selecting a column slice, the dialog of work items will display the selected option within the breadcrumb trail.