Group Quarterly Revenue by Year

by wparks77 » Wed Jun 21, 2017 6:22 pm

Good afternoon,

I have a bar chart which displays quarterly revenue by year. I would like to group the years closer together for a better view of the trend data. Any ideas?

As you can see the attached, the order is displayed correctly, but its not easy to see the trending, especially as more time passes.

Many thanks!
Attachments
Quarterly Bars.PNG
Quarterly Bars.PNG (63.99 KiB) Viewed 124 times
wparks77
 
Posts: 13
Joined: Sat Dec 03, 2016 7:54 pm

by Dmitry Kozlov » Thu Jun 22, 2017 9:12 am

Hi,
You can adjust spacing between bars with the 'gap' property. Insert the code below into Dashboard -> Advanced page:

Code: Select all
var handlers = {};
handlers.preRender = function(config, logger) {
  config.seriesDefaults.gap = 0.1;
  return true;
}
User avatar
Dmitry Kozlov
 
Posts: 129
Joined: Wed Nov 12, 2014 3:24 pm

by wparks77 » Thu Jun 22, 2017 3:19 pm

Thanks Dmitri!

This was really helpful. Can I ask if there is there a way to set specific gaps between the yearly Series values?

for example:

| Q1 16 | | Q1 17 | |Q2 16| |Q2 17| | Q3 16 | | Q3 17 | etc.?
wparks77
 
Posts: 13
Joined: Sat Dec 03, 2016 7:54 pm

by wparks77 » Thu Jun 22, 2017 3:21 pm

Well the spacing I typed did not transfer to the question. Basically, I need to space the Series values to group the years further apart then the quarters.

| Q1 16 | | Q1 17 | ----- |Q2 16| |Q2 17| ----- | Q3 16 | | Q3 17 |
wparks77
 
Posts: 13
Joined: Sat Dec 03, 2016 7:54 pm

by Dmitry Kozlov » Fri Jun 23, 2017 10:49 am

Yes, I got you but unfortunately there is no way to set various spaces between bars of the same series. In your case, the only option is splitting data into multiple series.
User avatar
Dmitry Kozlov
 
Posts: 129
Joined: Wed Nov 12, 2014 3:24 pm


Return to Dashboard Designer for SharePoint 2013