Hi all,
Can anyone help and point me in the right direction to achieve a particular report in Mixpanel?
For sales on our website I record 2 types of event: one order-complete and one or more order-complete-item - where the order-complete-item represents a line item on the order.
All of the events have a property for order_number and the order-complete-item event has a property for product_type (which can be either Wheel or Tyre).
I want to produce a report that shows how many orders have BOTH Wheel and Tyre sales but I simply can’t figure out how to group it.
I think I need to use a Custom Property and have tried looking at just order-complete-items by Unique User and going from there, but when I filter by Tyre AND Wheel, my report shows no data which I know is not correct
If anyone could point me in the right direction here, I’d really appreciate it
Cheers