what functions can be performed in a formula?
what functions can be performed in a formula?
Hi Josh L., 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
In Mixpanel, you can perform a variety of functions in a formula. Here are some of them:1. if: Evaluates if an expression is true or false. 2. ifs: Runs multiple checks and returns a value corresponding to the first true result. 3. not: Returns values that are not true. 4. and: Returns true if both conditions are met. 5. or: Returns true if either condition is met. 6. in: Returns true if the first condition is contained in the second condition. 7. boolean: Casts the argument to a boolean. 8. number: Casts the argument to a number. 9. string: Casts the argument to a string.You can also use arithmetic operators in your formulas:-
+: Addition --: Subtraction -*: Multiplication -/: DivisionAnd comparison operators:-<: The first number is strictly less than the second number. ->: The first number is strictly greater than the second number. -> =: The first number is greater than or equal to the second number. -<=: The first number is less than or equal to the second number. -==: The first argument is equal to the second argument. -!=: The first argument is not equal to the second argument.For more details, you can refer to the Mixpanel documentation on <https://docs.mixpanel.com/docs/features/custom-properties|Custom Properties> and Insights.kapa.ai is still learning and improving, please let me know how I did by reacting below
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
Josh L.··can I use min() and max() functions in a formula?
Let me check the knowledge base for you again. One moment! đź“š
Yes, you can use
min()andmax()functions in a formula in Mixpanel. Themin()function determines the minimum value between two numbers, and themax()function determines the maximum value between two numbers. Here are the syntax and examples for these functions:-min(number, number)Example:min(A,B)-max(number, number)Example:max(A,B)For more details, you can refer to the Mixpanel documentation on Custom Properties.kapa.ai is still learning and improving, please let me know how I did by reacting below
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.