GrantSmith Coach 
-
Re: Magic ETL: How to REMOVE Rows Meeting a Two-Column Criteria?
Think of a filter tile as trying to selected the rows that match a certain criteria. If you're using a filter formula you can invert the logic. So if you know the logic you want to remove add a …1 -
Re: Roll up rows in table chart with similar fields
In Analyzer you can select an aggregation for your Total field and select Sum, this will group all your other columns togethers.2 -
Re: Nested Case Statement
You need to reverse the order of your SUM checks because if the sum is more than 111 it's already more than 35 so it will return Tier 2 first and quit as it executes the first case that matches.…2 -
Re: PyDomo - DS_Update to Append Data?
pydomo/ds_update doesn't support append at this time. You could configure a recursive dataflow to append your data.1 -
Re: String Operation Add Space to Postal Code
Assuming it's always 6 digits: CONCAT(LEFT(`Postal Code`, 3), ' ', RIGHT(`Postal Code`, 3))1
