Yes! Would love to have this as well!
@nflaherty and @Michael_Erasmus … there are some creative methods for vertical reference lines along the x-axis here:
Once a reference line is created, is there a way to delete it?
Thx! Just needed to expand my screen and the X showed up. Duhhhhh. Appreciate the reply!
Is it possible to select which Y-axis you’d like to attach the reference line to?
Right now reference lines can only be applied to the first series (the leftmost column in the result set). However, this is something that may come in a future release- I’ll add your feedback!
For now, you can get around this by either rearranging your columns, or using table calculations to create a reference line.
Rearranging my columns worked, but I’d still very much like this feature because now that I had to rearrange my line series is behind my column series.
Thanks for the feedback @Brian_Winkle. Let me know if you want some help testing out the table calculation method!
Hi - IS it now possible to create a reference line that takes all of the pivots into account?
Hey @Andrew_Harkness , reference lines currently only apply to the first series in a pivot. I can let our product team know you’re interested in having this as a feature!
Hey @mscrigner, At this time Reference lines will only be applied to the first series in an Explore. I’ll definitely let the product team know you’d like to be able to do this.
The live Looker link in Creating Reference Lines for Charts through the Visualization Editor (3.18+) 404s. Would be very helpful if you could link to update the links @colin .
Seems the models changed underneath, but here’s a similar example:
Is it possible to reference a value from an external table?
For example, I’m considering creating a centralized table that contains the goals for a series of metrics. Let’s say these goals change from quarter to quarter; rather than update a series of dashboards and hunt all over tarnation to fix these hardcoded values, can the reference line… reference a value in a table?
There is not currently a way to create a dynamic reference line derived from the result of a query. I let our product team know that this is something you’d like to use.
Alternatively, you could use your data and add that as a line series, as referenced above/linked here.
Adding my voice to the conversation here to say that not being able to have reference lines tied to more than just the first series is a really big miss. All the ‘workarounds’ discussed in this thread wlil suffice, but also demonstrate what a simple feature this would be to implement!