jaeW_at_Onyx Coach 
-
Re: Why are my filters not working in Magic ETL?
@damen to be more specific, you should (probably) impelment the metric @RobSomers is describing as a Beast Mode in Analyzer. Typically we recommend against preaggregating datasets in ETL if we don't …4 -
Re: MySQL Indexing Issues
@trafalger I do wonder if you add the index in the UI if the data is indexed as it's being loaded into the table, or if if the index is added after CREATE TABLE AS SELECT ... So i i guess if you want…1 -
Re: Find greatest value for each specific ID
+1 @trafalger window function max() would be good except the window doesn't have an unlimited end of window. so group by would be the best.1 -
Re: What is the best way to calculate?
@damen the learning lesson is you shouldn't have nested CASE statements AVG( case when (CASE WHEN (`instrument` = 'first home') THEN '1st Home' WHEN (`instrument` = 'fannie mae risk share') THEN 'NoM…1 -
Re: Filling blank cells with 0
@akki given the nature of pivot tables, you will see a row for outcomes 5 and 4 since they exist for the month of september, but to your point there is no data there. even if you wrote coalesce( sum(…2
