GrantSmith Coach 
-
Re: Need help writing a Beastmode
Try putting your aggregation outside of your case statement SUM(CASE WHEN `Age group` IN ('121-180 Days','181-270 Days','271-365 Days','366-730 Days','731 Days+') THEN `CurrentBalance` END)2 -
Re: HTML Card | Background Color Style
You have a typo in your style <div style="background=color should be <div style="background-color1 -
Re: Does domo allow a dataflow to run for more than 24 hours
I'd recommend switching your logic over to a Magic ETL. MySQL runs on 5.6 which is an older version and due to the nature of those dataflows they run sequentially and can run much slower. I've seen M…1 -
Re: Sorting Day of Week on the X-Axis
You’d need to create another beast mode with a case statement to return a numerical value for the day and order you want CASE WHEN DAYNAME(`date`) = 'Sunday' then 8 ELSE DAYOFWEEK(`date`) end DAYOFWE…4 -
Re: Extra 0 bar in bar chart with beast mode
This is because your beast mode is returning NULL for some records (where none of the conditions are met). You can filter out the NULLs and it will remove it from the chart.2
