Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count a Boolean column based on another column Value

  I'm trying to create a count of the Article Shared column based on what's in the Case Status column. I need to know how many Closed cases have a True in the Article Shared column. Is this somethi...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Try this, 

     

    Closed Cases = 
    COUNTROWS(
        FILTER(
            Sample_Data, 
            Sample_Data[Case Status] = "Closed"
            && 
            Sample_Data[Article Share] = TRUE()
        )
    )

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Try this, 

 

Closed Cases = 
    COUNTROWS(
        FILTER(
            Sample_Data, 
            Sample_Data[Case Status] = "Closed"
            && 
            Sample_Data[Article Share] = TRUE()
        )
    )

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Perfect. Thank you so much for your help