Average is returning SUM instead of an Average

user02423
user02423 Member
in Charting

I'm setting up a single value card and I have a column that is full of numeric values.

 

When I set up the column as the Value of the chart and set the Calculation to "Average" the single value presented is a sum of the values, not an average (if I change to "Sum" i get the exact same value).

 

Is there some trick to using average in a chart? Why is it not working?

Best Answer

  • Property_Ninja
    Property_Ninja Contributor
    Answer ✓

    Hello,

     

    I was just able to set up a column using average. I noticed the numbers looked a little off at first compared to the raw file so I removed the field in "Label Name"

     

    This solved the issue and now I am matching exactly what the raw file shows for an average.

     

    Hope this helps,

     

    Brian

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.


    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Answers

  • Property_Ninja
    Property_Ninja Contributor
    Answer ✓

    Hello,

     

    I was just able to set up a column using average. I noticed the numbers looked a little off at first compared to the raw file so I removed the field in "Label Name"

     

    This solved the issue and now I am matching exactly what the raw file shows for an average.

     

    Hope this helps,

     

    Brian

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.


    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.
  • Unknown
    Unknown

    I tried to replicate your issue just now and was not able to. Could you tell me more about the structure of your data set, especially the data type of the field you're trying to average? Also, is that field in the raw dataset? Or do you calculate it using Beast Mode?

     

  • user02423
    user02423 Member

    The accepted Solution was absolutely correct. For some reason when you add a "Label Name" field (which I can't even tell does anything??) it messes up the averages and turns them into the same values you get for sums. Removing the "Label Name" field and leaving it blank returned the correct average. Thanks!

  • user02423
    user02423 Member

    But now, when you remove the "Label Name" the single number value will not adhere to the formatting you define for it, it just give you the raw number with no commas and as many trailing digits as it calculates. :(

  • Property_Ninja
    Property_Ninja Contributor

    You can create a dummy label name with BeastMode. I just created a beast mode with the syntax of current_date(). Then I put that new field in the label name and it will allow you to change the format.

     

    The Label Name basically acts as a group by. So if you have a value that is constant on every row of your data then you can use that as the Label Name.

     

    Brian

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.


    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.
This discussion has been closed.

Categories