Multiple bars grouped by year

by annlee » Tue Dec 08, 2015 5:31 pm

Hi,

Is there a way to configure the bar chart showed in http://demos.telerik.com/kendo-ui/chart-api/events, where there are 3 bars per Year on the x axis?
Attachments
Events API for Kendo UI HTML5 charting components - Kendo UI Demos 2015-12-08 09-31-05.png
Events API for Kendo UI HTML5 charting components - Kendo UI Demos 2015-12-08 09-31-05.png (18.83 KiB) Viewed 535 times
annlee
 
Posts: 35
Joined: Thu Oct 08, 2015 3:25 pm

by Rostislav » Wed Dec 09, 2015 9:02 am

Hello,

First of all, you will of course need to select all appropriate fields in the data source. Then go to Dashboard -> Advanced and add the following code inside the preRender function:
Code: Select all
  //this is example for one series
  var series2 = $.extend({}, config.series[0]);
  //replace "ValueFieldInternalName" with the internal name of the field that will be used as the value field
  series2.field = "ValueFieldInternalName";
  config.series[1] = series2;

  //this is an example for the next series
  var series3 = $.extend({}, config.series[0]);
  series3.field = "ValueFieldInternalName";
  config.series[2] = series3;
User avatar
Rostislav
 
Posts: 61
Joined: Fri Oct 09, 2015 10:51 am

by annlee » Mon Dec 14, 2015 5:28 pm

Hi,

Is it possible to add the series by list name?

For example, I have 3 lists with different names, with same field names: Area, Count, Year.

Can I show the 3 columns as Listname1, Listname2, Listname3 with Year on X axis and Count on the Y Axis?

Thanks.
annlee
 
Posts: 35
Joined: Thu Oct 08, 2015 3:25 pm

by Dmitry Kozlov » Tue Dec 15, 2015 9:41 am

Sure, you can aggregate data from multiple lists programmatically. Here is a sample:
https://plumsail.com/blog/2015/08/using-multiple-lists-in-dashboard-designer/
User avatar
Dmitry Kozlov
 
Posts: 129
Joined: Wed Nov 12, 2014 3:24 pm


Return to Dashboard Designer for SharePoint 2013