You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Multiple calculations for different interfaces in one report - handling times

Accepted answer
edited Mar 17, 2016 9:50AM in Reporting & Analytics for B2C Service 3 comments


Hi there,

I am hoping someone may be able to help me with a report.

I have a report which shows me all open incidents by 'brand' - we have separate interfaces for each of the brands that we have. My report lists the interface name, so brand "A", "B", "C", and so on, which is taken from incidents.interface_id.

I have another column which is count(incidents.ref_no)*5. This basically means for each open incident, it will take 5 minutes to complete, on average, as an etimate. However, this applies the same estimated time of 5 minutes to ALL brands, and I want to be able to change this on the report to show different estimates based on brand.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!