Ad Hoc Reference Line

  • 6 January 2022
  • 3 replies


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?


Best answer by Dawid 6 January 2022, 10:02

View original

This topic has been closed for comments

3 replies

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? 

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

Userlevel 7
Badge +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: