yearly unique shown monthly

[mattlukoff]

Hello,

Can anyone help me get a sum of purchases divided by unique count of user IDs over a yearly period but shown over a monthly time frame. See sample workflow attached. It's a purchases per unique user metric showing over the year.

Thanks

[SeanAdams]

Hey @mattlukoff

this is definately doable - if you look at what the macro is doing, there's a summarize tool with a group by month - you can add another group by to that same summarize with the product ID.

Have a good week

Sean

[mattlukoff]

@chris_fort, I really like this solution too. Just two questions/requests:

1. Is it re-starting the unique user count every year? I don't think it is so how can I do that?

2. How can I group the distinct by some user attribute like unique purchases per user by user attribute 1?  i.e. so it's like this:

User Attribute 1	CountDistinctNonNull_User ID	Sum_Purchases
Apple	24	35
Bananna	11	12
Pear	19	42
Watermelon	12	12

thanks!