Forum Discussion

mdemasi31's avatar
mdemasi31
New Member
5 years ago
Solved

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?

 

EmployeeYES / NO REPLY
Joe SmithNo
Joe SmithNo
Joe SmithNo
Joe SmithNo
Joe SmithNo
Joe SmithNo

 

 

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_Deckler's avatar
    Greg_Deckler
    Community 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.

  • Much appreciated, Greg.  Worked easily.  Thanks for the lesson!