How to Calculate Days Until Today in Looker Studio Dynamically (Formula Included!)
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- Learn how to calculate the days until today with ease in this tutorial.
This calculation is very useful if you want to calculate metrics like "Days since customer last bought" - which is a great indication of customer loyalty.
- -
✅ This video is a FREE preview of my WWDT (Work with Date Time) course Module 3, designed to help the Looker community master date fields, visualizations, and more! We'll be doing this mini datetime course for 4 WEEKS consecutively! So be sure to subscribe and join us!
🔥 EARLY BIRD SPECIAL PROMO! 🔥 😍
If you're interested in our growing library of tutorials like this, you'll love our course WWDT. We are offering early bird price at more than 60% OFF for YOU!
Check out the WWDT Looker Studio course here:
👉 bit.ly/wwdt-yt... 👈
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐦𝐨𝐫𝐞 𝐜𝐨𝐧𝐭𝐞𝐧𝐭 𝐥𝐢𝐤𝐞 𝐭𝐡𝐢𝐬 ?
👉 You can now buy me a coffee @ ko-fi.com/T6T2...
👉 Subscribe to my channel @ www.youtube.co...
👉 Shop Danalyser Templates Collection
@ www.danalyser.com
⭐️ NEW TO LOOKER STUDIO (GOOGLE DATA STUDIO)
Check out our FREE GLS Course here 👉 • FULL Google Data Studi...
We uses practical approach and covers almost everything you need to get started in Google Looker Studio! Take the course now and shine ✨
F R E E B I E S
I used Canva to make graphics for my educational 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....
[ 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.]
#GoogleLookerStudio #Danalyser #GoogleDataStudio
--------------------------------------------------------------------------------------------------------------------------
A B O U T M E
👧🏻 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.
---------------------------------------------------------------------------------------------------------------------------
💌 W A T C H N E X T
⚈ Show current date in dashboard
👉 • Display TODAY's DATE a...
⚈ Export Data from Data Studio
👉 • How to Export Data Fro...
⚈ Automation in Data Studio (Email Delivery)
👉 • How to automate data s...
Hi, can I get the start date and end date from date range filter in calculated field formula?
Best Channel
Thank you!!
Danke!
Thanks for the tips! Hope you enjoy this series!
Is there a way to exclude weekends?
Hi there! Yes there is a way to do that, I cover it in my work with datetime looker studio course, feel free to check it out 😊🙏
@@danalyser Hey! Thank you for getting back to me. I was having trouble finding the video you were referring to. Could you please tell me the name of the video?
@@naveenkumarcreditsense5350 Hey! No problem at all Naveen. It's actually one of the tutorial I have in my paid datetime course. You may find more info in the link below:
danalyser-s-school.teachable.com/p/work-with-datetime-in-looker-studio
I Struggle to get the following to work:
- 5 Different Dates with Value X
I calculate Max(X)-Min(X) as new Value P to represent the (P)rogress.
Now I try to Visualize P on an Area/Line chart with all 5 Dates on the Bottom, BUT I want each of those 5 Dates to only consider each step as the Max Date to represent
the P Value till that specific Step.
Example for the Dates listed on the Bottom time chart:
Date1: 0 (Because Min is Max)
Date2: Date2 - Date1
Date3: Date3 - Date1
Date4: Date4 - Date1
Date5: Date5 - Date1
I tried for hours to make it work and failed
Hey! Maybe you can try using data blend for this? I have a weekly growth rate tutorial that covers how you can work on such aggregation and transformation, feel free to check it out 😊
How to Data studio Metric Sum Formula