Creating custom grouped/stacked bar charts

[_-jasonr-_]

Hello,

Due to limitations of the reporting options, my company is in need of a custom grouped and stacked bar chart for an 'aging incidents report' grouped by Opened and stacked by Assignment_group (drilled to reporting manager). I have been researching creating the chart and the Custom Chart Scripts article. The X-axis would be the range of days 0 - 3, 4 -7, 8 - 11, 12 - 15. The Y-axis would be the incident count.

I also saw where tltoulson   talks about staying close to the OOB reporting in Create report by vendor, by priority, by month with a field on the incident table and a business rule. I understand and have written a similar GlideAggregate script, but I am not getting the results I desire.

Any guidance on this subject would be appreciated.

Thank you,

JasonR

[tltoulson]

Hi Jason,

Which part is preventing you from using the OOB reporting?   For example, below is a chart with opened by date ranges along the x axis, stacked by assignment group and counted along the y-axis using a regular out of box report.   I think I may be misunderstanding some part of your requirement, so hopefully a baseline can help.

[_-jasonr-_]

Travis,

Thanks for the baseline, and great videos on this subject.

They want to drill down in the stacked by options for assignment group. They essentially want a bar chart exactly as you show here with the exception of stacking by sys_user_group > u_is_manager (user group > assignment group > reporting IS manager). Since there are no related fields to drill down in the stacked by like the group by, and I have checked into configuring the stacked by options without success, they want a custom chart.

Through further research, I think that a pivot table to relate the incident with the manager is a possible route to take that would resolve the issue. Unless there is a better method of accomplishing the goal. This would also allow them a table to reference.

Admittedly, this is a new area of SNow skillset advancement for me to explore.

Thank you,

JasonR

[aravind23]

Is there a way to change the frequency mentioned in the report say like i just want 5-7 days and 1-2 weeks range is it possible?

[joshsmith]

I am also looking for a way to update the default groupings on this, any ideas? The intervals of Same Day, 2 days, 2-5 days, 5-7 days etc are not relevant to our needs, how do you update these values?