Create Metrics report on finance REQ table

[Akshaykhare]

I wanted to create a report on finance REQ table in a following way

Metric Report defining the time taken by different assignment groups on all the FREQs.

For example - Over a FREQ1234, total 3 groups worked as and it was resolved in 4 days :

Group A : 1 Day 2 hour

Group B : 2 Days 1 Hour

Group C : 21 Hours

So, we need the report over FREQ table which will show the exact time taken by each assignment group to process the FREQ

[Kieran Anson]

Does your FREQ have an SLA already applied? If so, an SLA breakdown might be an option

Service Level Agreement (SLA) breakdown definitions 

[Akshaykhare]

@Kieran Anson : Yes SLA's are already applied to FREQ. Can you please elaborate on how to use SLA breakdown for creation of report .

[Kieran Anson]

Once you've created a breakdown definition, information will be populated in sla_breakdown_by_assignment. That will provide you duration information as you've requested in your opening question

[Akshaykhare]

@Kieran Anson : I tried implementing SLA breakdown but it is showing the data for the records which are created after its implementation. Is there any way to show the data for past records as well.