Hi Thiago 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
In Mixpanel, you can use formulas to make calculations using simple arithmetic operators. To use formulas in metrics, you need to click the Metrics button, then select Formula. Each event in the query shows a letter next to it, which indicates its variable name. You can use these letters in combination with the operators to calculate a more advanced query. Here are the operators supported by Mixpanel:
- Add: -
- Subtract: -
- Multiply: -
- Divide: /
- Use parentheses to influence the order of operations: ()You can also use numbers as constants in a formula. For example, you can multiply a ratio by 100 to display as a percentage, or divide a property value tracked in seconds by 3,600 to display the value in hours. Please note that you cannot nest a formula metric when constructing another formula. You can also save formulas for re-use. Once you save a formula, A,B,C refer to what’s within the saved formula modal. To access and re-use saved formulas, click on “+Formula”, and then see the list of saved formulas. For more details, you can refer to the Mixpanel documentation on Formulas.
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.
