Best Of
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.
Contextual tooltips in hover text
Anyone know if there's a way to show different tooltips in hover text depending on what series you're hovering over? For example, I have a chart that shows the percent change in value from last month as a bar and percent change in value from the same month last year. When I hover over the percent change from last month, I'd like it to just show last month's value and when I hover over the percent change from last year, I'd like the hover text to just show last year's value. Is this possible?


