I got a request here and I’m not sure how to calculate. We got a project with all kinds of issues, with a data field “Escalation Type” showing color values of RED, Yellow (which means they are mad issues).
When they are resolved, their value will be updated from RED/Yellow to Green.
We now need to calculate, on monthly basis, how many RED and Yellow issues were created and overall number of active open issues in those colors.
Any comment please kindly help. Thanks!