Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My current pie chart shows % of DEFECT_ID in the CUR_GOV_PROCESS_QUEUE of 'Regional Clinical Informatics' by CUR_STATUS.
=Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}>}distinct DEFECT_ID)/Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}>} TOTAL distinct DEFECT_ID)
I need to modify this to exclude those that PREVIOUSLY were in any GOV_PROCESS_QUEUE = ERC*.
I've tried -= & = vs e()*p() but I can't get either to work correctly. Any help would be appreciated.
May be this
=Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}, DEFECT_ID = e({<GOV_PROCESS_QUEUE = {"ERC*"}>})>}distinct DEFECT_ID)/Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}, DEFECT_ID = e({<GOV_PROCESS_QUEUE = {"ERC*"}>})>} TOTAL distinct DEFECT_ID)
May be this
=Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}, DEFECT_ID = e({<GOV_PROCESS_QUEUE = {"ERC*"}>})>}distinct DEFECT_ID)/Count({$<CUR_GOV_PROCESS_QUEUE={'Regional Clinical Informatics'}, DEFECT_ID = e({<GOV_PROCESS_QUEUE = {"ERC*"}>})>} TOTAL distinct DEFECT_ID)
I think this works. Thanks Sunny!