Add a dynamic average line to a line chart visualization

COG
Explorer

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?

0 1 566
1 REPLY 1

Dawid
Participant V

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.

Top Labels in this Space
Top Solution Authors