RobSomers Coach 
-
Re: Multiple case statements
@NFerna For the beast mode part of your question, it would be something like this: CASE WHEN 'Achieved Value' >= 'Benchmark Value' THEN 'PASS' ELSE 'FAIL' END Assuming your data is set up so that …1 -
Re: Count Distinct with Fixed?
@Domomon DISTINCT doesn't work with window functions, and I believe that's no exclusive to Domo, as I think that goes for MySQL and SQL Server as well. I've seen that one solution is to use DENSE_RAN…3 -
Re: Does Beast Mode support using "Contains" to Identify Value Count
@afieweger Yes, you will use LIKE and wildcard characters in your case when statement: SUM(case when PresentationName LIKE '%self-service%' then 1 else 0 end) The % symbol will just say there can be …1 -
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',…) COALESC…2 -
Re: How can I group these results by date?
@Zel Is your date column just dates or is it datetime? If it's datetime it could look like the same date but they're actually unique because they have different times in the background. If it is a da…2
