Create a dashboard with RITM details using a Pi diagram

dvass0107 · 3 weeks ago

Team ,

I have a requirement to create a pi diagram to display a RITM details of the following and add to a dahsboard using a PI digram.

So I could manage to get the all data in a database view. But I am not sure how prepare this chart and add to a dashboard

So can sombody help me to achieve this?

Vaibhav Chouhan · 3 weeks ago

You are on the right track with the Database View. To build the pie chart for Customer RITM Resolution, just create a report using your Database View as the table and choose Pie as the report type. Set the aggregation to Count and group by a field that represents the resolution outcome, like SLA missed, tickets resolved same day, and tickets resolved on subsequent days. If you do not already have a field like this, you will need to create or derive it in your Database View based on SLA and resolution data.

Once the report looks correct with these three categories, save it. Then go to your dashboard, add content, select Reports, and add this report to display the pie chart.

View solution in original post

Vaibhav Chouhan · 3 weeks ago

You are on the right track with the Database View. To build the pie chart for Customer RITM Resolution, just create a report using your Database View as the table and choose Pie as the report type. Set the aggregation to Count and group by a field that represents the resolution outcome, like SLA missed, tickets resolved same day, and tickets resolved on subsequent days. If you do not already have a field like this, you will need to create or derive it in your Database View based on SLA and resolution data.

Once the report looks correct with these three categories, save it. Then go to your dashboard, add content, select Reports, and add this report to display the pie chart.