Need help in Formula Tool

[Shree185]

Hello, I need help

I am trying to create a calculated column 

Calculated column =  non-blank row count [resolved date ] where queue = TAC

[binu_acs]

@Shree185  Add Summarize tool in the canvas, group by queue field then count non null of the [resolved date]

add filter tool with the condition queue = 'TAC'

[Qiu]

@Shree185 

We can use the Feature "Count Non-null" in the summarize tool.
We first convert all the Blank cell in  [resolved date ]  to null then count and filter as below.