Calculate Average in KPI from tables columns/current+previous rows

Micki — Fri, 18 Dec 2020 16:24:31 GMT

Hi, folks

I don't have idea how to put those value ion KPI using set analysis:

1. First need to calculate difference between current and previous rows (if first row doesn't have previous use current)

2. Calculate the average based on difference

Please note that's all should be in KPI not in table

Thank you for you time and consideration

Re: Calculate Average in KPI from tables columns/current+previous rows

rubenmarin — Sat, 19 Dec 2020 13:09:56 GMT

Hi @Micki, for this data:

Data: LOAD * INLINE [ N, Current Value 1, 32 2, 32 3, 32 4, 33 5, 33 6, 33 7, 33 8, 33 9, 39 10, 39 11, 38 12, 39 13, 41 14, 44 15, 62 ];

You can use

=Avg(Aggr(Rangesum([Current Value]-Above([Current Value])), N))