GrantSmith Coach 
-
Re: using IF then WHEN
you can use AND to combine logcal expressions together if both should be true or OR if one needs to be true. Alternatively you can add an additional WHEN clause to your case statement to do something…1 -
Re: Question on Expanding Data to Display Unique Values
You can do this within a Magic ETL. If you do something like this: This will do a cartesian join between the list of years and your dataset and then filter the records where the year is in between yo…2 -
Re: Flag percent of change when it goes negative
You can use a beast mode and the lag window function to calculate the percentage difference: (`Login Value` - lag(`Login Value`,1) over(PARTITION BY `Member` ORDER BY `Login Date`) ) / lag(`Login Val…1 -
Re: How to create a recursive dataflow with multiple unique dimensions?
Are you attempting to utilize a single field in your recursive dataflow join for your key field? You should be able to select multiple key columns which uniquely identify each record. Just make sure …1 -
Re: Transpose columns into multiple rows
You can utilize Magic ETL and the Dynamic Unpivot tile to take your columns and convert it to rows. Here's more information: https://domo-support.domo.com/s/article/360044951294?language=en_US1
