Build Report ( Of Any Type) using following conditions

Question

Hello, I want to create a report using column chart that shows the following conditions(I am done with the first 2 conditions), I'm stuck on the last 2 conditions, could someone help out?

Requests that are closed by agent
Requests that are open by agent

Average time agents are taking to complete their tickets

Average time each department is taking to complete their tickets.

stefanhelzle0001 · Answer

I typically try to record some additional data for reporting during thee process flow. For example, when I know that I will need the duration/effort for various groups, I calculate these values and store it for each process/case/ticket. Then aggregation becomes trivial.

Trying to somehow analyze it from the raw data typically becomes complicated and puts a big load on the system.

Sign up

Login with SSO

Login to the community

Login with SSO