pstrand2

Discussions

How to SUM working days correctly?
Hi everyone, I have a strange problem. Probably more of a SQL question than a Domo question, but here we go. I have a typical date column (yyyy-mm-dd) and a column called "total working days in month" where it returns a aggregate value of the # of working days for each month. Below is an example (just assume every date is…
How to aggregate CASE Statement values?
In my dataset, I have three different tests that aggregate the field Forecast differently. Here's a beast mode I made that works pretty well, except when I'm trying to add them all together: CASE WHEN Test = 1 THEN SUM (Forecast) WHEN Test = 2 THEN SUM (DISTINCT Forecast) WHEN Test = 3 THEN SUM (DISTINCT Forecast) END when…