0

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

null
    • Data Engineer
    • Coby_Gardner
    • 1 yr ago
    • Reported - view

    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.

      • Senior Data Visualization
      • Joseph_Hlongwane
      • 1 yr ago
      • Reported - view

       thanks for responding to my question. I need help in implementing you suggestion. Let me know your availability.

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 32Views
  • 2 Following