Mixpanel Community Icon

Creating Custom Event Property to Filter Non-Digit Distinct IDs

·
·

how can I create a custom event property to filter distinct ids which are not just digits?

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

    Hi Elena M., 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 create a custom event property in Mixpanel, you use the property builder in the UI: click the plus button next to the search bar, select "Event Property," and define your formula. However, the knowledge sources do not provide explicit information about using regular expressions or string functions to filter for distinct_ids that are not just digits.The documentation does mention that you can use functions in custom properties and that pressing Ctrl + Space in the formula bar will show available functions and their descriptions. But it does not specify whether there is a function to check if a string contains only digits or not, nor does it provide an example formula for this use case. Therefore, I cannot provide a precise formula for filtering distinct_ids that are not just digits based on the available documentation.If you want to explore this further, I recommend opening the custom property builder in Mixpanel and using Ctrl + Space to see if there are string or regex functions available that could help you construct this filter. You can also refer to the custom properties documentation for more details on how to use the property builder and available functions.I'm sorry, but the knowledge sources do not contain enough information to provide a specific formula for filtering distinct_ids that are not just digits using a custom event property in Mixpanel. Creating a Custom Property

    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.

  • Avatar of Andrew S.
    Andrew S.
    ·
    ·

    Elena M. use the regex_match function in the custom property with [^0-9] as the match string. If the result is true then it has values beyond just numbers