Assigned Date field

[CV1]

Hello All,

I want to create a report to display when a task,case,incident or requested item was assigned .

Assignment Group = displays group name the task is assigned to

Assigned to = displays the name of the individual the task is been assigned

Assigned Date = ?

I want to report on no of tasks(cases,Incidents,Requesteditems) assigned to an individual of a group on a given date or current date.

Please advise.

Thanks in advance! 

[NikEng1]

Hi!

One of the best options for this if you ask me is the "SLA Breakdown" application. As long as the tasks you want to report on have SLA:s it'll work.

What it does is to create a row each time a task with an SLA is assigned to a person or a group, or any combination of them. So each time either of those fields change, a row is created containing a start and end time for the assignment, a calculation of how much of the SLA elapsed during that assignment and whether or not the SLA was breached during it.

Then you can simply report on the table "sla_breakdown_by_assignment" and use filter to find rows for a specific user, group or specific combination of user and group. You can also filter on dates.

Here I've made a report for which cases were assigned to Beth at midnight on the 13th of march:

You can also set up metric definitions with the type "Field Value Duration" on assigned to and assignment group. It's similar to SLA breakdowns but works for any task, even those without SLAs:

[Andrew_TND]

Hello,

Creating a metric will achieve this however it only records from the point you activate it however this would give you all the information you need above.

Please mark as helpful and if its resolved the issue correct!