Create a horizontal or vertical bar data visualization
Use bar visualizations to show information in segments that are proportional to the values they represent. Vertical bar and horizontal bar visualizations compare numeric values that represent either nominal or ordinal data.
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. When 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.
For more information about this visualization type, see Bar Visualization Overview on the ServiceNow Developer Site. This site gives information about Horizontal and Vertical bar data visualization components in the UI Builder, and some configuration options may differ from the Visualization Designer.
About this task
In general, use horizontal bars to graph nominal data, such as the number of users in each assignment group. Use vertical bars to graph ordinal data, such as the number of open incidents in different age buckets. For information about the use of a Bar visualization in a dashboard, see the Developer Site.
Procedure
Navigate to All > Platform Analytics > Library > Data Visualizations, or open an in-line dashboard and select Edit.
Select Create data visualization.
Select the horizontal bar (
horizontal bar icon\) or vertical bar \(\[Omitted image "inline-data-vis-bar-vertical.png"\] Alt text: vertical bar icon\) visualization type.
- Configure the Header and border. Header and border options are the same for all data sources.
| Header and border fields | Description |
|---|---|
| Show border | Option to display a line around the component. |
| 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. |
| Title alignment | Choose Start to align the title with the start of line, End to align it with the end of the line, or Center for center alignment. |
| Description | A short overview about the visualization that the end user sees. Descriptions help users find the visualization. |
| 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. |
| Line of truncation | Specify where to truncate long labels with an ellipsis. Options are 1, 2, and 3. |
| Bare | Option to remove padding around data visualization to provide more compact positioning on the page. Only available when Show border is turned off. |
| Show refresh option | Option to show or hide the refresh option from data visualizations. If cache is enabled on a dashboard, the Refresh option is always hidden. |
| Show export options | Option to show or hide the visualization's export types. |
| Header background color | Specify the color behind the title of the visualization. |
| Title color | Specify the text color of the title. The default title color is black, but you can choose a color that contrasts better with the header background. Only available when Header background color is selected. |
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.
Preview record list for table source data visualization with list actions shown.
- Indicator \(available in the base system\). You can filter the indicator scores by breakdowns and elements. Automated indicators can be configured with selected breakdowns. Formula indicators inherit their breakdowns from the parent indicators. Data snapshots indicator breakdowns are configured in the indicator. In both cases, only those breakdowns are available when you configure a visualization based on those indicators.
**Note:** Benchmark indicators are not supported.
Conditional filter for indicator data source on data visualization.
**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](performance-analytics/condition-operators-ind-bkdowns.md).
Indicator types include Automated, Formula, and Manual indicators as well as Automated and Formula Data Snapshots. The Indicator Preview shows an example of the visualization and a list of the indicator's properties.
Indicator preview example with visualization example and list of properties including source type, indicator source, indicator type, additional conditions and available breakdowns.
- 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 [Usage Insights data sources for data visualizations](uxa-data-sources.md).
**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](multiple-data-sources.md).
Select the options for your data source.
- If your visualization represents table data, go to Table data options for horizontal and vertical bar visualizations.
- If your visualization represents indicator data, go to Indicator data options for horizontal and vertical bar visualizations.
- If your visualization represents Usage Insights data, go to Usage Insights data options for bar visualizations.
- Under Presentation, provide display and color information.
Note: For horizontal bar visualizations, the X axis is the primary. For vertical bar visualizations, the Y axis is primary.
| Field | Description |
|---|---|
| Display settings | |
| Show only one data point in tooltip | When turned on, the tooltip shows only the data point being hovered over. When turned off, the tooltip shows all data points. Default: Off, except when zoom is 400%, which automatically turns it on. |
| Show data table | Shows a table with chart and graph data for easier screen reader access. Data includes the percentage of the total for each value, when appropriate. |
| Show % of total in tooltip | Enable to show the percentage each data point contributes to the total alongside absolute values in the tooltip. |
| X and Y axis \(Some options are only available on the primary or secondary axis. On horizontal bar visualizations, the X axis is primary. On vertical bar visualizations, the Y axis is primary.\) | |
| Hide axis | Option to hide the primary axis. |
| Axis title | Title to display on the X or Y axis. |
| Axis range - from | Starting point for the values on the primary axis. |
| Axis range - to | End point for the values on the primary axis. |
| Axis position | Position of the primary axis. Options include:- Left - Right This property applies only when Hide axis is false. If there is more than one primary axis, such as multiple Y axes on a vertical bar visualization, you can set each axis position separately. |
| Show grid | Shows a grid of fine lines perpendicular to the primary axis, to help align values against that axis. |
| Axis style | Style of the primary axis. - Clean `clean`: Adds a straight line to the primary axis. - No tick lines `noTicks`: Option to remove all marks from the primary axis. - Standard `default`: Adds a line and tick marks to the primary axis. |
| Wrap labels | Wrap long labels in the secondary axis. |
| Max label size, px. | The length in pixels at which the label of the secondary axis is wrapped or truncated. |
| Truncation type | Determines where to truncate long labels for the secondary axis. Options include:- Start `start` - Middle `middle` - End `end` |
| Legend | |
| Show legend | Option to display the legend. Activated automatically at 400% zoom. |
| Show legend value | Option to display the value corresponding to the area of the chart you hover on. The value displays as a tooltip and in the chart legend. |
| Legend position | Legend location relative to the chart: Above, Below, Right, or Left |
| Horizontal alignment | Horizontal alignment of elements in the legend: Start, Center, or End |
| Max legend item width, px | Number of pixels after which the item in the legend is truncated. |
| Expand legend vertically | When turned on, the legend contents take as much space as needed to fit the legend without scrolling, instead of the maximum 2 lines. |
| Data label | |
| Show data labels | Option to display the score for each data point. |
| Colors | |
| Set color type | Type of color scheme to apply to the component. Options include: - 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. - Single color/Colors per metric: Select a single color in the Set value color field. Interacting with that field opens a selector where you can choose the color from either a set of icons or from a list. You can also search for a color. Entering a search value has the selector show you a list of colors filtered by that search value. If the visualization has more than one metric, you see the Colors per metric option instead. This option lets you select a single color for each metric.
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. |
- 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 visualization or one of its segments. |
| Action | Choose the event that occurs when a user clicks in a visualization 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.
Note: Apply as filter is available only for table and indicator data sources. It does not work when the Group by field is a duration field.
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. |
Select Save.
Navigate to All > Platform Analytics > Library > Data Visualizations to return to the Data Visualization list.
What to do next
- Add a visualization to a dashboard from the Visualization Designer
- Share a data visualization in the Visualization Designer
Table data options for horizontal and vertical bar visualizations
When you select a table data source for a horizontal or vertical bar visualization, the following Data configuration options are available.- Indicator data options for horizontal and vertical bar visualizations
When you select an indicator data source for a horizontal or vertical bar visualization, the following Data configuration options are available. - Usage Insights data options for bar visualizations
When you select a Usage Insights data source for a horizontal or vertical bar visualization, the following Data configuration options are available. - Following filters per metric
If you are showing multiple metrics in a horizontal or vertical bar visualization, you can have filters on a dashboard apply only to specific metrics. - Bar visualization examples
Bar visualizations enable you to show the comparative size or frequency of different categories or groups, for example, sales in different regions or over different periods of time.
Parent Topic:Creating data visualizations