1 Reply Latest reply on Jul 19, 2018 6:14 AM by Zhouyi Zhang

    Sum vs Average

    aditya janapala

      Hi All,

      First question : I know this question seems to be simple, I was wondering when i should go for average or sum, when comparing performance of Measure or dimension?


      Second question : In tableau is it better to calculate average inside the calculated field like : sum(sales)/count D(sales)( Aggregated calculations)

      or use right click to change from sum to average (Non - aggregated calculations)

        • 1. Re: Sum vs Average
          Zhouyi Zhang

          Hi, Aditya


          the 1st question will be depending on your situation, and some times use avg, some time use sum, and some times use both.

          your 2nd question, still depends on your case, but normally is non aggregated calculation as the amount of sales may be the same for different orders.



          1 of 1 people found this helpful