Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Average not working as expected

I have an table called "Suporte", each rows represents one "quantity", so, I made a column like this "Quantidade = 1", given an ordinary graphic, the sum function works fine! But average doesn't :(

 

Here is the screenshot:

 

Any help?

Need Help

6 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    Anonymous

     

    Hello, The Average of a list of 1s is 1.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      What result are you expecting instead of 1?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Sorry, my example wasn't so good. If my drilldown is focusing on year, whats the average by month, if is focusing on month, whats the average by weekday.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

    Have you resoved your issue? You select the Average(highlighted in yellow background), it doesn't work? Could you please post more details for further analysis?



    Best Regards,
    Angelia