CODEWITHSUNDEEP
looker-studio
user14484722
user14484722

Reputation: 77

Converting UNIX time to Date in Google Data Studio

As title, is it possible in Google Data Studio to Convert Unix Timestamp to a human-readable date? For example, to convert '1618087345 to a date format consisting of year month day.

Upvotes: 1

Views: 4891

Answers (1)

Diego Queiroz
Diego Queiroz

Reputation: 3421

Actually, to treat a field with an Unix timestamp as a date, you don't need to do anything. Just mark the field as "Date & Time" type and you're done.

Check this Data Source and Dashboard as an example:

If you really need to convert manually for whataver reason, you may want to have a look into DATE_FROM_UNIX_DATE function.

Upvotes: 2

Related Questions