Applies to: Nevron Chart for SharePoint (WSS3.0, SharePoint 2007/2010/2013)
How to count specific non-numeric records from dataset fields in the Chart Web Part?
You can count specific non-numeric records from your dataset fields with the help of Nevron Chart Web Part Pivot Aggregation.
Let’s say that we have the sample SharePoint list below. We will produce a clustered bar chart, showing a comparison for the different Projects (A, B and C), which have impact ("Yes" or "No") for each company.
On the chart X-axis, we would like to have category grouping for the "Company" field. To show a count of records which have impact, we would like to count only the records with value "Yes" for the different Projects and display them in a clustered bar chart.
1. Connect to the SharePoint list through the Chart Designer - Data Source tab.
2. From the Pivot tab, Data Groupings >> Categories – we have dropped the Company from the DataSet Fields (=Fields!Company):
3. In the Data Groupings Values tab, we have created values for the 3 projects (A, B and C), and for the Value filed we have used the following expressions:
=SUM(LIKE(Fields!A, "Yes"))
=SUM(LIKE(Fields!B, "Yes"))
=SUM(LIKE(Fields!C, "Yes"))
That way we will display the sum only for the records with "Yes" value.
Article ID: 177, Created On: 2/18/2011, Modified: 1/29/2013