Data Studio
2.1K members online now
2.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

DataStudio - How Do I Round Up/Down Custom Metric Data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Currently with the custom metrics, some of the data to clients contains decimals, what can I do to round it up or down like I do in Google Sheets.

Re: DataStudio - How Do I Round Up/Down Custom Metric Data

Follower ✭ ✭ ✭
# 2
Follower ✭ ✭ ✭
This might be of help:- https://support.google.com/360suite/datastudio/table/6379764?hl=en&ref_topic=6370331
ROUND(X, Y): Returns X rounded to Y precision digits.

Let me know, if it worked.

cheers!

DataStudio - How Do I Round Up/Down Custom Metric Data

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi guys!

 

I had the same problem, I applied the formula and round it but now it shows ,00 (currency). How do i definitely get rid of the decimals? If I set it as a number it works but not as currency.

 

 

Thanks

 

DataStudio - How Do I Round Up/Down Custom Metric Data

[ Edited ]
Follower ✭ ✭ ☆
# 4
Follower ✭ ✭ ☆

ROUND only works for Y >= 1, hence you can only round to 1 decimal place. How to round to ones (without the decimal)?