Graph data from multiple lists/libraries

It is possible to graph data from multiple lists, by using SharePoint look up columns. Consider the following example.

In this example, we have 2 SharePoint lists (can be more).

List 1: a list of companies

multi_lists_1

 

 

List 2: products, in this list, there is a column named “Company”, where it is a look up column to list onemulti_lists_2

 

 

The look up column configuration as follows

multi_lists_3Once configured, in list 2 we can see list 1 data, now we are ready to visualize data from both list 1 and list 2. Launch the visualizer from list 2, always launch the visualizer from the list looking up (list 2), rather than the list that’s being looked up to (list 1).

 

 

multi_lists_4

 

multi_lists_5

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s