Display TODAY's DATE as a TITLE in Data Studio [Calculated Field: CURRENT_DATE, MAX, CONCAT]
Вставка
- Опубліковано 2 лип 2024
- 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 - Ca...
‣Calculate remaining days of a month in Data Studio: towardsdatascience.com/calcul...
‣ Create rolling dates in Data Studio: • Advanced Date Selectio...
‣ 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: 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 @ ko-fi.com/T6T25PD0A
📘 Google Data Studio Documentation:
‣ CURRENT_DATE() support.google.com/datastudio... - Equivalent to TODAY()
‣ Time Zone Database Reference - en.wikipedia.org/wiki/List_of...
‣ MAX() - support.google.com/datastudio...
‣ CONCAT() - 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 Tut...
⚈ Export Data from Data Studio
• How to Export Data Fro...
⚈ Automation in Data Studio (Email Delivery)
• How to automate data s...
⚈ Master Filter in Data Studio 👉
• Google Data Studio Tut...
---------------------------------------------------------------------------------------------------------------------------
💡 CYAD series -
Customize UA-cam Analytics Dashboard
is an on-going project I do to build a customized dashboard for my channel.
🎥 EP1: HOW TO BUILD UA-cam ANALYTICS DASHBOARD USING TEMPLATE
• How To Build A MONETIZ...
🎥 EP2: HOW TO BUILD A UA-cam MONETIZATION TRACKER
• How To Build A MONETIZ...
🎥 EP3: HOW TO AUTOMATE YOUR DASHBOARD
• How to automate data s... - Навчання та стиль
Do you find these Data Studio “Hacks” video helpful? Let me know in the comment section!
Thats sooooo awesome! In the past i used i d self generated php file... dirty way... but u bring the clean way ♥
You are the best
This is exactly what I was looking for! Thank you very much!
Hey! You're most welcome! Glad that it's helpful! :)
Great video, thanks! It helped me to find a way to display previous month name for monthly report. This is the formula:
MONTH(CURRENT_DATE("+02"))-1
You're welcome! Thanks for sharing the solution Martin, appreciate it! 💛
Thank you so much. This is exactly what I was looking for.
You're welcome! :) Happy to hear that this tutorial is useful for you :)
- SL
Thank you
Glad that you found the answer you need! :D
This was just the help I needed, thank you!
Glad it helped! 😊😊
Excelente!!, muchas gracias por la información.
your tutorials are golden, keep it up
Thank you Jude! :) Will do, always welcome your feedback!
- SL
My gosh thank you.
Thank you & danalyser :),, very good knowledge you shared.
You’re welcome and thank you for your support! I appreciate it :)
Thanks a lot.
Great information. Thanks a lot.
Most welcome Carlo 😊
I really appreciate your content. Please make more
Sure! Thanks for supporting! 💛
thank you
You're so welcome, thanks for supporting and watching my videos! :)
Hi, thanks for your vidio and for this channel❤. May I ask, how to show the title and follow by the month that choose by the filter button?
Hi, great video, there are a way to create a filter to select only registers for "today", but in filter option, not in dimension period!
Thank you
You're so welcome Silvina!
❤️❤️❤️❤️❤️
Thank you!! 🤍🤍🤍
Awesome.
Plz increase video volume. Feels difficulty to understand at some points due to low volume 😬
Thank you Fani!! Alright I gotchu 😉 will take note on this, do watch my new video to see if it gets better - i use the built in audio from my webcam. It’s much louder imo, but would love to hear your feedback! 🤍
Good afternoon,
I saw that Data Studio is set up by default with the UTC time zone.
How can I change this to suit my region?
Thank you very much for your help
Hi Carine! Thanks for watching.
If you are referring to the CURRENT_DATE() formula, you can specify your region timezone in the formula. For example, if you are from LA you can use either one of the formula below:
#1 Timezone Name: CURRENT_DATE("America/Los_Angeles")
#2 Timezone Offset: CURRENT_DATE("-08")
Here are some reference that might be useful to you:
Current_date() :support.google.com/datastudio/answer/9736967?hl=en&ref_topic=7583292
Timezone definitions: en.wikipedia.org/wiki/List_of_tz_database_time_zones
I do have a video that talks about how to convert the timezone for datetime in Data Studio if you are interested to watch: ua-cam.com/video/wiRcgQKfR1k/v-deo.html
@@danalyser Hi, Thank you. Have a nice day
@@carinekempf5823 Thank you! Take care and have a great day 😊
Hi, do you know how to change the date format to ddd/mmm/yyy instead of yyy/mmm/ddd at the title? thank you
Hi Hidayah, you may use FORMAT_DATETIME() to convert date to your desired format.
Link to Documentation for your reference: support.google.com/datastudio/answer/9730334?hl=en
@@danalyser thank you so much..btw do you know how to make plan date vs actual date bar chart by monthly...thank you
SL, can we format the date in data studio, eg “Senin, 3 Juli 2022”? Thank you.
Thank you Ramzi for sharing your suggestion! I’ll try to address this question in my next tutorial video. Stay tune! ❤️
Hi, what id i want to display for yesterday date..do you know how? thankss much appreciated
I tried this MAX(TODAY("Asia/Kuala_Lumpur")-1) but it doesnt work
Hey Hidayah! Thanks for sharing your approach :) I managed to find solution for your question and would address it in my video tonight 🤞
Hi Hidayah, Kindly refer to this video tutorial to see the solution ✨
ua-cam.com/video/NGdUPKjMei0/v-deo.html
@@danalyser waa thank you so muchhh for your helpppp ❤❤❤❤❤❤
@@hidayahlokman4065 sama sama 😉🥰
Hey, How to pick a single date and show the value (price) on that particular date on a scorecard.
Hey Deepak, it’s quite similar to how we show today’s date. Just use the formula MAX(date_field) in the scorecard, and it should display the date accordingly when the date is being selected. Downside is it’ll always show one date which is the latest date - can be confusing to your users.
Would suggest to use this approach if your report was filtered to one date by default. Or maybe a disclaimer would help make it clear :)
@@danalyser Thanks..💞
Hi I want to ask you how to display the current week? Thanks
Hey sorry for the very late replies! You can use WEEK formula for that! :) Here's the official documentation: support.google.com/looker-studio/answer/7583313?hl=en
@@danalyser it's okay, thanks for the information
@@yonojunot3290 you’re so welcome! Thanks for being so considerate with me 🥰🥰❤️
Hi I have data but not accepting to insert date into the dashbaord
Hi Abu, would you mind provide more details about your issue?
How to add date in subject line while scheduling reports
Hey Sai, unfortunately we can't add parameter to the subject line, so we can't do this at the moment.
I got an error for the title