GrantSmith Coach 
-
Re: What is the format for the substring function?
This KB article may be of help where it outlines the different functions and their formats:https://domo-support.domo.com/s/article/360043429933?language=en_US SUBSTRING(`Column`,[START POSITION],[NUM…4 -
Re: Date Transform
You can utilize the STR_TO_DATE function and a date format string to convert it to a date. STR_TO_DATE(CONCAT(`Year`, '-',`Month`), '%Y-%m') I'm adding in a concat to add the…2 -
Re: What function will help me determine a variable part of text?
You can use a CASE statement with a LIKE operator to determine if the word Delivery is in your string: CASE WHEN `field` LIKE '%Delivery%' THEN 'True' ELSE 'False' END I…3 -
Re: Filter Request from Custom Domo App
Have you looked at the domo.filterContainer() method? https://developer.domo.com/portal/e947d87e17547-domo-js#domofiltercontainer1 -
Re: Date format question
Use a Magic ETL with a formula tile to make the value null if it's -3: case when `field` <> -3 then `field` end You can then feed that into an alter column tile to change the type1
