jaeW_at_Onyx Coach 
-
Re: Separate Date from the text
@user041053 use regex to identify if a set of characters are formatted as a date. then use INSTR or SUBSTRING to try to extract the set of characters then use STR_TO_DATE to convert the extracted val…2 -
Re: How can we use similar function as Vlookup??
you have to alter dataset_a to include a column, min_units and max_units then you JOIN dataset_a to dataset_b on a BETWEEN clause in MySQL2 -
Re: Unique Values Pulling Through twice
you can use a TRIM function in ETL or analyzer beast modes.2 -
Re: CustomApp - Dashboard & OtherCard
@stefanlambert , ... you can easily do what's available in the domo.js function. If you're building Dashboards that are filtered to subsets of data, consider creating a filtered Dataset View. Then po…1 -
Re: Sum One Check Amount with multiple rows of the same data by using DISTINCT ?
I assume this is data where you took a payment table and JOINed it to a Employee Timesheet table. Don't JOIN the data. Append, UNION, the two sets of data together. I know it sounds like work to unde…2
