'How can I convert numbers to hh:mm:ss in Google Data Studio?

I am trying to convert numbers into duration in Google Data Studio, however it's not showing the correct output.

Image for Reference

I want column A numbers in the form on Column B as an output, but in Google Data Studio it's showing the duration as 0:00:00.

google-data-studio


Solution 1:[1]

You must create a custom field and use this as the formula:

Number*86400

then choose the type to be "Duration(sec.)"

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Gabriel Hodoroaga

Related Questions