About field overrides

Overrides allow you to change the settings for one or more fields. Field options for overrides are the same as the field options available in a particular visualization. The only difference is that you choose which fields to apply them to.

For example, you could change the number of decimal places shown in all numeric fields or columns by changing the Decimals option for Fields with type that matches Numeric.

Example 1: Format temperature

Let’s assume that our result set is a data frame that consists of two fields: time and temperature.

timetemperature
2020-01-02 03:04:0045.0
2020-01-02 03:05:0047.0
2020-01-02 03:06:0048.0

Each field (column) of this structure can have field options applied that alter the way its values are displayed. This means that you can, for example, set the Unit to Temperature > Celsius, resulting in the following table:

timetemperature
2020-01-02 03:04:0045.0 °C
2020-01-02 03:05:0047.0 °C
2020-01-02 03:06:0048.0 °C

In addition, the decimal place is not required, so we can remove it. You can change the Decimals from auto to zero (0), resulting in the following table:

timetemperature
2020-01-02 03:04:0045 °C
2020-01-02 03:05:0047 °C
2020-01-02 03:06:0048 °C

Example 2: Format temperature and humidity

Let’s assume that our result set is a data frame that consists of four fields: time, high temp, low temp, and humidity.

timehigh templow temphumidity
2020-01-02 03:04:0045.030.067
2020-01-02 03:05:0047.034.068
2020-01-02 03:06:0048.031.068

Let’s add the Celsius unit and get rid of the decimal place. This results in the following table:

timehigh templow temphumidity
2020-01-02 03:04:0045 °C30 °C67 °C
2020-01-02 03:05:0047 °C34 °C68 °C
2020-01-02 03:06:0048 °C31 °C68 °C

The temperature fields look good, but the humidity must now be changed. We can fix this by applying a field option override to the humidity field and change the unit to Misc > percent (0-100).

timehigh templow temphumidity
2020-01-02 03:04:0045 °C30 °C67%
2020-01-02 03:05:0047 °C34 °C68%
2020-01-02 03:06:0048 °C31 °C68%