Add a dynamic average line to a line chart visualization

  • 3 February 2023
  • 1 reply

  • New Member
  • 0 replies

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?

1 reply

Userlevel 7
Badge +1

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.