Can you create a custom property which allows me to filter and breakdown depending on whether it's the last day of a given month?
Hi Jorge C., 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
Based on the knowledge sources provided, Mixpanel’s custom properties feature allows you to create new properties using a formula language, including date/time computations such as calculating the number of days between two dates or extracting parts of a string. However, there is no explicit example or documentation confirming that you can create a custom property specifically to identify whether an event occurred on the last day of a given month.The documentation does mention that you can use functions in custom properties and that you can use the formula bar to define properties, including date/time differences and extracting values from properties. But it does not list a function or formula for determining "last day of month" logic directly. Therefore, while it is possible that advanced date logic could be constructed if the formula language supports it, the knowledge sources do not provide enough detail or an explicit example to confirm this capability or to provide the exact formula required.In summary: I'm sorry, but the knowledge sources do not explicitly mention whether you can create a custom property to filter and breakdown by "last day of a given month." There is support for date computations in custom properties, but no direct reference to this specific use case or the necessary formula is provided in the documentation Custom Properties: Calculate new properties on the fly.
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.