Applies to: Nevron Chart for SharePoint (WSS3.0, SharePoint 2007/2010/2013)
How to show a Chart in SharePoint displaying the count of records in the current pivot scope?
Let’s say you want to produce a bar chart where the X axis contains the category, and the Y axis contains a count for the number of Item occurrences in a SharePoint list. You can easily achieve this with Nevron Chart for SharePoint and the Pivot Engine capabilities. For this example we will use the following sample SharePoint list:
Note: This is a screenshot of the list, it contains a total of 30 items.
The following steps will assist you to produce the required chart:
1. Bind to the list through the Chart Designer Data Source tab.
2. From the Designer Chart tab, select Bar chart type:
3. From the Designer Pivot tab, select the Data Groupings > Categories tab. Drag and drop the Category (Item), this will create the X axis by category grouping (=Fields!Item).
4. From the Designer Pivot tab, select the Data Groupings > Values tab. Type the following expression in the General > Data > Value filed: =Fields![RowCount]
For more details, take a look at the
Nevron SharePoint Vision Online Documentation:
Pivot Engine > Expressions
Pivot Engine > Variables
Article ID: 165, Created On: 12/30/2010, Modified: 1/29/2013