topic Monthly Growth Rate Min to Max dates in App Development

Monthly Growth Rate Min to Max dates

badzreyes — Sat, 16 Nov 2024 19:20:45 GMT

Hi Everyone!

Can you guys help me with my formula? I have a trend chart that counts Total customer count acquisition monthly from 2018 up to latest date and I want to create another trend chart that shows its Growth Rate %.

My Original Trend chart is below:

The customer count formula for that is:

COUNT({$<DateBasis={"X"}>} distinct [Y])

Formula that I tried:

1. ((COUNT({$<DateBasis={"X"}>} distinct [Y]))/(Before(COUNT({$<DateBasis={"X"}>} distinct [Y])) - 1) * Avg(1)))

2. (COUNT({$<DateBasis={"X"}, MonthNum={$(=Max(MonthNum))}>} distinct [Y])) -

(COUNT({$<DateBasis={"X"}, MonthNum={$(=Max(MonthNum)-1)}>} distinct [Y])) /

(COUNT({$<DateBasis={"X"}, MonthNum={$(=Max(MonthNum)-1)}>} distinct [Y]))

Thank you so much and have a great day!

Re: Monthly Growth Rate Min to Max dates

Kashyap_R — Wed, 08 Jan 2020 11:32:50 GMT

Try this

(Count({$<DateBasis={"X"}>} distinct [Y])-Below({$<DateBasis={"X"}>} distinct [Y]))
/
({$<DateBasis={"X"}>} distinct [Y])

Note : Make sure to sort by ascending order the yearmonth and give fnumber format to numer and set % format

Hope this helps

Thanks

Re: Monthly Growth Rate Min to Max dates

badzreyes — Wed, 08 Jan 2020 13:56:12 GMT

Thank you for your response,

Unfortunately, it does not give me any result 😞 I just get ' - ' as a result in each row(I am trying the formula in a table first and splitting each expression into column to see where it went wrong but each doesn't gave me any result)

My dimension - ' YearMonthNum'

Measurement - 'Customer Count'(Current measurement that I want to convert into Growth Rate %) = COUNT({$<DateBasis={"X"}>} distinct [Y])

Regards,

Badz

Re: Monthly Growth Rate Min to Max dates

Kushal_Chawda — Wed, 08 Jan 2020 15:48:08 GMT

try this

=num(alt((COUNT({$<DateBasis={"X"}>} distinct [Y])- Above(total COUNT({$<DateBasis={"X"}>} distinct [Y])))/ Above(total COUNT({$<DateBasis={"X"}>} distinct [Y])),0),'#0.00%')