Bar chart

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

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 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.

...
summarize <kpi1>, <kpi2>, ... by <segmentation1>, <segmentation2>, ...

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

NQL structure for bar charts with enabled default breakdowns

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

...
summarize <kpi1>, <kpi2>, ... 

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

Bar chart column names—regardless of default breakdowns

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

The variable names are formatted with the following heuristic:

• Underscores are replaced with spaces.

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

Configuring visualization fields specific to Bar charts

After selecting the Bar chart option from the Chart type drop-down in the Add widget/Edit a widget pop-up:

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

• KPI

• Line chart

• Single-metric gauge chart

• Multi-metric gauge chart

• Table

• Heading

• Filter widget

• Timeframe picker