Calculated line on Bar Chart not the same as Summary Average

APAnalytics11
APAnalytics11 Member
in Charting

I am trying to figure out why the calculated line for a bar chart I am creating is different the the Summary Average of the same metric. Is this a rounding issue or something else? Thanks in advance.

Screenshot 2024-01-15 at 11.24.18 AM.png

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Without seeing each of your bar values, I believe the chart line is taking an average of each percentage/bar in your chart, but the summary number is taking the percentage across the entire dataset.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Without seeing each of your bar values, I believe the chart line is taking an average of each percentage/bar in your chart, but the summary number is taking the percentage across the entire dataset.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • APAnalytics11
    APAnalytics11 Member

    Got it that makes a lot of sense. Thank you for the help!

Categories