Best Of
Re: Admin unable to run update on GoogleSheet Dataset
The issue here is not who is running the dataset but the owner of the dataset does not have access to the account that holds the credentials. So there are two opinions, you can do go into the account section of the Datacenter and share the account in question with the person that owns the dataset.
The other option is to change the owner to the dataset to the same person that owns the Account
Re: Simple Reg ex help
You can use the formula tile and the split_part function to get the string after the hyphen. Your formula would look like this:
TRIM(SPLIT_PART(fieldname,'-',2))
This will get the value after the dash and remove any extra spaces.
Re: Number Format issues at dashboard/instance level
Have upvoted this as absolutely crucial for us to have this at instance level which would hopefully then impact every element. Our customers love to export tables to Excel and without the separators being correct Excel will not see those cells as numbers!
Re: Case statement with multiple conditions
@renee12345 It looks like you're just trying to find the first exclusion reason that isn't null. You'll want use the COALESCE() function:
COALESCE('exclusion reason 1','exclusion reason 2',…)
COALESCE looks through the first field listed and if it's null, moves on to the next field, and repeats the process until it finds a non-null value.
Re: Scatter Plot with a dynamic x-axis scale marker?
Here you go: https://community-forums.domo.com/main/categories/ideas
it’s another section on these forums.


