How to create SLA PA indicators for SLA achievement per HR Service?

[Ola30]

Hi,

I need to create SLA PA indicators for SLA achievement per HR Service. SLA data is stored in task_sla table and hr services are stored in sn_hr_core_service table.

Is there any way to do that differently than creation of database view?

I tired to create a breakdown relations for that but i failed. I would be grateful for any tips.

Best regards,

Ola

[Community Alums]

Hi @Ola30 ,

Please follow these :

https://www.servicenow.com/community/platform-analytics-forum/automated-indicators-for-sla-definitio...

https://docs.servicenow.com/bundle/washingtondc-employee-service-management/page/product/human-resou...

[AndersBGS]

Hi @Ola30 ,

If you utilize the task_sla table with below condition:

Afterwards, you can create a breakdown for the HR Service.

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

Best regards

Anders 

[Ola30]

hi @AndersBGS 

Thank you for looking into my case. 

Could you please advise where I should like for HR case field on task_sla table?