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
