Report on previous "Assigned To"

[Yogita11_]

Hello all,
We need to build a "trend" type report based on previous "Assigned to" of incidents and requests.

For example, if Abel was the first assignee of an incident and it was later changed to John, the report will display the data as it is now configured. However, there is no option to present data based on the previous assignee. We need to generate a trend report that includes data from past assignees.

For example -The record count to show which records are currently allocated to John and which were assigned to him in the past.

Does anyone have any suggestion?

[AndersBGS]

Hi @Yogita11_ ,

You have an OOTB metric definition called assignee:

Open "assigned to duration"

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders

[Yogita11_]

Hello @AndersBGS 

Thanks for reply

We can create a report utilizing metric definitions.However, creating an interactive filter for an assigned to is not possible because if we select the assigned as it is, it will filter the records based on current assignments, but to filter on previous assignments, we need to add a filter on value, which is a string field; I have searched extensively and have not found a solution.

[Yogita11_]

Hello all,

I attempted to use metric definitions that showed incident data. However, that is also slightly incorrect for my need if for xyz incident the assigned to is "A" and letter, it changes to "B" and then back to "A". Now, according to the criterion, I need a count of 1 for A, but according to the metric definition, I get 2. The second issue is that I need to construct a trend type report on the request and incident tables, and I'm not sure how to combine them since for the incident, I'm using the "Incident_metric" table, and I can't add the other metric definition that I established for the request.