GrantSmith Coach 
-
Re: Beast mode
In a beast mode you can do something like: CASE WHEN `value` >= 1 THEN 1 ELSE `value` END In a Magic ETL formula tile you can use the LEAST function: LEAST(`value`, 1)2 -
Re: Can you convert Date to Text in DOMO?
Is Domo interpreting your initial string as a date and the column is a timestamp data type? There a function called STR_TO_DATE which will allow you to convert a string to a date type object based on…2 -
Re: Concatenate in Magic ETL
You likely have some blank spaces in your 3rd party field. To handle these you can ignore empty fields: GROUP_CONCAT(DISTINCT CASE WHEN TRIM(COALESCE(`3rd Party`, '')) <> ''…1 -
Re: Reverse the inclusivity of 0 in Multi-Value Column for Value changes
It's currently not supported by default. I'd recommend adding an idea to the idea exchange to add an option for 0 specific colorization. I'm sure others are wanting to do this as well.…1 -
Re: Add a condition on line plot to toggle between AVG and SUM conditions
The issue is with the count portion, are you looking for distinct row counts you can CONCAT all of the fields together: COUNT(CONCAT(Plant, Group, Code, Month, Name, Part Number1, Part Number2))1
