Hi there!
I want to create MTD reports like: (Number of purchases this month - number of purchases last month)/Last month purchases * 100). The problem is that I can´t find how to group the events by dates, like Purchases between 03/01/2023 and 04/01/2023 or something like “Last Month”.
We are sending data from Segment, could that be the problem? In any case I can see some derived properties that don´t work for my case neither: https://analytics.amplitude.com/demo/chart/new/ld62bjj
Thanks!
Hi Ivan - if it’s simply that, then use segmentation, group by month next to the time picker, then use the “compare” feature (top left of chart) with the % setting. If you want to do something more complex, you’ll need to use custom formula and do some maths!
Hey
Let me know if this helps or if I’m not understanding your question properly!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.