I have a spreadsheet as a data source indicating observations recorded with 3 options, "Yes", "No" and "Not Observed". I want to count only "No" but tableau is counting both "No" and "Not Observed". I am guessing this is because they both start with the letters NO. How can I filter out the "Not Observed" from my count?
1 answer
Good afternoon - how are you counting the Nos - { fixed ID :countd( if (yes-no flag) ="No" then ID end)} where ID is the observation ID and the yes-no flag is where the yes or n is recorded
