Ad Hoc Reference Line

Yoni318
Participant I

Hi,

I would like to create a reference line based on an ad-hoc measure. Similar to the one below.  

c5a296ba-7104-4b03-9cff-3e0916e8d5cb.png

 This is the visualization (stacked) I need to add it to:

123b1717-7d86-4840-889d-ce949e95d6fd.png

How can it be done on Looker?

Solved Solved
0 3 170
1 ACCEPTED SOLUTION

Dawid
Participant V

Add the other measure and in the visualisation settings change only that one series to Line

12091e9b-f3fc-4493-8903-1af06c15b711.png

Then you can have something like that:

cd538041-fc9c-434a-85da-e239d7781c6f.png

And if your measure is static, that’s okay too. Alternatively, if the value is constant, you can add a reference line:

4c5a0212-53a7-4aaa-8b54-9d0fd5431579.png

View solution in original post

3 REPLIES 3

Dawid
Participant V

Add the other measure and in the visualisation settings change only that one series to Line

12091e9b-f3fc-4493-8903-1af06c15b711.png

Then you can have something like that:

cd538041-fc9c-434a-85da-e239d7781c6f.png

And if your measure is static, that’s okay too. Alternatively, if the value is constant, you can add a reference line:

4c5a0212-53a7-4aaa-8b54-9d0fd5431579.png

Yoni318
Participant I

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

Yoni318
Participant I

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? 

Top Labels in this Space
Top Solution Authors