How to Create a Mixpanel Report for Wheel and Tyre Sales Tracking
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