filmov
tv
Domo Tutorial: Mimic VLOOKUP based on Date Ranges (with MySQL Window functions)
Показать описание
I'll show you how to mimic #VLOOKUP from #Excel in Domo using #MySQL Window Functions.
You can use this technique to create RANK, LEAD, and LAG functions as well as #Partitioning or #Cumulative SUM.
##### RELATED VIDEOS ####
##### CONSULTING SERVICES ####
I have left Domo to start my own consulting company, #OnyxReporting!
I'm available for short hour-long consultations and/or long term contracts.
Services I offer.
- implementing and optimizing existing data pipelines and dashboards.
- provide remote and onsite training
- augment your implementation team as part of a long-term engagement.
##### ORIGINAL DOJO POST ####
You can use this technique to create RANK, LEAD, and LAG functions as well as #Partitioning or #Cumulative SUM.
##### RELATED VIDEOS ####
##### CONSULTING SERVICES ####
I have left Domo to start my own consulting company, #OnyxReporting!
I'm available for short hour-long consultations and/or long term contracts.
Services I offer.
- implementing and optimizing existing data pipelines and dashboards.
- provide remote and onsite training
- augment your implementation team as part of a long-term engagement.
##### ORIGINAL DOJO POST ####
0:22:57
Domo Tutorial: Mimic VLOOKUP based on Date Ranges (with MySQL Window functions)
0:01:05
Using Group By in Magic ETL
0:16:20
Domo Tutorial - Calculating Order Fulfillment with MagicETL and Feature Engineering for Data Science
0:04:29
Domo ETL Formulas
0:35:06
Hacking Domo Webform: Creating 'Excel-Like' Reports
0:53:25
DOMO - Complete guide to Recursive Dataflows in MagicETL (Slowly Changing Dimensions Type 1 & 2)
0:07:49
Domo Help: Replacing null or blank values with another table using Domo ETL
0:02:19
Aggregate Functions with CASE Statements
0:10:41
Domo - ETL - calculate percent of total without count distinct using MagicETL
0:00:57
How to use a CSV as a DataSet in Domo @Domotalk
0:54:31
Build a week-based Date table in Domo using Magic ETL // For 4-4-5 retail & financial use cases
0:07:15
Filling in Date Gaps in Domo
0:00:58
DOMO Uploading & Using Data
0:01:00
How to create a Domo Online Form @Domotalk
0:08:18
Fixed Functions
0:17:17
Domo MagicETL: month on month performance / calculating streaks using Window Functions
0:18:14
Tracking changes in Domo Beast Modes over Time || Magic ETL + Partitions & Window Functions
0:16:50
Business Intelligence with Domo – From the idea to the V1 BI product in 10 minutes (MySQL & GA)...
0:21:26
Domo - MySQL - Reporting on task completion, Finding the Last Date
0:43:05
Ultimate 2020 DOMO Window Function Tutorial -- average time to accumulate a value
0:01:14
How to add Google Sheets DataSet in Domo @Domotalk
0:01:46
Advanced Functionality of CASE Statements - And/Or Statements
0:30:37
Domo Everywhere - Live Demo - June 2022
0:12:14
Handling DateTime and Daylight Saving offsets in Domo
Комментарии