Display TODAY's DATE as a TITLE in Data Studio [Calculated Field: CURRENT_DATE, MAX, CONCAT]

[@danalyser]

Do you find these Data Studio “Hacks” video helpful? Let me know in the comment section!

[@Martin-uv4zg]

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

[@danalyser]

You're welcome! Thanks for sharing the solution Martin, appreciate it! 💛

[@GuillermoMenaTechDude]

This was just the help I needed, thank you!

[@danalyser]

Glad it helped! 😊😊

[@benigiussiraivaalbert9790]

Thank you so much. This is exactly what I was looking for.

[@danalyser]

You're welcome! :) Happy to hear that this tutorial is useful for you :) - SL

[@mindaugasvisockis893]

Thank you

[@danalyser]

Glad that you found the answer you need! :D

[@judenwachukwu1323]

your tutorials are golden, keep it up

[@danalyser]

Thank you Jude! :) Will do, always welcome your feedback! - SL

[@adanahmaritablero7128]

I really appreciate your content. Please make more

[@danalyser]

Sure! Thanks for supporting! 💛

[@prabalnadoni8897]

Thank you & danalyser :),, very good knowledge you shared.

[@danalyser]

You’re welcome and thank you for your support! I appreciate it :)

[@pixelharmonie-webdesign]

Thats sooooo awesome! In the past i used i d self generated php file... dirty way... but u bring the clean way ♥

[@clintonsihombing5050]

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?

[@anicetorvt]

Excelente!!, muchas gracias por la información.

[@fernandolisboa]

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!

[@paoloblaquera-guitarist461]

This is exactly what I was looking for! Thank you very much!

[@danalyser]

Hey! You're most welcome! Glad that it's helpful! :)

[@carloperez5703]

Great information. Thanks a lot.

[@danalyser]

Most welcome Carlo 😊

[@sahandharmarathne8251]

Thank you so much

[@silvinanaidicz423]

Thank you

[@danalyser]

You're so welcome Silvina!

[@shawnchristophermalig4339]

My gosh thank you.

[@hidayahlokman4065]

Hi, what id i want to display for yesterday date..do you know how? thankss much appreciated

[@hidayahlokman4065]

I tried this MAX(TODAY("Asia/Kuala_Lumpur")-1) but it doesnt work

[@danalyser]

Hey Hidayah! Thanks for sharing your approach :) I managed to find solution for your question and would address it in my video tonight 🤞

[@danalyser]

Hi Hidayah, Kindly refer to this video tutorial to see the solution ✨ kzbin.info/www/bejne/hHjHhoOBn7KYn5I

[@hidayahlokman4065]

@@danalyser waa thank you so muchhh for your helpppp ❤❤❤❤❤❤

[@danalyser]

@@hidayahlokman4065 sama sama 😉🥰

[@carinekempf5823]

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

[@danalyser]

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: kzbin.info/www/bejne/rZq1lJqHgMuFZ80

[@carinekempf5823]

@@danalyser Hi, Thank you. Have a nice day

[@danalyser]

@@carinekempf5823 Thank you! Take care and have a great day 😊

[@hidayahlokman4065]

Hi, do you know how to change the date format to ddd/mmm/yyy instead of yyy/mmm/ddd at the title? thank you

[@danalyser]

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

[@hidayahlokman4065]

@@danalyser thank you so much..btw do you know how to make plan date vs actual date bar chart by monthly...thank you

[@tfcasti]

Thanks a lot.

[@CamronSabour]

You are the best

[@ramzidjauhari7575]

SL, can we format the date in data studio, eg “Senin, 3 Juli 2022”? Thank you.

[@danalyser]

Thank you Ramzi for sharing your suggestion! I’ll try to address this question in my next tutorial video. Stay tune! ❤️

[@fanioppo2324]

Awesome. Plz increase video volume. Feels difficulty to understand at some points due to low volume 😬

[@danalyser]

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! 🤍

[@yonojunot3290]

Hi I want to ask you how to display the current week? Thanks

[@danalyser]

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

[@yonojunot3290]

@@danalyser it's okay, thanks for the information

[@danalyser]

@@yonojunot3290 you’re so welcome! Thanks for being so considerate with me 🥰🥰❤️

[@abucubaydah982]

Hi I have data but not accepting to insert date into the dashbaord

[@danalyser]

Hi Abu, would you mind provide more details about your issue?

[@DeepakSharma-ce6qe]

Hey, How to pick a single date and show the value (price) on that particular date on a scorecard.

[@danalyser]

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 :)

[@DeepakSharma-ce6qe]

@@danalyser Thanks..💞

[@speedym24]

❤️❤️❤️❤️❤️

[@danalyser]

Thank you!! 🤍🤍🤍

[@saiananth8751]

How to add date in subject line while scheduling reports

[@danalyser]

Hey Sai, unfortunately we can't add parameter to the subject line, so we can't do this at the moment.

[@NurulShahirahMokthar]

I got an error for the title

[@Clipsbykim2]

thank you

[@danalyser]

You're so welcome, thanks for supporting and watching my videos! :)