jaeW_at_Onyx Coach 
-
Re: Is there a number of rows restriction in the Domo API query functionality?
agree with @WHM 's commment... there really isn't a strong reason to export a million rows of data at a time... if you're trying to export your data mart for the sake of backing up your data mart in …1 -
Re: Counting the occurrence of a certain character in string
yes. calculate the length of your string. then subtract the length of your string if you replace the search character with a blank. ex. length('mf_string') - length(replace( 'mf_string', 'M', ''))3 -
Re: Combining two header rows
I don't think there's an easy way per-se to accomplish this. 1) create a rownumber called row_id using the Rank & Window Tile. 2) split your data using 2x SELECT tiles, with Row_ID in both SELECT…1 -
Re: Total Column in a different column
sounds like you're trying to do a category subtotal. you can implement that with a windowed function sum(sum(amount)) over (partition by category) you need to have the feature switch enabled. talk to…1 -
Re: Receiving an error in my Beastmode | Multiple case statements
@GrantSmith sorry, your code may be good, but your reason is innacurate. you absolutely CAN aggregate across ROWS with the SUM column and include NULLS. so SELECT SUM( 5 4 null 6 ) as myTotal FROM ta…1
