jaeW_at_Onyx Coach 
-
Re: SQL Syntax tips for a beginner
@user065584 , i have an answer you didn't ask for ... don't learn MySQL to become more effective in Domo. Spend time in MagicETL. I get it, hard pill to swallow for a person who does scripting. Magic…5 -
Re: pivot table column percentages
https://www.youtube.com/watch?v=ZPf41Fjn1H8 I did a tutorial video on this very topic! Check it out. You may need to contact your CSM to get 'window functions enabled in beast modes' before you can p…4 -
Re: How can I group multiple columns by year-month in the dataflow?
you CAN do a lag function in Analyzer! Youtube video explanation: https://youtu.be/cnc6gMKZ9R8 lag(sum(`Measure1`)) over( order by year(`Date`) * 100 + WEEKOFYEAR(`Date`) )4 -
Re: Using aggregation in case statements
while @GrantSmith 's statement that you can't divide by 0 is true, that's not the root cause of your problem. (i suspect). you can't write this. even if you ignore the divide by 0 issue, it's still l…3 -
Re: MySQL Recursive CTE - Date Range Split
If you SELECT VERSION() you'll see which version of MySQL you're developing against, MySQL 5.6, https://dev.mysql.com/doc/refman/8.0/en/with.html MySQL 5.6 does not support CTEs :( But if you have a …4
