Hi all,
I am trying to find out how many users have purchased products and plot in a visual to give an idea about the sales within the date slicer selected by the end user of the report.
I have tried with calculated columns; however, it takes into account all the product purchases made by users instead of within the date range picked as I hoped it would.
My data (for 14th Feb as the date picked by the end-user) currently looks like this -
| User ID | Product ID | Dates |
| user01 | p1 | 14/02 |
| user023 | p2 | 14/02 |
| user12 | p3 | 14/02 |
| user12 | p4 | 14/02 |
| user023 | p3 | 14/02 |
| user05 | p1 | 14/02 |
| user99 | p2 | 14/02 |
| user12 | p3 | 14/02 |
| user01 | p2 | 14/02 |
The output I expect to see - How many users have purchased the product how many times?
2 users have purchased 2 products
1 has purchased 3 products
2 have purchased 1 product
Please feel free to ask for more information. Thank you!
