HI All,
I'm trying to create two reports on SLA,
Report .1 :
| An ITIL user must be able to report on the percentage of incidents resolved within agreed Resolution SLA by Priority |
Report should look something like this,
Report.2 :
| An ITIL user must be able to report on the percentage of incidents that were acknowledged within agreed Response SLA by Priority |
Report should look something like this,
I'm unsure of how to represent the report with 75 % and 100 % time frame.
FYI - I'm running the report on task_sla table.
Sure. It's just a bar chart report on Task SLA, grouped by Business elapsed percentage, and stacked by Task.Priority. The key reason this report looks the way it does is because of the Report Ranges feature, which lets you define the thresholds for a given group. In this example, I said that 75% or less is one group, 75-100% is another group, and anything more than 100% is the 3rd group. You can use more than 3 groups if you want yours grouped more specifically than that.
You only have to specify these attributes to get it to work correctly:
1. Name: This is the table name - task_sla
2. Element: I chose business_percentage, but you could choose a different field if that's not what you want in the report.
3. Label: type in whatever you want this grouping to show as in the report.
4. Upper value int: the upper threshold for this range. This screenshot shows 75, so this range includes every number up to 75. The next report range after it specifies 100 (so the 75-100 range).
