Christopher C.

I haven't worked this out either 😿, I usually just hit cancel and restart.

Distinct ID isn't supported for lookup tables no. If you need this though, you can basically create a custom property that just returns Distinct ID, and use that custom property for your lookup table. It's kinda hacky but it should work from memory.

Possible you might be able to get away with casting it within Mixpanel? Would need to be re-casted each query though AFAIK

I think we need more context around what you're trying to do here, can you provide anything more specific (even just a made up example with details)?

For the '1 column per week and 1 row per customer' you can do this too, but it'll be a little painful and not great (at least, in the way that I am thinking of) Basically you can change your breakdown to be by User -> Email or User -> ID etc (any unique property on a user essentially that is meaningful to you), and that will give you one row per user. For one column per week though, you'd need to duplicate your metric and timebox it to each week eg https://mixpanel.com/s/1vztoh which might be alright for you, but it won't give you the time ranges AFAIK. Someone else might have a better suggestion than that though, it's just the only thing I could think of to do one column per week.

Hmmmm, I don't think you can change the order of the columns no, best you can do is reduce the time period so it only covers 6 days or weeks etc so you don't have to scroll =\ For the % uplift, you can click up the top Compare -> To previous Week and then it will pop up defaulting to just the # comparison, you want to click on the icon to the right of the Hash (arrow pointing up)

Hmmm, if you've got a consistent pattern, you might be able to use a custom property to check for each of the three properties and return the appropriate one? Eg if you've got a list of email addresses, and some users might have that email address as $email or $user_id or $distinct_id due to implementation issues in the past, you can do a custom property that just does an IFS and checks for each property if it is defined and if it is an email (contains '@' should be sufficient). Otherwise, if you have your list in a CSV or similar, you can paste it into a filter box in Mixpanel as a comma-separated list eg A, B, C, D and that will filter to show each of A/B/C/D and you can then hit Select All etc. I vaguely remember having issues doing this with > 3,000 values though in the past.