Skip to main content
12-Amethyst
February 17, 2026
Question

Query Builder: Variance -Avarage resolution days group by Context

  • February 17, 2026
  • 1 reply
  • 33 views

I've tried to modify a report for the Variance below

 

GianpaoloGallo_0-1771334595982.png

 

 

Where I need to group my report by Context and calculate the average Resolution Days.
However, adding the โ€œContextโ€ column does not group the results.
Any idea how to fix this?
Thanks
Gianpaolo

 

1 reply

16-Pearl
February 18, 2026

Hi @GianpaoloGallo,

Is the Average Resolution Days calculated using an SQL query or a Java class?

If so, have you reviewed the logic to confirm how it is being computed?

Specifically, is the average resolution calculated on a month wise basis?