Question
Displaying grading in Report Definition
I wanted to display grading in report definition, I have created a report definition where there are total number of resolved cases for an each operator will be displayed. Based on the total number of resolved cases, I have a new column Grade, where the grading will be displayed. For example, if the total number of resolved cases are 10 for an operator, and that operator has resolved 9 cases, then, that operator should have Grade-A, as that operator has more than 90% resolved cases. I want the grading as per the below calculation:
90 - 99 --> Grade A
80 - 89 --> Grade B
70 - 79 --> Grade C
Below 70 --> Grade D
Based on the resolved cases for each operator, grade should be displayed in that report definition.
Can you please help me the best approach for this requirement.
You can use SQL function for this requirement. Create your own Function which does the above calculation and cretea an Function alias rule similar to pxSLAAgeTimelines in Embed-UserFunction class.
After server restart , you can see the new function in calculation builder [fx icon]