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

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:


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?