Report with data from two tables (or even three)

[Bumsefar]

Hello All,

I want to create a report (list view type) with data from atleast two tables.

I want the "business time left" column from task sla table, i tried building a report based on task sla table and dotwalked to the task table, and added columns from both "task sla" "task" and "incident" table. 

The issue is that i now can't see all the tickets that has NO sla, and i need to see ALL tickets - SLA or not.

Is this even possible ? 

I am not an admin so what i can do myself is limited in terms of specific steps. 

If i build the report based on TASK table, then i don't know how to add the "business time left" column

Please help 🙂

[AndersBGS]

Hi @Bumsefar ,

There is already a solution OOTB called incident_sla 

Make a copy of above, and create a new with "left join" set to true on incident to see all incidents no matter if there is SLA attached or not. 

If you "just" use the OOTB, then you will only see incidents with SLA attached. 

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

best regards

Anders