Solved

Ad Hoc Reference Line

  • 6 January 2022
  • 3 replies
  • 15 views

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

View original

3 replies

Userlevel 6
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? 

Reply