GrantSmith Coach 
-
Re: How can I get null/empty string fields to appear as zeros in my ETL?
You can use COALESCE and NULLIF. COALESCE(NULLIF(TRIM(`Quantity`), ''), 0)2 -
Re: Use loops to avoid rewriting case statements within a beast mode many times
There's an edge case which is causing the wrong labels. Try the following: CASE WHEN `maint_count_between_restarts` = 0 THEN 0 WHEN `maint_count_between_restarts` > 50 THEN 50 ELSE CONCAT(FLO…1 -
Re: Use loops to avoid rewriting case statements within a beast mode many times
Since your buckets are the same size you can use some math and concat to calculate your buckets for you: You can take care of the end buckets first otherwise calculate the bucket name dynamically. CA…2 -
Re: Controlling Page-Level access in App Studio
You'll need two different apps currently. I'd recommend logging an idea in the idea exchange to allow for more granular app page level access.1 -
Re: Extract multiple sets of numbers from a single string
If they're always in the same position with the same ' - ' separator you can use SPLIT_PART SPLIT_PART(`string`, ' - ', 7) SPLIT_PART(`string`, ' - ', 8)2
