Can I choose the value for comparison in a Single Value Visualization?

[LookerExperts]

Knowledge Drop

Last Tested: Jul 3, 2018
 

Not by default, but we can use the offset function to adjust what value is shown. For example:

#comparison table calculation column

offset(${column_name},-2)

You can adjust the "-2" as either a positive or negative value to customize the value.

This content is subject to limited support.