How to create a report with stacked bars over a timeline

[RR16]

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.

[Yousaf]

Hi RR,

Please check if this can help.

Create a stacked column visualization for a time series widget

Mark Correct or helpful if it helps.

[RR16]

Thanks for the link--it looks exactly like what I am trying to accomplish.  There are quite a few parameters to configure--could you point me to any tutorials that would help, or examples.  It seems so basic but I'm tripping over breakdown, 2nd breakdown, followed breakdown, and similarly element, 2nd element and follow element.  What should my indicator look like?

[Mohith Devatte]

Hello @RR16 ,

if you want a bar chart using PA you need to use time series type of widget and visualisation should be column graph

Break down comes in to picture when you want to divide your bars or columns based on some field on your facts table on which you indicator is built on

Ex:your facts table is incident and you need to show how many incidents are P1,P2.P3.P4,P5

So you can configure your break down on priority field on incident form and then add your break down in the pa WIDGET  which will divide your bar graphs into 5 bars each representing different priorities of the incident tablep.

Hope this helps 

Mark the answer correct if this helps you 

Thanks

[David Shipley]

The requester is asking for an example.  It would be great if you filled in the form to match your scenario of Incidents by Priority.  Posting a blank Widget form doesn't really help ... I'm confident the requester has gotten that far.