Display TODAY's DATE as a TITLE in Data Studio [Calculated Field: CURRENT_DATE, MAX, CONCAT]
Within 5 minutes, this video guides you on HOW-TO get current date in Data Studio Report (using calculated field), and display it on the dashboard.
We'll also be exploring to create a DYNAMIC TITLE, whereby the DATE gets updated daily based on your current time zone.
⏰ Content Outline ⏰
⏩ 0:00 ~ 0:30 Tutorial Overview, Expected Outcome (Demo)
⏩ 0:31 ~ 3:15 Step #1 CURRENT_DATE(), MAX()
⏩ 3:16 ~ 4:24 Step #2 CONCAT()
⏩ 4:25 🎨 Formatting
Do you find this tutorial helpful? Lemme know in the comment below 👇👇👇
Dates related articles / videos:
‣ Calculate number of days from date range picker: • Data Studio Hacks - Calculate No. of Days ...
‣Calculate remaining days of a month in Data Studio: https://towardsdatascience.com/calcul...
‣ Create rolling dates in Data Studio: • Advanced Date Selection in Google Data Stu...
‣ How to fix dates format in Data Studio? (COMING SOON, I'm editing the video, subscribe and turn on Bell Notification if you want to get notified)
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.]
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ https://ko-fi.com/T6T25PD0A
📘 Google Data Studio Documentation:
‣ CURRENT_DATE() https://support.google.com/datastudio... - Equivalent to TODAY()
‣ Time Zone Database Reference - https://en.wikipedia.org/wiki/List_of...
‣ MAX() - https://support.google.com/datastudio...
‣ CONCAT() - https://support.google.com/datastudio...
#Google #DataStudio #Tutorial #Danalyser
--------------------------------------------------------------------------------------------------------------------------
👧🏻 The person behind this channel is a Malaysian-Chinese Data Analyst. Aspired to create content for non-technical background audiences to up their game in their careers or even for students to prepare for their future career at early stages.
🌱 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
---------------------------------------------------------------------------------------------------------------------------
💌 MUST KNOW FEATURES in DATA STUDIO
⚈ How to work with timestamps in Data Studio? 👉
• Google Data Studio Tutorial | How to work ...
⚈ Export Data from Data Studio
• How to Export Data From Google Data Studio...
⚈ Automation in Data Studio (Email Delivery)
• How to automate data studio report? ✉️ Sch...
⚈ Master Filter in Data Studio 👉
• Google Data Studio Tutorials | Master Filt...
---------------------------------------------------------------------------------------------------------------------------
💡 CYAD series -
Customize Youtube Analytics Dashboard
is an on-going project I do to build a customized dashboard for my channel.
🎥 EP1: HOW TO BUILD YOUTUBE ANALYTICS DASHBOARD USING TEMPLATE
• How To Build A MONETIZATION TRACKER For Yo...
🎥 EP2: HOW TO BUILD A YOUTUBE MONETIZATION TRACKER
• How To Build A MONETIZATION TRACKER For Yo...
🎥 EP3: HOW TO AUTOMATE YOUR DASHBOARD
• How to automate data studio report? ✉️ Sch...