Adding reference line to running totals line chart.

[Joetabby]

Hi all, I am new to looker. I have a line chart that compares the total sales of multiple departments. Additionally, I have a line representing the total sales of all departments combined. How can I add a reference line at the maximum value of the total sales of all departments?

[sam8]

If you are using Looker, you can create a reference line and select its "Value" - in this case, you'd select "Max".

If you are using Looker Studio, you can create a reference line and set the "Type" to "Calculation", then select "Max".