Hey everyone! I’ve got a question about numeric precision in Mixpanel. We’re sending very small fee values from our trading app (e.g. 0.00000841 BNB). In the event properties they show correctly, but in tables/reports Mixpanel rounds them down to 0, which breaks our analytics. Is there a way to disable rounding or increase decimal precision for numeric properties? Any workaround would be super helpful. Thanks!
While Mixpanel's round() function is typically used to reduce precision, you can use formulas to manipulate values after aggregation. However, this won't solve the underlying display issue if values are already rounded to 0
mixpanel.track('Trade Executed', {
'fee_bnb_raw': 841, // Multiply by 100,000,000
'fee_bnb_display': '0.00000841 BNB', // String for reference
'fee_multiplier': 100000000 // Document your multiplier
});Or this could be also helpful: Send a formatted string version alongside the numeric value:
Numeric property: fee_numeric (for calculations, even if rounded)
String property: fee_display = "0.00000841 BNB" (for display in tables)
