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:


      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!