New DEX certifications launch at Experience '26. Get certified and learn from experts in your field.
Register now
Ctrlk
LearnDocumentationSupportCommunity
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Bar chart

Bar charts facilitate the viewing of data broken down by segmentation.

Bar chart example

The NQL query requires a segmentation label and an aggregation.

Data shape

<segmentation 1>, (<segmentation 2>, <segmentation 3>,...), <kpi 1>, (<kpi 2>, <kpi 3>, ...)

Bar charts NQL query structure depends on the following cases:

  • NQL for bar charts with default breakdown disabled

  • NQL for bar charts with default breakdowns enabled

NQL structure for bar charts with enabled default breakdowns

When configuring visualization fields specific to the bar chart, enabling default breakdowns adds a dropdown with a preset list of breakdowns above the bar chart.

The system highlights any breakdowns in the dropdown that contain outliers, which may help identify relevant issue patterns. For example, in the image below, Location type.

If you Enable default breakdowns, you must follow the NQL structure below.

In this case, you can omit by <segmentation1>,... from the query since the system defaults to the options in the breakdown dropdown, meaning any by clause in the query will be ignored. See the Preview section in the image below.

Refer to the Live Dashboards NQL examples documentation for query examples.

NQL structure for bar charts with disabled default breakdowns

When configuring visualization fields specific to the bar chart, if you do not Enable default breakdowns you must follow the NQL structure below.

In this case, you should always specify by <segmentation1>,... in the query.

Refer to the Live Dashboards NQL examples documentation for query examples.

Bar chart column names

The variable names in the NQL query are used as labels for the columns.

Column names

The variable names are formatted with the following heuristic:

  • Underscores are replaced with spaces.

  • The first character of the variable is changed to uppercase.

In bar-chart widgets on live dashboards, you can sort the results by clicking on the chart column headers.

Sorting bar chart results by column data.

Configuring visualization fields specific to Bar charts

Refer to the Managing Live Dashboards documentation to learn how to fill in the remaining configuration fields that are not specific to this widget.

After selecting the Bar chart option from the Chart type drop-down, determining if you should enable default breakdowns, and defining the chart NQL query:

  1. Give the widget a Title (optional).

  2. Enter a Widget description (optional) to explain, for example, how the metric should be interpreted, calculated, or any subtleties to the metric.

    • The widget description appears when hovering over the info icon next to the bar chart widget in the dashboard.

  3. Determine if the bar-chart results update according to the selected Global timepicker (timeframe) and/or Global filters applied to the dashboard.

    • In bar-chart widgets on live dashboards, the action menu lets you either Show all results or Show filtered data—based on global dashboard filters.

  4. Define the Maximum number of rows to be displayed in the container.

    • The dashboard displays a Load more button if the chart results exceed the defined limit.

RELATED TOPIC

Last updated

Was this helpful?