GrantSmith Coach 
-
Re: Count number of character occurrence in string
You can calculate the length of the string, remove the character you want, recalculate the length and take the difference. LENGTH(`Color`) - LENGTH(REPLACE(`Color`, ',', '')) + 15 -
Re: Custom Domo to Excel Writeback
I've utilized Python and the pydomo package to export data from Domo and then utilize the pandas package to export the different datasets to an excel file. It's a bit technical and involved but gave …1 -
Re: YouTube Connectors Using YouTube Account Username and Password
Hi @MrDomo Do you have an enterprise account and you're wanting to pull the specific channel's videos? YouTube makes it a bit difficult as you have to log in / authenticate as the brand page account …2 -
Re: OKTA CONNECTOR reg.
OKTA's System Log API keeps data around for 90 days (source). It should be possible to get data for the last 30 days. Since Domo provides the API connector they'd need to be the ones to change the co…1 -
Re: How to extract a substring from an URL
CONCAT(SPLIT_PART(`url`, '/', 1), '/', SPLIT_PART(`url`, '/', 2)) SPLIT_PART will get the values with the data split out by a specific character. It's undocumented in the UI but is accessible. Concat…2
