Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Change Graph Type for Dashboard Report

kshaw
Giga Guru

I have a dashboard with a report on it. It shows INC closed by my departments different assignment groups by the month. Unfortunately, the graph (trend) is showing as a stacked bar graph.

I would like to find out how to make each of the assignment groups a vertical line beside each other for each month so that they can be better distinguished apart from each other.

How do I do that.

Dashboard.png

 

report config.png

1 ACCEPTED SOLUTION

Hi @kshaw ,

 

As far as I can see from your pictures, it's because you have chosen a trend report:

AndersSkovbjer_0-1673498643764.png

If you instead scroll to time series and chose column :

AndersSkovbjer_3-1673499133080.png

 

Then you will see the option:

 

AndersSkovbjer_2-1673499078381.png

 

If my answer has helped towards a resolution, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

3 REPLIES 3

AndersBGS
Tera Patron
Tera Patron

Hi @kshaw

 

When you are making a bar chart graph through ServiceNow reporting tool, you have the option to either make it stacked or grouped bars as shown below:

AndersSkovbjer_0-1672899314541.png

To chose between stacked or grouped bars is available, as soon as you choose a stacked by column value. 

 

If my answer has helped towards a resolution, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

kshaw
Giga Guru

I can not find any place that allows the selection of Stacked Bars vs Grouped Bars as you image shows.

Here are the screenshots of the report editing...

 

Type.png      â€ƒâ€ƒConfigure.png

Hi @kshaw ,

 

As far as I can see from your pictures, it's because you have chosen a trend report:

AndersSkovbjer_0-1673498643764.png

If you instead scroll to time series and chose column :

AndersSkovbjer_3-1673499133080.png

 

Then you will see the option:

 

AndersSkovbjer_2-1673499078381.png

 

If my answer has helped towards a resolution, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/