Forum Discussion

meowster's avatar
meowster
Frequent Visitor
3 years ago
Solved

Dynamic Average Line for Column chart based on filter

Hello,   I have a simple calculated table and I would like to have column chart by months, together with an average line across. The calculated table looks like this:   The column chart ...
nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
3 years ago

meowster 

 

Try using the Average line from the Analytics pane.

 

  • meowster's avatar
    meowster
    Frequent Visitor
    3 years ago

    Hi nandukrishnavs ,

     

    Thank you! This works after I've changed my chart to clustered column chart. Realised that the "average line" is not applicable on stacked column charts.

  • meowster's avatar
    meowster
    Frequent Visitor
    3 years ago

    Hi nandukrishnavs , there is no "Average Line" in my Analytics pane, I can only see "Error Bars". What do I need to do to see it?