Configure field overrides

Overrides allow you to customize visualization settings for specific fields or series. When you add an override rule, it targets a particular set of fields and lets you define multiple options for how that field is displayed.

For example, you can override the default unit measurement for all fields that include the text “bytes” by adding an override using the Fields with name matching regex matcher and then the Standard options > Unit setting to the override rule:

Field with unit override

image::screenshot-unit-override-v10.3.png

After you’ve set them, your overrides appear in both the All and Overrides tabs of the panel editor pane:

All and Overrides tabs of panel editor pane

image::screenshot-all-overrides-tabs-v11.png

Supported visualizations

You can configure field overrides for the following visualizations:

Bar chart

Geomap

State timeline

Bar gauge

Heatmap

Status history

Candlestick

Histogram

Table

Canvas

Pie chart

Time series

Gauge

Stat

Trend

Override rules

You can choose from five types of override rules, which are described in the following sections.

Fields with name

Select a field from the list of all available fields. Properties you add to this type of rule are only applied to this single field.

Fields with name matching regex

Specify fields to override with a regular expression. Properties you add to this type of rule are applied to all fields where the field name matches the regular expression. This override doesn’t rename the field; to do this, use the Rename by regex transformation.

Fields with type

Select fields by type, such as string, numeric, or time. Properties you add to this type of rule are applied to all fields that match the selected type.

Fields returned by query

Select all fields returned by a specific query, such as A, B, or C. Properties you add to this type of rule are applied to all fields returned by the selected query.

Fields with values

Select all fields returned by your defined reducer condition, such as Min, Max, Count, Total. Properties you add to this type of rule are applied to all fields returned by the selected condition.

Examples

The following examples demonstrate how you can use override rules to alter the display of fields in visualizations.

Example 1: Format temperature

The following result set is a data frame that consists of two fields: time and temperature.

time temperature

2020-01-02 03:04:00

45.0

2020-01-02 03:05:00

47.0

2020-01-02 03:06:00

48.0

You can apply field options to each field (column) of this structure to alter the way its values are displayed. For example, you can set the following override rule:

  • Rule: Fields with type

  • Field: temperature

  • Override property: Standard options > Unit

    • Selection: Temperature > Celsius

This results in the following table:

time temperature

2020-01-02 03:04:00

45.0 °C

2020-01-02 03:05:00

47.0 °C

2020-01-02 03:06:00

48.0 °C

In addition, the decimal place isn’t required, so you can remove it by adding another override property that changes the Standard options > Decimals setting from auto to 0. That results in the following table:

time temperature

2020-01-02 03:04:00

45 °C

2020-01-02 03:05:00

47 °C

2020-01-02 03:06:00

48 °C

Example 2: Format temperature and humidity

The following result set is a data frame that consists of four fields: time, high temp, low temp, and humidity.

time high temp low temp humidity

2020-01-02 03:04:00

45.0

30.0

67

2020-01-02 03:05:00

47.0

34.0

68

2020-01-02 03:06:00

48.0

31.0

68

Use the following override rule and properties to add the Celsius unit option and remove the decimal place:

  • Rule: Fields with type

  • Field: temperature

  • Override property: Standard options > Unit

    • Selection: Temperature > Celsius

  • Override property: Standard options > Decimals -Change setting from auto to 0

This results in the following table:

time high temp low temp humidity

2020-01-02 03:04:00

45 °C

30 °C

67 °C

2020-01-02 03:05:00

47 °C

34 °C

68 °C

2020-01-02 03:06:00

48 °C

31 °C

68 °C

The temperature fields are displaying correctly, but the humidity has incorrect units. You can fix this by applying a Misc > Percent (0-100) override to the humidity field. This results in the following table:

time high temp low temp humidity

2020-01-02 03:04:00

45 °C

30 °C

67%

2020-01-02 03:05:00

47 °C

34 °C

68%

2020-01-02 03:06:00

48 °C

31 °C

68%

Add a field override

To add a field override, follow these steps:

  1. Navigate to the panel to which you want to add the data link.

  2. Hover over any part of the panel to display the menu icon in the upper-right corner.

  3. Click the menu icon and select Edit to open the panel editor.

  4. At the bottom of the panel editor pane, click Add field override.

  5. Select the fields to which the override will be applied:

    • Fields with name

    • Fields with name matching regex

    • Fields with type

    • Fields returned by query

    • Fields with values

  6. Click Add override property.

  7. Select the field option that you want to apply.

  8. Continue to add overrides to this field by clicking Add override property.

  9. Add as many overrides as you need.

  10. When you’re finished, click Save to save all panel edits to the dashboard.

Edit a field override

To edit a field override, follow these steps:

  1. Navigate to the panel to which you want to add the data link.

  2. Hover over any part of the panel to display the menu icon in the upper-right corner.

  3. Click the menu icon and select Edit to open the panel editor.

  4. In the panel editor pane, click the Overrides tab.

  5. Locate the override you want to change.

  6. Perform any of the following tasks:

    • Edit settings on existing overrides or field selection parameters.

    • Delete existing override properties by clicking the X next to the property.

    • Delete an override entirely by clicking the trash icon at the top-right corner.

The changes you make take effect immediately.