topic Re: Mean percentage growth KPI in App Development

Mean percentage growth KPI

hjoopally — Sun, 24 Jul 2022 01:43:02 GMT

I have one dimension (month) and one measure (sales) in my data. I calculated % change in sales per month using the following formula in a table chart:

Sum(Sales)/Above(Sum({<[Month]>}Sales)) - 1

I want to add a KPI which measures average monthly percentage change of sales. What's the formula to do that?

Example

Month - Sales - Sales % Change

1 -10 - -

2 -15 - 50%

3 - 18 - 20%

4 - 20 - 11%

KPI: Average = (50+20+11)/3 = 27%

Re: Mean percentage growth KPI

sidhiq91 — Sat, 23 Jul 2022 04:37:17 GMT

@hjoopally I just took the Avg([Sales % Change]) and I got the required output. Please see the screen shot.

If this resolves your issue, please like and accept it as a solution.

Re: Mean percentage growth KPI

hjoopally — Sun, 24 Jul 2022 01:39:22 GMT

I only have month and sales in my data. I calculated % change using the formula below:

Sum(Sales)/Above(Sum({<[Month]>}Sales)) - 1

And Avg(Sum(Sales)/Above(Sum({<[Month]>}Sales)) - 1) is not working.

Re: Mean percentage growth KPI

sidhiq91 — Sun, 24 Jul 2022 02:05:04 GMT

@hjoopally Please see the below expression to calculate the Percentage % in straight table.

(Sum(Sales)-(Above(Sum(Sales))))/(Above(Sum(Sales)))

To calculate the Avg of Percentages, please the below formula.

Avg(Aggr((Sum(Sales)-(Above(Sum(Sales))))/(Above(Sum(Sales))),Month))

Please remember to set the expression to Number Percentage Format.

I have attached the Screen shot for your references.

If this resolves your issue, please like and accept it as a solution.