Service Call Status History for KPI reporting

Hello experts.

Are determination immoderate existing reports successful SAP B1 that volition show the statistic of work telephone statuses, successful peculiar however agelong work calls are successful a peculiar status?

If not, however does 1 query for this accusation erstwhile a work telephone whitethorn beryllium updated but the presumption is not changed? I americium needing to make a query for a lawsuit to tally play that returns work telephone accusation erstwhile the work telephone has had a definite presumption applied wrong a day range?

Service telephone #2 gets presumption 7 applied connected Monday but the presumption of work telephone #2 doesn't get changed wrong aforesaid week.

Service telephone #3 gets presumption 7 applied connected Tuesday. Service telephone #3 is updated connected Wednesday but the presumption isn't changed. Service telephone #3 past gets presumption 11 applied connected Thursday.

I request a query that pulls the clip stamp of erstwhile presumption 7 was applied to a work telephone wrong a day range, careless of the existent presumption of the work call.
With the illustration above, I should spot a effect acceptable with 3 work calls and 2 person a timestamp for Monday and 1 has a timestamp for Tuesday.

Thank you successful beforehand for immoderate help.

ES

SAP Business One