Month over Month Change

[RajatAr2]

Hi Everyone 

I have Months and Users metric in my Adobe Analytics, I wanted to see the month on month change in Users i.e.
                     Users    Change
Month      
October        100       0 (as there is no previous month)
Nove             150      50%
December     120     -20% 

I want to create a Change kind of metric which can help me to see the Month over Month Change 
Can anyone please help me to do so ?

[igupta]

Hi @RajatAr2 ,

One suggestion - You can maybe create 12 different calculated metrics one for each month like below. This would be one time set up but should give you the required metric nonetheless. Hopefully, some other expert may come up with more optimal solution. But till then, you may get your data through this set up!

Best,

Isha

[Harveer_SinghGi1]

Hi @RajatAr2 ,

You can create a decimal type calculated metric with below definition,

Works on row level where it calculates the % change based on previous row UVs.

Here's this metric with daily trend,

Here it is with monthly trend,

Cheers!

[bjoern__koth]

Hah, you were faster.

Now, any idea how we can get the actual average value into the column header?

I tried removing the Infinity with an If function, returning 0 if the previous value was actually 0.

Yet it will still not generate the overall average.

[Harveer_SinghGi1]

Hey @bjoern__koth , trying to solve for that but it doesn't seem that straight forward as the metric logic is looking for previous value which is not available in the column total and that is where I believe it fails.

I'll post here if I'm able to work it out.

Cheers!

[bjoern__koth]

Haha, well the Infinity can be removed easily. But the overall average does not seem to compute.

God I wished that one could define named components like "delta to previous value" instead of always copying the whole definition into the formula.

@Mandy_George any idea how to also get the average in the column header?

[Harveer_SinghGi1]

That's amazing @bjoern__koth , now we have only one last piece of the puzzle to put together.

Cheers!

[Harveer_SinghGi1 · Accepted solution]

Honestly I don't think we need to compute for overall % change. Think about it, when calculating the overall % change what value will the metric logic compare against the total UVs to.

I believe the this metric definition is good enough,

Cheers!

[bjoern__koth]

Yeah it would just be the perfect solution

But good enough to answer this question I guess.

Great job!

[igupta]

Great and scalable solution!

[RajatAr2]

Hi Harveen
Thank you for the logic, I tried doing it but didn't work 
I am getting the infinity Values

[Harveer_SinghGi1]

@RajatAr2 can you please share the metric definition that you have created? Also, are you using it on a trended or ranked report, can you share the report screen shot as well if that is fine?

You can also DM me and we can connect to discuss it if that works.

Cheers!

[Harveer_SinghGi1]

Hi @RajatAr2 , as discussed over DM it was just a matter of creating this metric as percent type rather than decimal type. I mistakenly mentioned decimal type in my initial response, work as expected when set as percent type.

Cheers!

[RajatAr2]

Thanks you @bjoern__koth It really worked

[bjoern__koth]

Props to @igupta  and @Harveer_SinghGi1 's solutions!

Great to see what complex setups can be solved with different approaches!