Best Of
Re: HELP! Can not get this ETL Formula to Validate
Only the first CASE keyword is needed you can remove the others but leave them when and clauses
Re: Weekly chart showing dates that aren't correctly aggregated
This is a bug that has been resolved. The fix should be released in the next week or two.
Re: How can I remove all special characters and spaces from values in a field?
Regular expressions are your friend in this case. You could ignore any non-alphanumeric characters in your string with something like this with a formula tile:
REGEXP_REPLACE(`field`, '[^a-zA-Z0-9]', '')
[] = Group of possible characters
^ = NOT
a-zA-Z any letter
0-9 = any digit
Re: Is Domo treating 0 as NULL? Card filtering 0 value as NULL
I got the same behavior when trying to exclude Null / NaN value from Integer.
My workaround is to use the beastmode below to exclude the Null
Example unfiltered data
When is NaN = 0
michiko
Re: Grand Total summing the percentage instead of calculating
you'll need to aggregate the data in the beastmode when calculating the variance like below
(sum(Column) - sum(Column 1)) / sum(Column 1) *100
I suspect you may just be doing
(Column-Column 1) / Column 1*100
Jones01