I have a metric that has decimals and want to round it to a whole number. Couldn’t find any formula or setting to do so. Any tips would be appreciated
Solved
How do I format metrics to be whole numbers (remove decimals/round up)?
Best answer by eddie.gaona
Hi Oliver,
Hope you are well!
Unfortunately, Amplitude does not currently support rounding up or rounding down of decimal numbers directly in the platform. This has been a topic of discussion. I am assuming you are referring to chart results returning decimal values rather than a specific property containing the decimal value. If this is not the case please let me know.
However, you can export the data and perform the rounding operation in a tool like Excel or Google Sheets. I understand this might not be the ideal solution, but it's a workaround until we have this feature in Amplitude.
I hope this helps! If you have any other questions, feel free to ask.
For more information on Amplitude's features and how to use them, you can check out our video tutorials.
Best,
Eddie
P.S. Checkout upcoming events and user meetups on our events page.
View originalHope you are well!
Unfortunately, Amplitude does not currently support rounding up or rounding down of decimal numbers directly in the platform. This has been a topic of discussion. I am assuming you are referring to chart results returning decimal values rather than a specific property containing the decimal value. If this is not the case please let me know.
However, you can export the data and perform the rounding operation in a tool like Excel or Google Sheets. I understand this might not be the ideal solution, but it's a workaround until we have this feature in Amplitude.
I hope this helps! If you have any other questions, feel free to ask.
For more information on Amplitude's features and how to use them, you can check out our video tutorials.
Best,
Eddie
P.S. Checkout upcoming events and user meetups on our events page.
+9Hi Oliver,
Hope you are well!
Unfortunately, Amplitude does not currently support rounding up or rounding down of decimal numbers directly in the platform. This has been a topic of discussion. I am assuming you are referring to chart results returning decimal values rather than a specific property containing the decimal value. If this is not the case please let me know.
However, you can export the data and perform the rounding operation in a tool like Excel or Google Sheets. I understand this might not be the ideal solution, but it's a workaround until we have this feature in Amplitude.
I hope this helps! If you have any other questions, feel free to ask.
For more information on Amplitude's features and how to use them, you can check out our video tutorials.
Best,
Eddie
P.S. Checkout upcoming events and user meetups on our events page.
Hope you are well!
Unfortunately, Amplitude does not currently support rounding up or rounding down of decimal numbers directly in the platform. This has been a topic of discussion. I am assuming you are referring to chart results returning decimal values rather than a specific property containing the decimal value. If this is not the case please let me know.
However, you can export the data and perform the rounding operation in a tool like Excel or Google Sheets. I understand this might not be the ideal solution, but it's a workaround until we have this feature in Amplitude.
I hope this helps! If you have any other questions, feel free to ask.
For more information on Amplitude's features and how to use them, you can check out our video tutorials.
Best,
Eddie
P.S. Checkout upcoming events and user meetups on our events page.
1 person likes this
Reply
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.