Report to display sctask/inc date assigned to group

McGuire6799
Tera Contributor

I have a user looking for a report to display work assigned and resolved by their assignment groups, but wants to see when it was assigned to their group, not when it was opened or created. They work in 2 week sprints that run Wednesday - Tuesday so the data will be displayed by day for them to count. Performance analytics is an option, but I don't feel it is needed.

There are at times delays on getting the work assigned to their assignment group, this is why they are only concerned about work assigned during that 2 week window. In-scope items are SCTASK and INC records, and can be displayed on one chart or two, does not matter, but need displayed as separate data points.

 

I am unable to location a table that would work for this, but potentially leaning towards the history table, filtering off of the "new value" and "update time" with the label "assignment group" but unsure if there is a better avenue for this?

 

Edit to add: Thinking I would filter unique value based on the "set" variable to avoid duplicates.

3 REPLIES 3

AshishKM
Kilo Patron
Kilo Patron

Hi @McGuire6799 , 

You can check the table ( metric_instance ) for this data. there is OOTB metric defination for Incident records, you can create the same metric defination ( metric_definition ) for SCTASK records.

 

AshishKM_0-1721684781375.png

 

System will create a new record in metric_instance table, every time there is assignment group change. 

 

-Thanks,
AshishKM


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

AndersBGS
Tera Patron
Tera Patron

Hi @McGuire6799 ,

 

You should either look at a scripted metric definition for assignment = the specific assignment group or you can create a SLA to set the specific conditions. 

 

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

 

Best regards

Anders

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Alp Utku
Mega Sage

First of all, It's not good practise to report on history table. It's also not required. 

 

Apart from metrics definition, you could create custom fields on SCTASK and Incident tables. One field could be date and time field and the other one could be checkbox. Then you can write after business rule to populate that custom date and time field when checkbox is checked. This could be an alternative solution to your requirement.