Generating Reports from Incident Metric

[Mandadi]

I need to generate a Report from Incident Metrics table based on following conditions.

Assignment Group: 'Required Group'

All the incidents which has/had the above group name in it's assignment group field(either on creation of incident or on reassigning) should be listed with complete history.

Example: if an INC is reassigned to 'Required Group', resulted report list should contain what was it's first assignment group as well. 

Any help on this is appreciated.

Thanks.

[Uncle Rob]

Not going to be able to do this conventionally.
Essentially you're sweeping through the list to grab all Metric Instances where value = "Required Group"... but the subtext si you want to sweep through the list again and find all Metric Instances for any group that has also been assigned any incidents from the first pass.  But then you want to only take the first chronological one from that list.

There's no report that can generate that for you because it requires at least 2 passes through the data.

[Venkata Naga Su]

I would suggest to query the incident metric table and store that in a Custom table and then report on custom table rather than direct reporting , it may not be possible 

[Uncle Rob]

It's also worth asking "WHY" this needs to exist.

What issue is so bad that you need days of custom development to ask the question "what is the first group to ever be assigned any ticket that has ever been assigned to "required group"".