Google Data Studio Tutorial | How to work with timestamps in Data Studio (Datetime Formula) ⏰

Опубликовано: 27 Октябрь 2024
на канале: Danalyser
10,614
98

This tutorial will show you how to use formulas in #DataStudio to create calculated datetime/timestamps fields.

This video is for YOU if you wish to learn about:
✅ How to convert timestamp/datetime from one time zone to another
✅ How to calculate the duration differences between 2 timestamps in seconds, minutes, hour, day, etc.

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A

F R E E B I E S
I used Canva to make graphics for my education videos and thumbnails. If you want to try this amazing tool, you are welcome to use the link below!

Try Canva Pro FREE for 30 days: https://partner.canva.com/danalyser
[ This is an affiliate link. I receive a small commission if you decided to subscribe to the Canva plan after trying it out. There's no extra cost to you.]


___________________________________________________________________________
⏰ Timestamps ⏰
00:00 3 Datetime Formulas in Data Studio
00:17 Data Source
01:18 Use Case/ Example / Application of Formula
02:00 Demo at Data Studio
02:30 DATETIME_ADD
04:52 DATETIME_SUB
06:12 DATETIME_DIFF

___________________________________________________________________________
📒 Reference:
#1 Data Source - https://bit.ly/3fDhxLb
#2 Directory of Date Functions - https://bit.ly/2SlyXnO

___________________________________________________________________________
Learn something today and want to learn more?
👧🏻 SUBSCRIBE NOW    / @danalyser  
👧🏻 FOLLOW ME on TWITTER for more contents (some content are exclusive to Twitter)   / danalyser8  



#DataStudio #DateTime