Joyce

Yes, I need the number of days, then create a chart with 3 series, from 0-7 days, from 8-14 days, and from 14-21 days, on counter of Active request, within teams. What query have you use to get the number of days? Thanks. Regards, Joyce

Hi, How can I calculate request age (how many days, the ticket has been open for) to date on the sql query in widget? Thanks. Regards, Joyce

Thanks Victor and Steve. This is very helpful.

Yes please go ahead

Hi Victor, I am a bit confused by your answer. I want a chart which can show me, the distribution of active Incidents, by 'Priority_Name' within 'Team_name'? Is there a way to get this chart as a widget? or any other way? Thanks. Regards, Joyce

I am trying to create a chart widget for active Incidents grouped by priority, and Team. Basically I am looking for something like this: (please see attached Print screens). Currently I can get widget either by priority or by team. How can I combine them in one widget? I am interested on the count (so how many active P1 assigned to a team). Thanks. Regards, HornBill SM_Chart Widget grouped by Priority and team.docx

I am trying to create a chart widget for active Incidents grouped by priority, and Team. Basically I am looking for something like this: (please see attached Print screens). Currently I can get widget either by priority or by team. How can I combine them in one widget? I am interested on the count (so how many active P1 assigned to a team). Thanks. Regards, HornBill SM_Chart Widget grouped by Priority and team.docx