Godiepi Coach 
-
Re: Split string column into multiple rows
You will need to set up a Magic ETL like this : 1) load your data into a Magic ETL 2) Split your Note column into multiple notes, In my example I use only 3 using the following configuration use a co…1 -
Re: Requests Older than 6 Days
Hi @Fadem You need to change the order if using "greater than or equal to" 6 like this SUM(case when DATEDIFF(CURRENT_DATE(),`Effective Time`) >=6 then 1 else 0 end)2 -
Re: Extracting the Date Based on a pattern
Yes no problem , no need to say WHEN again ... This way should clear out the error CASE WHEN LEFT(`ORDERSTATUS`,1) ='*' OR `ORDERSTATUS` like '%BAM%' THEN DATE_FORMAT(RIGHT(TRIM(`ORDERSTATUS`),10),'%…2 -
Re: Extracting the Date Based on a pattern
@ozarkram check for the * character in the string if present then get the last 10 characters from the strings (if always is the date at the end) convert it to a date format month , day and year if th…2 -
Re: Number of dashboard visits
@levand , What @GrantSmith is referring to is the [Activity Log] report from Domo Stats. It contains all activity in the Domo instance. Look into it for the field [Action] = 'VIEWED' and [Object Type…2
