1 Reply Latest reply on Aug 21, 2016 12:55 PM by Tharashasank Davuluru

    Percentages calculations

    Matan Bracha

      Hi All!

       

      I'm trying to make a retention report, that means that I need to calculate many percentages.

       

      I have this view:

       

      and this is the same report in real numbers:

       

      The X axis is a field of datediff.

      Now - What I need to build is a line graph of the percent for each Datediff.

      Meaning - for datediff 1 - sum of all the numbers in 1 column divided by sum of all numbers in 0 column (until Aug 19) - 27.71%

      For datediff 2 - sum of all the numbers in 2 column divided by sum of all numbers in 0 column (until Aug 18) - 27.61%

      And so on...

       

      But the only graph I manage to create is the sum of each datediff column divided by the entire sum in 0 column.

       

      I hope I made myself clear enough - If not, please tell me what's not not clear - I'm sitting on this view for hours now...

      Thank you all so much