First time buyers
Hi
I have a data set that has retailers, sales value and sales date starting from Jan 2022 to current month and I would like to do the following:
Firstly - I would like to determine the date the retailer made its first purchase.
Secondly - I would also like to count the retailers that made the first purchase within every month from 2022 to current month
Here is the screen shot showing the final output I would like, please note the values in the second column are incorrect.
2 replies
-
Hey Joseph, since it seems like you may be using the first purchase date more than once, my approach would be to solve this issue in the data model. If you use a node in the data model that groups retailer and the minimum date, you can join it to the main table again, adding the new column. Let me know if you need any help implementing this and we can connect.