Filter to look at incidents with SLA Time Left?

[kpw2329]

Incidents are incidents, tasks are tasks, is there a way to have both in the same filter on my homepage? I've got my team's incident queue already set as a filter, but I'd like to have a column for Business Time Left on the Task SLA.

[Michael Kaufman]

You could make a report on the table task_sla and turn that into a gauge to display on your homepage.

Report: My Incident SLAs

Table: task_sla
Columns: Task, Task.Short Description, SLA, Stage, Actual Time Left
Filter: Task.Assignment Group is javascript:getMyGroups()

Click "Make Gauge" to make a gauge for your homepage

The issues you make run into is how you have SLAs setup. If you have multiple different slas, or slas that don't trigger on certain incidents you may need to do other things like create a db view to get the gauge right.

Hope that helps,
Mike

[kpw2329]

Thanks, not quite what I want to do, but it will work. Was really wanting to have one view and limit clicking back and forth.

[antonymirza]

I agree with the solution shared by mkaufman.
Please elaborate your requirement so that we can assist you accordingly. Also, if you can add the screenshot of your report, may be that would be more helpful to understand your requirement.

[kpw2329]

Ok, I've attached my current incident gauge as well as the task_sla report I ran based on mkaufman's suggestion. The ideal situation would be to have the Resolution SLA's Business Time Left as a column in the current incident gauge. Does that make more sense?