GrantSmith Coach 
-
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 -
Re: How to import date/time values in workbench exactly as 8/26/2024 9:00:49 AM, without any transform?
In your schema you can define it as a STRING instead of a DATETIME so it'll import the characters exactly as defined.2
