Month over month ARR comparison

Question

Hi,

I am sharing herewith the sample data.
So,i would require to have the month on month ARR comparison customer wise.I have data of around 18 years.

The objectives of the case would be-
1)Customer Churn-If the ARR of particular customer has fallen down from some positive number(Let's say 100) in previous month to 0
in the current month.
2)New Customers added-If the ARR of particular customer has raised from 0 in the previous month to some positive number(Let's say 100)
in the current month.
3)Customer Expansion-If the ARR of particular customer in current month has increased from previous month .
4)Customer Downshell-If the ARR of particular customer in current month has decreased from previous month .

After this,i have to calculate the total no. of customers churned,total no. of new customers added,9
Customer expansion(knowing the expansion customer wise and total expansion as well,(both ARR and customer wise))
,Customer Downshell(knowing the downshell customer wise and total downshell as well(both ARR and customer wise))

Sample data.xlsx

grazitti_sapna · Accepted Answer

Hello @SurbhiMittal , I am sharing a workaround to your problem statement. Please let me know if this is what you are expecting.

Thanks!!

SurbhiMittal · Accepted Answer

Hi Sapna,

Thank you for your revert.This workflow was really helpful.I am able to get the results.I will work on this further and might come up with more

questions.Can you please help me to get this linked with PowerBI? I am required to create visuals for the same.
Also,can you also provide me with the virtual training for Alteryx?

grazitti_sapna · Accepted Answer

@SurbhiMittal , this is because when you are creating the Field its data type is Int32 by default please change it to string.