3 Replies Latest reply on Oct 12, 2018 11:44 AM by Deepak Rai

    Averange of Differences Over Selected Period

    Anna Nathasia



      I am looking for a way where I can display an average of differences of my data with the selected period (e.g. Jan-Mar 2018) and level (days/weeks/months).


      I have managed to create a table calculation with below formula:



      Actually, I have manage to get the numbers right (I think) but my problem here is that I want to display my result in 1 cell contrary to my result above (displayed for all period columns).

      As an example, what I want as a result is something like:



      Average Growth





      Any tricks or new calculation I should do instead of doing window_avg? I tried using average but it doesn't work. I've tried to minimize the table and it also doesn't work.


      Your help is very much appreciated. Thanks a bunch in advance!