topic Re: Month vs Previous month comparison in App Development

Month vs Previous month comparison

sujayrpatil — Wed, 02 Sep 2020 11:57:33 GMT

Hi All,

I have a scenario where I have to compare the users count for each month wrt users count in previous month and show as percentage change.

I have attached the snap of number of users per month.

required bar chart should have the change over every month.

example: for the June month bar , the calculation should be (June count -May count)/(May Count)

i.e (191-177)/177 = 0.11.

Request for your support.

Br,

sujay.

Re: Month vs Previous month comparison

sunny_talwar — Wed, 02 Sep 2020 12:16:21 GMT

Try using Above()/Below() function

If(MonthYear, Sum(Measure)/Above(Sum({<MonthYear>}Measure)) - 1)

Re: Month vs Previous month comparison

sujayrpatil — Thu, 03 Sep 2020 11:08:26 GMT

Hi Sunny,

Thanks for the solution it worked fine for me.

But what if I have to show the change over 2 dimensions like may be in a Line graph if I want to show change over month and also on app (month on x axis and app as lines in y axis). Then how can i calculate the change.

Thanks in advance.

Re: Month vs Previous month comparison

sunny_talwar — Thu, 03 Sep 2020 11:39:13 GMT

Something like this

Aggr( If(MonthYear, Sum(Measure)/Above(Sum({<MonthYear>}Measure)) - 1) , AppDimensionName, MonthYear)

Re: Month vs Previous month comparison

sujayrpatil — Fri, 04 Sep 2020 03:47:53 GMT

Hi Sunny,

Thanks for your response, but sorry it isnt working for this scenario.

Re: Month vs Previous month comparison

airflight90 — Tue, 05 Jul 2022 15:57:06 GMT

Hi Sunny,

Would you please explain the logic for this expression? I thought the If statement will need a condition " if (condition, true, false)" . Thank you

Michael

Re: Month vs Previous month comparison

piotr-bratek — Thu, 03 Nov 2022 08:54:45 GMT

Hi Sunny,

what's the syntax ? You do not equate MonthYear to some values ...

Sum({<MonthYear>}Measure)

Is that equal to {<MonthYear= >} ?

If not, how does it work? Is there any official material about it?