MarkSnodgrass Coach 
-
Re: Creating new field by summing two values from existing field
Create a beast mode/calculated field that looks like this: CASE WHEN joinmethod in ('PhoneAutomatedPin','LiveStream') THEN ‘Unassisted Entry’ ELSE joinmethod END Drag this beast m…1 -
Re: Compare last 12 complete months to prior 12 months
@NathanDorsch I was able to accomplish what you want to do by developing the period over period comparison in Magic ETL. I created a video that walk you through it, which is below. In Magic ETL, you …1 -
Re: REGEX Extracting Names
I would use the formula tile and use the replace function multiple times to remove those characters. Something like this: REPLACE(REPLACE(REPLACE(fieldname,'[',''),']',&…2 -
Re: Combine date columns
If by blank you mean null, then you can use the IFNULL() function to do the replacement ilke this: IFNULL(`appeal determination date`,`determination date`) If it isn't actually null but an empty…1 -
Re: Heatmap Time Sorting Issue
I find it best to use a numeric sort for the heat map. I would create a beast mode for the day of the week that returns the number (1-7) for the weekday, I would also do beast mode that returns a num…1
