Create a report with average time and exclude some state

[KiruthigaK]

Need to create a report:

Description - Average time between an incident has been assigned to multiple groups till resolved excluding statuses awaiting user info, pending vendor. Only incidents resolved this month should be considered. 

[Dr Atul G- LNG]

Hi @KiruthigaK 

1st you need to create metrics to capture different assignments and use a script to calculate that time. 

[KiruthigaK]

Hi @Dr Atul G- LNG 

Could you please assist me like how to exclude the states provided.

Thanks,

Kiruthiga

[KiruthigaK]

Hi,

Thank you for your inputs.

Could you please assist me how to exclude the states mentioned in the requirement.

Regards,

Kiruthiga

[Dr Atul G- LNG]

Hi @KiruthigaK 

You can check the OOTB metrics first, but excluding the states requires scripting, which I have no idea about.