This content has been marked as final.
Show 2 replies

1. Re: Comparing the avg column with each row
sudheer.kumar.5 Apr 28, 2018 2:34 AM (in response to sooraj j) 
2. Re: Comparing the avg column with each row
Jeevan Krishna Apr 28, 2018 11:09 AM (in response to sooraj j)Hi Sooraj,
You need to calculate window_avg of the aggregate metric on which you need to calculate the Difference over avg. metric
Considering sum(sales) is the aggregate metric ,
The above calculation will help you in avg calculation as shown in the excel. But to calculate growth over the window avg. you need to use the following formula.
You need to format this field as percentage for usage in dashboard.The final result on a sample dashboard looks like this.
Hope this helps