on 2024 Jul 21 6:45 AM
I have a webi report with a date dimension. There are multiple entries for each date. There are other dimensions that contain users of the system and what they did with different products on different dates. I am trying to produce a report that tells how many products of a given type were bought, returned or left in a cart on each of the dates in the report. It would be something like on June 1, 2024 user x bought 5 units, sold 4, left 7 in cart, user y bought 9, sold 12, left 2 in the cart. I need to do this for each date in the range the report covers. Any advice on how to do this?
Request clarification before answering.
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.