I am trying to use the reference line on a line chart and i was wondering if there is a way to use one of the ‘Total’ values as the reference line? Right now its only a constant value (which cant be set to a variable) or a simple equation (avg, min, max) of a value. while i can make the reference line work as an average of some columns, I have more complex equations that I would like to make a reference line to. Any advice on this?
So you won’t be able to add this through the reference line UI but if you just dragged that total column into your “Value” section of the line chart I think that would work for you!