How create a interactive filter on task_sla table for resolved field which is coming from incident

mania
Tera Contributor

Hi,

 

We need to create a interactive filter on "task_sla" table for resolved field which is coming from incident.
We have created two reports on "average response time" and "average resolution time"(These two reports created from task_sla table). now based on resloved field of incident interactive filter these two reports should show the result. 
Currenly we are getting the issue on to get the resolved field of incident from task_sla table.

Can anyone please help on this, it will be useful.

 

Thanks!

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @mania ,

 

Why not utilizing incident_sla instead of task_slsa?

 

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/

mania
Tera Contributor

@AndersBGS 
Thanks for your Responded!

We have build lot of reports on task_sla so we need to build interactive filter on resolved field from incident table.
Can you please help on this, It will be useful.

Thanks!