GrantSmith Coach 
-
Re: Case Statement with Count Distinct
Are you keying your admitted based off of STATUS or and ADMITDATE field? What issues are you running into with your beast mode? It looks like you're missing the trailing ) in your beast mode aft…1 -
Re: Time to Number value
I'd recommend looking into TIME_TO_SEC function to convert your string into total seconds then you can divide that number by 3600 to convert to it to hours and then SUM it. TIME_TO_SEC Returns a…2 -
Re: Stack-Bar Line Graphs
Should be something like below: CASE WHEN `field` = 'Bucket 1 Value' THEN `value` END You can then use the aggregation options if you want to do a sum / min / max / avg. Just make sure you …2 -
Re: Stack-Bar Line Graphs
You can set your y-axis to be your total number / metric and then use two beast modes to calculate each of your two buckets for your bar, dragging each beast mode into your series section of your cha…2 -
Re: Doubt about updating tables and credits consumption
Your AE would be the person to help you get an answer to this. I'd recommend reaching out to them.1
