Forum Discussion
Yes / No Filter
Good evening.
I'm working with a dataset which contains one column where users can enter either a 'YES' or 'NO' response. In my dashboard, the customer has requested 2 cards, one counting the number of YES responses and the other counting the number of NO responses, per employee.
See the below example. In this instance, the Employee has 6 responses, all 'NO'. I'm using a 'Count' on each card to return the number of responses, and an advanced filter on each card to show items where the value is either YES or NO. For this example, because all responses are NO, the YES card returns a (Blank). Clearly the filter is working correct, however how do I get the (Blank) to display as a 0?
| Employee | YES / NO REPLY |
| Joe Smith | No |
| Joe Smith | No |
| Joe Smith | No |
| Joe Smith | No |
| Joe Smith | No |
| Joe Smith | No |
Appreciate any help!
mdemasi31 So generally take whatever your formula is and add + 0. So, let's say you have a measure that is:
Measure = COUNTROWS('Table')
Then you can change it to:
Measure = COUNTROWS('Table') + 0
For example.
3 Replies
- Greg_DecklerCommunity Champion
mdemasi31 So generally take whatever your formula is and add + 0. So, let's say you have a measure that is:
Measure = COUNTROWS('Table')
Then you can change it to:
Measure = COUNTROWS('Table') + 0
For example.
- mdemasi31New Member
Much appreciated, Greg. Worked easily. Thanks for the lesson!
- Tang0New Member
Can I wear cargos