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

Convert milliseconds to seconds in Data Studio

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a custom metric in Analytics called Exit Page Time (See: Simo Ahava article) which returns a time value in milliseconds. Do you guys know of a formula in Data Studio I can use to convert it to seconds? I've tried a calculated field (Exit Page Time * 1000), but it gave me an error message (Invalid Formula). Any ideas?

Convert milliseconds to seconds in Data Studio

Follower ✭ ☆ ☆
# 2
Follower ✭ ☆ ☆

Hi Mike,

What is the format of "Exit Page Time"? Is it Number, Date Time? 

If you duplicate and convert to number, does this change the original value of the millisecond? if it does not, and yo proceed to x by 1000, does the formula work?

 

Thanks,

Donavyn