Need help for pie chart performance analytics

[Humble123]

I have a requirement for creating a pie chart report on incident table. There should be two slices in the pie chart only. One is assigned and other is unassigned. The assigned slice will display the count and percentage of tickets that have an assignment group. The unassigned slice will display the count and percentage of tickets that does not have any assignment group(empty assignment group field). I have tried several things include indicators, breakdowns, but unable to do it. Any help will be appreciated.

[Dr Atul G- LNG]

Hi @Humble123 

I  doubt we can do this , @AndersBGS what you say.

[AndersBGS]

Hi @Humble123 ,

Agree with @Dr Atul G- LNG , not sure it's possible either only from a reporting perspective. You can off course set a checkmark on the incident form itself and populate by business rule. If assigned to is not empty checkmark the field. Afterwards you can run a report based on the checkmark. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Tai Vu · Accepted solution]

Hi @Humble123 

Within Performance Analytics, you can achieve your requirement by leveraging the Bucket Group for your Breakdown Source. Sample like

1. Define a bucket group with 2 values Assigned [1] and Unassigned [0].

2. Create breakdown source with the above bucket group.

3. Define breakdown and breakdown mapping.

4. In breakdown mapping, create a script to return true/false (true if assigned, otherwise return false). Sample below

It's important to note that in PA, data is gathered based on a specific job collection.

This means that the Pie chart won't display the exact number (percentage) of the current data; rather, it reflects the data at the time the collection job was completed.

Cheers,

Tai Vu