Create a Pareto bar data visualization
Use a Pareto bar visualization to Identify the most important dimension in a large set of dimensions. Pareto bar visualization columns show data in descending order. A line shows the cumulative percentage.
Before you begin
Role required: Anyone with access to data can create a visualization of that data on any dashboard that they can edit. Users with the itil, report_user, admin, or viz_creator role can create a visualization in the Visualization Designer. If you create a visualization in the Visualization Designer, it is saved to the Library. For more information on access, see Report_view access control and Platform Analytics roles.
About this task
For information about the use of a Pareto bar visualization in a dashboard, see the Developer Site. This site gives information about Pareto bar data visualization components in the UI Builder, and some configuration options may differ from the Visualization Designer.
Procedure
- Navigate to All > Platform Analytics > Library > Data Visualizations.
- Select New.
-
Select the Pareto bar visualization (
) visualization type.
-
Configure the Header and border. Header and border options are the same for all data sources.
Header and border fields Description Show header The visualization header, including title and icons. Show header separator Option to display a line separating the header from the rest of the component. Chart title Title of the visualization. Description A short overview about the visualization that the end user sees. Wrap title Option to wrap long titles onto a second line. If false, displays an ellipsis to truncate long titles. Wrap labels Select to wrap long elements labels on the axis. Max label size, px Specify the maximum label size for element names on the axis. Default=100 px. Truncation type Specify where to truncate long labels with an ellipsis. Options are Beginning, Middle, and End. Show border Option to display a line around the component. Bare Option to remove padding around data visualization to provide more compact positioning on the page. Only available when Show border is turned off. -
Choose a data source.
For general descriptions of the data sources, see Data sources for data visualizations.
-
Table (available in the base system). When you select a table, you can filter it by custom or preconfigured conditions. Custom conditions can include questions or Service Catalog variables.
Configured report sources appear in the Predefined conditions list. For more information, see Report sources.
To help you create a custom filter, there is a preview list of records that would be included in the visualization. You can change which fields are shown as columns and the width of columns in the list actions. - Indicator (available in the base system). You can filter the indicator scores by breakdowns and elements.Note:Benchmark indicators are not supported.Note:
You might have a multiple select (is one of) or dynamic (is (dynamic)) operator on the breakdown element filter. These operators require the indicator and breakdown to support them. For more information about the configurations that support these operators, see "Is one of" and "Is (Dynamic)" operators on breakdown conditions in data visualizations.
- Usage Insights (available with the User Experience PAR Integration application, to users with a required role). Choose one of up to three KPIs included with this application, depending on the visualization type. For more information, see User Experience Analytics data sources for data visualizations.
Note:You can choose multiple data sources for this visualization. However, all data sources must be of the same type: table, indicator, or Usage Insights. For more information, see Multiple data sources. -
-
Select the options for your data source.
- If your visualization represents table data, go to Table data options for pareto bar visualizations.
- If your visualization represents indicator data, go to Indicator data options for pareto bar visualizations.
- If your visualization represents Usage Insights data, go to Usage Insights for pareto bar visualizations.
-
Under Presentation, provide display and color information.
Under Display settings, you can show the data table. This table shows graph and chart data for easier screen reader access. You can also select whether hovering on a data value opens a tooltip with all the data values or only the details of the selected data value.
Table 1. X-axis options Field [Property] Description Hide axis Hides both the bar metric Y-axis and the pareto Y-axis. Axis style Style of the X axis. - Clean
clean: Adds a straight line to the X axis. - No tick lines
noTicks: Option to remove all marks from the X axis. - Standard
default: Adds a line and tick marks to the X axis.
Note:Only available when Show grid is true for vertical bar visualizations.Axis title (for X axis) Title to display on the horizontal axis of the visualization. Wrap labels Wraps long labels in the horizontal axis. Max label size, px Maximum label size for the horizontal axis, in pixels. Table 2. Y-axis options Field [Property] Description Hide axis Hides both the bar metric Y-axis and the pareto Y-axis. Axis title (for Y axis) Only affects the bar axis and not the Pareto axis. Show grid Adds grid lines to the visualization. This option applies only to the Y axis. Axis style Style of the Y axis. - Clean
clean: Adds a straight line to the Y axis. - No tick lines
noTicks: Option to remove all marks from the Y axis. - Standard
default: Adds a line and tick marks to the Y axis.
Note:Only available when Show grid is true for vertical bar visualizations.Table 3. Legend options Field Description Show legend Option to display the legend. Legend position Legend location relative to the chart: Above, Below, Right, or Left Table 4. Data label options Field Description Show data labels Option to display the score for each data point. Data label position Location of data labels: at the top, middle, or bottom of the bars. Note:Only available when Show data labels is true.Table 5. Color options Field Description Set color type - Default: A color or set of colors that come from the UX Theme that is applied to the instance. For more information, see Working with themes in Next Experience.
- Color palette: List of color palettes to select from predefined system palettes in the Chart Color Scheme [pa_chart_color_schemes] table. For grouped or stacked data, the colors apply in order from highest value to lowest. For multiple data sources, palette colors apply in the order of data sources. For example, the first color of a palette applies to the first data source, and the second palette color applies to the second source. All visualizations that use the same color palette show the same colors, regardless of what data they display.
- Fixed element color: Use a specific color from the Chart Colors table [sys_report_chart_color] for each element. All data visualizations that use fixed element colors show the
same element, such as critical incidents in the Global scope, in the same color.
This option is available only for Table data sources and only if no more than one data source or metric is added, and a Group by is defined.
- Clean
-
Under Chart interaction, set what if anything happens when a viewer clicks a chart or a chart segment on the visualization.
Field Description Allow chart interaction Enable an event to occur when a user clicks in a chart or one of its segments. Action Choose the event that occurs when a user clicks in a chart or one of its segments. Choices depend on the visualization type and data source. Applies only when Allow chart interaction is on. For more information, see Chart interactions in a data visualization.- Go to data view opens the records view in a Core UI list or KPI Details relevant to the associated segment or visualization. Records do not open in Workspace embedded lists.
Not supported for Usage Insights data sources.
- Go to URL opens the specified URL, which can be on the instance or external. You have the option of specifying a page name to appear in the tooltip, for those visualizations with tooltips.
- Drill down to chart (Visualization Designer only) Opens a different data visualization that is filtered by the selected data. You can add a drill-down visualization for
each metric on the parent visualization. Note:The last level of drill down in the Platform Analytics experience is always a Core UI list. Records do not open in Workspace embedded lists.
Drill down to chart supports only table data sources.
- Go to data view opens the records view in a Core UI list or KPI Details relevant to the associated segment or visualization. Records do not open in Workspace embedded lists.
-
Select Save.
Navigate to All > Platform Analytics > Library > Data Visualizations to return to the Data Visualization list.