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

    Averange of Differences Over Selected Period

    Anna Nathasia

      Hi,

       

      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:

      x.png

       

      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

       

      60%

      -------------------------------

       

      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!