Solved: Ad Hoc Reference Line

Yoni318 · 01-06-2022 12:35 AM

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?

Dawid

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:

Dawid

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:

Yoni318

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

Yoni318

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?