I need a separate count of 4 specific values in 6 columns. I believe I can get one of the counts, but am not sure how to get all 4 values counted.
Formula for one of the values:
WHEN `Item Status 1-4` = 'Active'
THEN COUNT('Item Status')
After I get the values of each status, I need to get them into a chart , which I believe can do. I can probably just repeat the formula for each status, and each column, but that seems repetitive and I hope there is an easier way to accomplish this.
I can get this done in Excel but am having trouble with finding the correct way in Domo.
Any ideas out there?