Multiple calculations for different interfaces in one report - handling times
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.