Grouping Events by Distinct Properties in Mixpanel
How do I group an event by distinct properties in Mixpanel? e.g., I’m sending an event called “event1” with event property dicts like the following: track(event_name=“event1", event_properties={“foo”: “blue”, “bar”: “yellow”}) track(event_name=“event1”, event_properties={“foo”: “blue”, “baz”: “green”}) track(event_name=“event1", event_properties={“foo”: “red”, “baz”: “green”}) track(event_name=“event1”, event_properties={“foo”: “red”, “baz”: “green”}) I’d like to build a table that looks like the following: name | foo | bar event1 | blue | yellow | 1 event1 | blue | green | 1 event1 | red | green | 2
