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

17-Peridot
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?