4 Replies Latest reply on Nov 22, 2016 5:58 AM by Marcin Zwierz

    How to calculate daily averages of a retention matrix?

    Marcin Zwierz

      Hi guys,

       

      I created a simple retention matrix using LOD function and then tried calculating average retention per day using Analysis -> Totals -> Show Column Grand Totals but I get a result, which is clearly incorrect:

      screen.PNG

      It seems that Grand Total clashes with the LOD function. Naturally, I tried solving this problem with different calculated fields but with no luck. I would very much appreciate any help!

       

      Thanks,

      Marcin