topic Re: 7 days rolling average in a KPI in App Development

7 days rolling average in a KPI

abc_18 — Thu, 22 Apr 2021 07:40:03 GMT

Hello everyone,

I have to show rolling 7 days sales data vs 7 days earlier sales data in a KPI.

for ex:-

Like if today is 20th, then 1st KPI should give Avg Sales of 13th to 19th and second KPI should be Avg Sales of 6th to 12th.

I tried using rangeavg and rangesum, but in KPI it's not working, please suggest.

Dalton_Ruer — Thu, 22 Apr 2021 13:03:22 GMT

You are looking for Set Analysis here is post that has just what you are looking for.

abc_18 — Tue, 27 Apr 2021 11:36:17 GMT

Hi Dalton,

Thanks for the suggestion, got the required output with the help of above post provided by you.

Regards