6 Replies Latest reply on Sep 4, 2018 6:28 PM by Zhouyi Zhang

    Aggregation Problems

    Caireen Zaina

      Hi Tableau community,


      I am having issues understanding aggregation.

      I have check my calculated fields and I know that they are correct - however the percentage result i am after is not correct due to the aggregation - but I don't know how to fix my calculations so that i get the correct results.


      I have attached a work book so that you can see what I am trying to do.


      Basically the calc is the the PVA_PFAT number divided be the result of "Total fleet minus W's " (which is a parameter) so for the 3/09/2018 the calc should be 416/452*.100 = 92.03% but i am getting 92.7%

      The 4th Sep should be 419/452*100 = 92.69% but I am getting 93.3%

      then the 5th Sep should be 418/452*100 = 92.47% but i am getting 93.1%


      I have tried turning off agg measures but that then resembles nothing like i should have.


      Any help would be most welcome