I have a line chart with a count of months on the x-axis and a cumulative count custom measure of some metric on the y-axis. There are a number of lines on the chart as a result of a pivot, each one representing a person.
I’d like to add a line representing the average of all the other lines, that is dynamic - i.e. if the chart is filtered, the average will change.
Is it possible to do this?
I think you could do it with Table Calculation. As I can’t see your data or current visualisation, I can’t say for sure but explore the documentation about Table Calculations and mean(pivot_row()) combination, and you might get what you need.