mlanterma

Discussions

Count if
Hello, 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: COUNT(CASE WHEN `Item Status 1-4` = 'Active' THEN COUNT('Item Status') END) After I get the values of each status, I need to get them into…
Quarter Filter On a dashboard
Hello, I need to add a filter that contains the list of quarters in the data. I can get the quarters to show in the card by using a beast mode QUARTER (Date Range), but am not able to get the quarter to show in the shared filters as a drop down list of values. The beast mode is shared to the data set. Quarters shown on the…