Bar Chart Property Reference

In the widget edit menu (Figure 196, “Edit Widgets”) click the widget icon to configure the following properties.

General properties:

  • Title

    The title of the widget as displayed in the dashboard. As in the example Figure 200, “Bar Chart”, it could be HTTP Methods.

  • Description

    The description of the bar chart. This is free form text supporting markdown syntax. For example, This chart shows all HTTP methods, except PUT and HEAD.

    This same description will appear in the dashboard as a tool-tip by hovering over the question mark on top of the widget.

Default time properties. The default widget time only works when Shared time is toggled off by default. Save the dashboard to set the current time selection as the default.

  • Time

  • Start

  • End

In the widget side panel (Figure 197, “Widget menu options”), click the brush Styling icon to configure the following properties.

  • Layout

    • Type

      • Grouped — places series next to each other on a group for each category

      • Stacked — places series on top of each other for each category

    • Orientation sets the bars orientation as:

      • Vertical

      • Horizontal

  • Data Mapping

    • Category displays values from the mapped field (column) by creating a category for each unique value in this column. If multiple fields define the category, the chart creates a category for each unique value combination. If left empty, the chart automatically selects the category field from the query result.

    • Series definition sets how series are created from the data. Valid options include:

      • Auto analyzes the query result to determine the series definition.

      • Fields Each series is defined by a field (column) where the column header is the series name and the cell values are the series values.

      • Field values creates series names from the value of a field (column) and a secondary column defines the series values. When multiple fields define the series, the chart creates a series for each unique value combination.

    • Series The fields used to generate series. The interpretation depends on the series definition.

    • Value When Series definition is set to Field values, this field defines the series values.

    • Max series (bars) limits the number of series shown in a category. Series with the lowest cumulative sum across categories are grouped into one series called "Other".

  • Title formatting Option available from version 1.210

    Controls the size of the axis and legend tiles. Options are:

    • Small

    • Medium

    • Large

  • Line overlay

    Optionally adds a line overlay in the chart. Some properties in this section vary based on the Series definition selection.

    • Series allows selecting the field series to be displayed as lines. Only applies when Series definition is Fields.

    • Value is the field that defines a secondary metric used to generate lines. Only applies when Series definition is Field values.

    • Right axis adds a separate axis on the right for the line marks. When this option is cleared, the chart uses the left axis to display both bar and line values.

  • Category axis

    • Show title checkbox to show the title for the category (horizontal) axis.

    • Title gives a title to the vertical axis.

    • Text anchor controls where the labels are positioned under each bar. Valid options are:

      • Left will bring labels closer to the bars.

      • Center

      • Right

    • Angle

      Modifies the angle of the label displayed under each bar.

    • Max length

      Sets the space (in pixels) between labels and the widget's bottom edge. Increasing this value reduces the graph's size.

  • Value axis (left)

    • Show title shows the title chosen for the value axis on the left.

    • Title gives a title to the value axis.

    • Type The scale type for the axis. Valid options are:

      • Linear — a quantitative scale that preserve proportional differences.

      • Logarithmic — a nonlinear quantitative scale particularly useful for plotting data that varies over multiple orders of magnitude.

    • Format value — The available units that can be used to express values. Valid options are:

      • Raw shows the number without formatting (for example, 4987).

      • Abbreviated shows the number abbreviated as thousands (K), millions (M), billions (B), or trillions (T).

      • Metric shows the number abbreviated with metric (SI) prefixes.

    • Normalize checkbox — only available in stacked charts with Value axis set to Linear, allows for data normalization.

  • Value axis (right) This section only applies and is visible in the UI when Line overlay has been configured to have a right axis.

    • Show title shows the title chosen for the value axis on the right.

    • Title gives a title to the value axis.

    • Type The scale type for the axis. Valid options are:

      • Linear — a quantitative scale that preserves proportional differences.

      • Logarithmic — a nonlinear quantitative scale particularly useful for plotting data that varies over multiple orders of magnitude.

  • Legend toggle which allows showing or hiding the legend in the chart. If selected, it prompts the following properties:

    • Labels Valid options are:

      • Truncate — shortens the length of the series for a better visualization within the chart. It is used in case of long labels that would exceed the maximum space allowed in the chart. It is the default option. Hover the mouse over a label, then press and hold ALT to momentarily see the full series.

      • Show full — shows the full name of the series, that is, the entire value is displayed in the label or tool-tip. In case of very long labels, it might affect their visibility within the chart. Hover the mouse over a label, then press and hold ALT to momentarily see the truncated series.

    • Position sets the position of the legend in the chart. Valid options are:

      • Right

      • Bottom

    • Show Title checkbox

      Allows to show or hide the legend's title.

    • Title

      Text field to enter the desired title for the legend when Show Title is ticked.

  • Colors

    • Palette controls widget colors. Select Inherit to apply the dashboard color scheme, or select Custom to define unique colors for this widget.

  • Bars

    • Show value on bars checkbox shows the given value for each bar.

    • Category padding

      Use this setting to control the distance between categories in the chart.

    • Series padding

      Use this setting to control the distance between bars within a category.

  • Sorting

    The default sorting uses the order categories are presented in the query result. Available sorting methods are:

    • By series value

      Specifies the name of the series to get the value from.

    • By label Option available from version 1.212 Sorts the bars based on the text/values of their labels (categories). It uses "natural ordering" which is more intuitive than strict alphabetical order: for example, text is sorted alphabetically ("Apple" comes before "Banana"); numbers are sorted numerically ("2" comes before "10"); mixed alphanumeric values are sorted intelligently ("Host2" comes before "Host10").

      Valid options are:

      • Ascending

      • Descending

    • Set by query is the default option. It maintains the order from the query results (same as no sorting). Maintaining the query's original order allows you to sort within the query itself instead of applying additional sorting.

  • Series formatting

    Click + Add series configuration to format the selected series, as follows:

    • Name assigns the title you want to see displayed in the chart

    • Label assigns a label to the series

    • Color changes the color of the bar series