This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Work with Datetime in Looker Studio
Welcome!
Introduction to WWDT (4:19)
Download Dataset & Setup Lab Workbook (2:31)
Module 1: Date and Time Fundamentals
Date Field in Looker Studio (4:57)
Aggregate with Date & Time (1:29)
How to Use Date Functions in Calculated Fields (3:27)
Compatibility Mode (4:01)
Module 2: Date Time Functions > Part 1: Extract Date Part
Introduction to Module 2
Year (3:37)
Quarter (2:16)
Year Week (2:50)
Month (1:24)
Day (1:38)
Week (2:01)
Weekday (2:43)
Hour (1:46)
Minute (1:21)
Second (1:10)
Extract (6:19)
Check Point 2.1: Quiz
Module 2: Date Time Functions > Part 2: System Date Time
Current Date (8:35)
Current Datetime (6:00)
Check Point 2.2: Quiz
Module 2: Date Time Functions > Part 3 Datetime Operations
Datetime Add (4:13)
Datetime Sub (3:14)
Date Diff (4:04)
Datetime Diff (4:15)
Datetime Trunc (3:17)
Check Point 2.3: Quiz
Module 2: Date Time Functions > Part 4 Formatting / Parsing
Format Datetime (4:25)
Parse Date (9:51)
Parse Datetime (4:45)
Todate (6:16)
Date (3:41)
Check Point 2.4: Quiz
Module 2: Date Time Functions > Part 5 Aggregations
Calculate Number of Days (2:47)
Get Earliest Date (1:34)
Get Latest Date (2:11)
Check Point 2.5: Quiz
Module 3: Applications of Date Time Functions
Display Yesterday Date (7:04)
Convert Timezone (5:00)
Calculate Number of Days Until Today (4:10)
Calculate Duration (Days) Between Two Dates (4:42)
Calculate Remaining Days in the Month (14:11)
Calculate Remaining Days in the Year (13:55)
Display Week Number with Date Range (Default) (3:32)
Customise Week Labels (9:47)
Weekly Time Series (Start on Sunday) (7:13)
Module 4: Advanced Applications of Date Time Functions
Display Today's Date (3:54)
Display Current Week (Start Sunday / Monday) (6:01)
Display Current Year-Month (1:46)
Display Last Month (3:21)
Display Selected Date Ranges (7:01)
Calculate Number of Days Selected (3:30)
Calculate Number of Weekdays Selected (5:51)
Date Comparisons - How it Works? Theory Explained. (5:08)
Calculate Weekly Growth Percentage (WoW) (16:06)
Calculate Monthly Growth Percentage (MoM) (9:11)
Calculate Yearly Growth Percentage (MoM) (8:40)
Parse Datetime
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock