Bar chart report setup difficulties

[Christina Boe]

Hello everyone,

The following topic is currently causing me real difficulties, my customer wants a bar chart report setup as soon as possible (could also be a performance analytics widget). The bars should be made up of 100% closed incidents per month with a distribution based on the average processing time.

As a background explanation: Initially, all closed incidents should be considered and sorted according to their processing time (small to large). A cut is to be made at 80% of the records with the smallest processing time of the total number, with 80% ending up in one pot and the remaining 20% in another. Now the average processing time of all those closed incidents that are in the 80% pot need to be calculated, while doing the exact same for the 20% pot. Both average processing times should now form the basis for the bars per month to show how many incidents belong to the 80% block with their associated processing time and how many belong to the 20% block. For example, for October it would be clear that the 80% bar of all closed incidents had an average processing time of 5 days, while the 20% bar of all closed incidents would represent 28 days.

My difficulty now lies in the implementation of these specifications. So far, I have tried to create an auxiliary column via Function Fields, but I have already failed to add up all closed incidents, which would be my first step to "filter down" on the total number based on the Pareto target of 80% to 20% sections.

Based on these requirements, does anyone have any ideas on how I could set up this report?

I look forward to your answers/ideas on how to approach this topic.

Best wishes!