Count of type in a column

[GH21]

Hi All, 

Looking for an answer if it is possible to count the amount of times a word is mentioned within a column. For example we have a column with different selections such as Closed, Expired, Open, Started, Hold and In-Contract. Is it possible to count the amount of times Closed is in the column? 

Also can I do the same for a RAG status looking to count the amount of Red's, Amber's and Green's?

Thanks in Advance

[Idrissshatila]

Hello @GH21 ,

try this

Count of Expired= calculate(countrows(tableName), column = "Expired")

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[GH21]

Hi @Idrissshatila, it's not working on my end just saying this 

[Idrissshatila · Accepted solution]

Hello @GH21 ,

Please remove the Bracket (  before the calculate 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin