Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to write below expression in set analysis :
" =COUNT(distinct {<S_ID={'686'},S_ACTION_LKCD={'APPROVE','SUBMIT'},USER_CATEGORY={'Other'},S_CODE={"*SRV-BMS*"},C_KPI_ID={'126'},T_YEAR={'$(vTemp4)'},T_MONTH={'$(vTemp5)'}>}if(NetWorkDays(Timestamp(aggr({<S_ID={'686'},T_YEAR={'$(vTemp4)'},T_MONTH={'$(vTemp5)'}>}Min(T_DATE),REQ_ID)),Timestamp(aggr({<S_ID={'686'},T_YEAR={'$(vTemp4)'},T_MONTH={'$(vTemp5)'}>}MAX(MAX_ACTION_DATE),REQ_ID))) <=3,REQ_ID)) "
