Mixpanel Community Icon

how do you reference a custom property in jql?

·
·

how do you reference a custom property in jql?

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Hi Andrew S., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹

    Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    To reference a custom property in JQL (JavaScript Query Language) for Mixpanel, you would typically access it through the properties object of an event. However, the knowledge sources provided don't contain specific information about referencing custom properties in JQL.The closest relevant information we have is from the JQL: Create custom queries using Javascript code document, which shows how to access regular event properties: LBKSfunction main() { return Events({ from_date: "2016-01-01", to_date: "2016-02-01", event_selectors: [{event: "Change Plan"}], }) .groupBy( [ "properties.New Plan", "properties.Previous Plan", // use a function to dynamically calculate a day of the event. function(ev) { return (new Date(ev.time)).toDateString(); } ], [ mixpanel.reducer.count(), mixpanel.reducer.any() ] ); }LBKSAs you can see, regular properties are accessed using properties.PropertyName. It's likely that custom properties would be accessed in a similar way, but without more specific information from the knowledge sources, I can't provide a definitive answer on how to reference custom properties in JQL.

    kapa.ai is still learning and improving, please let me know how I did by reacting below.

    ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.