Question

Does the list property allow repeated values?

  • 28 February 2019
  • 3 replies
  • 85 views

Badge

I'd like to know what happens when I track an event with this type of property

mixpanel.track("event name", {"My List":["Item 1", "Item 2", "Item 2", "Item 2", "Item 3"]});

Meaning I have "Item 2" listed three times in my list.

1) when I do a breakdown of such list, will item with same value be calculated multiple times?

2) Is this record stored in database as it is, or are all list items included only once? Meaning if I want to query this via JQL.

Have anyone here had any experience with this?

Thanks



3 replies

Userlevel 3
Badge

@markiyan really interesting use case! Have you tested in a dev environment project? I'd love to know what happens!


Badge

yes by now I had a chance to test it.

1) yes these values are calculated multiple times in breakdown. it's quite smart, it aggregates (adds up) all times this value was reported. So if you have 10 of them and event was fired 5 times, it'll be counted as 50 times.

2) yes it's stored in database as is.

hope this helps others. Mixpanel rep was slow to reply on this and there's not enough community in this forum


Userlevel 3
Badge

@markiyan glad you were able to test on you end, this is actually really good info to know!


Reply