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

Ola30
Tera Contributor

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

3 REPLIES 3

AndersBGS
Tera Patron
Tera Patron

Hi @Ola30 ,

 

If you utilize the task_sla table with below condition:

AndersBGS_0-1712555504652.png

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 

 

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/

Ola30
Tera Contributor

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?