Solved

Ad Hoc Reference Line

Hi,

I would like to create a reference line based on an ad-hoc measure. Similar to the one below.

This is the visualization (stacked) I need to add it to:

How can it be done on Looker?

icon

Best answer by Dawid 6 January 2022, 10:02

This topic has been closed for comments

Userlevel 7

+1

Add the other measure and in the visualisation settings change only that one series to Line

Then you can have something like that:

And if your measure is static, that’s okay too. Alternatively, if the value is constant, you can add a reference line:

Thank you very much!!! Option one worked perfectly.

I have another question: Is it possible to make a year-over-year comparison based on the day of the week.

For example, first Monday of January 2022 to the first Monday of January 2021?

Sign up