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?
Solved! Go to Solution.
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:
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?