Applies to: Nevron Chart for SharePoint (WSS3.0, SharePoint 2007/2010/2013)

How to create Chart From Multiple SharePoint Lists?

By using Nevron Chart for SharePoint, you can create charts from multiple SharePoint lists.
The standard connection to SharePoint list in the Chart Designer only allows a connection to a single list. However, you can use the Connection to a SharePoint Site Query instead.

SharePoint provides a powerful method to query for data in its sites, that is based on CAML (Collaborative Application Markup Language). The result of a CAML query is a relational table, which is the perfect target for pivotal data analysis.

A SharePoint Site Query can be suitable in many scenarios, including:
  • Concatenating data from a dynamic set of SharePoint lists (automatically concatenate data from multiple lists, that have common columns, template, or fall within a certain web scope).
  • Concatenating data from a fixed set of SharePoint lists (automatically concatenate data from a manually enumerated set of lists).
The following Help Documentation topic provides detailed information: Connecting to a SharePoint Site Query

For example, if we have two SharePoint lists – "List 1" and "List 2":
List 1:

List 2:

From the Chart Designer Data Source tab, you can select the SharePoint Site Query data source type:

Then for the List and View CAML we are specifying the lists and the columns we want to concatenate:

List CAML:
<List ID="7DA07D72-108C-4373-A7B3-58AC9EA5D079"></List>
<List ID="A45FB0A6-18DE-4027-ACDC-FFA33DE3913E"></List>

View Fields CAML:
<FieldRef Name="Product" Type="Text"></FieldRef><FieldRef Name="Country" Type="Text"></FieldRef><FieldRef Name="Value1" Type="Number"></FieldRef><FieldRef Name="Value2" Type="Number"></FieldRef><FieldRef Name="Date"></FieldRef>

Once you concatenate the data from multiple lists, you can build your chart:

The following error may occur when the number of lists is over 1,000:

This is actually a SPSiteDataQuery problem. The limitation is on the number of lists in the query which may well exceed the limit.
For more details, take a look at:

Article ID: 236, Created On: 4/5/2013, Modified: 4/10/2013