What will be the Expression

[zack]

I want to right the expression which  show count of closed request based on stream wise current fy ?

I used this but not showing any value

 count({<REQUIREMENT_STATUS={'Closed'}, CC_CLOSED_DATE={'$(=Max(CC_CLOSED_DATE))'}>} distinct EMPLOYEE_NUMBER)

Any Answer so Please share 

Thanks everyone for helping in Advance 

[MatheusC]

Hi, @zack 

How is your CC_CLOSED_DATE field? if it is in date format you may be using the expression below:

 count({<REQUIREMENT_STATUS={"Closed"}, CC_CLOSED_DATE={$(=(Date(Max(CC_CLOSED_DATE))))}>} distinct EMPLOYEE_NUMBER)

If your date has records larger than your count, then use
count({<REQUIREMENT_STATUS={"Closed"}, CC_CLOSED_DATE={$(=Date(Today(),'DD/MM/YYYY'))}>} distinct EMPLOYEE_NUMBER)

[BrunPierre]

Try with double quotes.

CC_CLOSED_DATE={"$(=Max(CC_CLOSED_DATE))"}

[zack]

Hi @BrunPierre  @MatheusC  I am getting  closed request but all the streams are not coming any solution and thanks for your reply and helping me 

[BrunPierre]

Try.

=Count(DISTINCT {<REQUIREMENT_STATUS={"Closed"}>} If(Aggr(NODISTINCT Max(CC_CLOSED_DATE), EMPLOYEE_NUMBER, Stream) = CC_CLOSED_DATE, EMPLOYEE_NUMBER))