Getting Mixpanel Data into DOMO- data schema and syntax query
Hi, I'm trying to get Mixpanel data in DOMO for some custom analysis and have a couple of questions
1. Data model/architecture- Data comes in the form of 17 datasets they seem to call "Reports" and there's a little bit of documentation on what each of these reports means. However, the relational nature of each of the tables/reports doesn't seem very clear. Is the data in the STAR schema, by any chance
2. Additionally when bringing in the "Raw Data" table, looks like there's a where clause (in the mini help icon next to it, there's some guidance on the syntax - Where = number(properties["time"]) >= 2000 . If i'd like to filter by "Customer_Name" instead, should the syntax be - string(properties["Customer_Name"]) = 'XYZ' ?
Screenshot attached. Any guidance here would be really helpful.
Thanks in advance!