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.
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()
and max()
functions in a formula in Mixpanel. The min()
function determines the minimum value between two numbers, and the max()
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.