Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
So I want to count the number of active cases but not only per selected quarter but I want count from the selected quarter backwards. Example I selected last quarter of 2020 (Oct - Dec 2020) I don't want to count the active cases for Oct - Dec but I want to count all the active cases from the last quarter of 2020 back.
I have a quarter on the list box as you can see on the attached pic.
I hope my question make sense. Below is the sample of my expression:
count(if(BV_Ind=1 and GHHInd=1 and ActiveInd=1, CaseId))
Hello lindelanifakude,
Your need is perfectly feasilble applying Set Analysis, isn't it ?
Best regards
Marcos