How to create a report with stacked bars over a timeline

RR16
Tera Expert

How do I create a report with stacked bars over a timeline?  Attached is the bar chart from Excel, where the data from a Servicenow pivot table is entered in manually, each week, on the Excel spreadsheet.

I can create the stacked bars, but over the timeline has me stumbling.

Note that the bar label name is blanked out, but for each set of 6 bars corresponds to a resource, indicated in the example as n1-n6.  

So for each time period, a week, there are 6 bars.  One bar for each resource.  The stacks for each bar, are the ticket types of the tickets closed by that resource.

 

5 REPLIES 5

AnubhavRitolia
Mega Sage
Mega Sage

Hi @RR16 

 

'Report Range' would be best feature of ServiceNow which may be helpful for you to achieve what you are looking for. 

 

Please check below links to see how it works:

https://performinganalytics.com/report-ranges-the-good-the-bad-and-how-to-fix-the-bad/#:~:text=Repor....

 

https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportR...

 

 

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023