Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Try with double quotes.
CC_CLOSED_DATE={"$(=Max(CC_CLOSED_DATE))"}
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
Try.
=Count(DISTINCT {<REQUIREMENT_STATUS={"Closed"}>} If(Aggr(NODISTINCT Max(CC_CLOSED_DATE), EMPLOYEE_NUMBER, Stream) = CC_CLOSED_DATE, EMPLOYEE_NUMBER))