Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a list with the following sample data:

Title  |  Rank1   |    Rank2
Foo    |    2     |      4
Foo    |    4     |      6
Foo    |    6     |      8

Trying to construct a Column Chart around just "Rank1" data as an aggregated average. For example, expecting a single column to appear with the value of "4" (the average between 2, 4, and 6).

Is this possible using the Chart Web Part? Do I need to somehow configure something in the Advanced Properties? Does the Chart Web Part not do any aggregations like this? Would I have to pre-aggregate the data somehow (like putting into a separate list)?

share|improve this question
    
I don't think you can do it in the chart web part so your looking at 3rd party stuff. –  Ryan Feb 28 '12 at 20:22
add comment

5 Answers 5

The Chart Web Part doesn't do aggregation.

My company offers a solution that does charting of data aggregation and allows drill-downs. Here is a demo: http://blog.pathtosharepoint.com/2012/11/06/interactive-demo-charting-in-sharepoint/

It relies on the out of the box "Totals" available in SharePoint views.

Another option would be Excel services, but it is a multi-step process as you would have to transfer your data to Excel.

share|improve this answer
add comment

I am supporting the first answer you received here from Mr. Christo Bahchevanov, who also helped me with some issues I have (great technical support there). I have also recommended Nevron to other friends and customers, as the functionality it has can sometimes be a life saver! Especially when at the beginning you think you need something simple and then all of the sudden you realize you need better functionality!

Full Disclosure: Just a happy bubbly customer :)

share|improve this answer
add comment

You can achieve this with Nevron Chart Web Part and the built-in pivot aggregation. The Nevron Pivot Engine stays behind all data aggregation / analysis features provided by the web part. It uses formula expressions, which gives you flexible control over grouping, filtering and sorting and also provides the ability to define dynamic property values based on formulas.

For your requirement, you can use a pivot function to return the average of a set of numbers. For example, you can have category goruping by Title and two Values grouping for Rank1 and Rank2, with the following expressions:
=AVG(Fields!Rank1)
=AVG(Fields!Rank2)

For more information on the Pivot capabilities, you can refer to the Help Documentation:
Pivot Engine >> Grouping, Filtering and Sorting
Pivot Engine >> Functions

Full disclosure: I am working at Nevron Software and I have been assisting with the development of the Chart web part based on user requirements.

share|improve this answer
add comment

Brian,

Try Visifire for SharePoint webpart. This user friendly webpart will let you quickly create silverlight charts. The Visifire for SharePoint supports Group Data functionality using which you will be able to achieve your requirement as you have mentioned above. Please check out the documentation link below on how to group data.

enter image description here

http://www.visifire.com/documentation/Visifire_Documentation/VisifireForSharePoint/Working_with_GroupBy_in_SharePoint_Charts.htm

Full disclosure: I have been involved in the development of Visifire for Sharepoint webpart.

share|improve this answer
add comment

Chart Web Part does not do Aggregations, only displays tabular data. I would suggest you create a calculated column that performs the aggregation and than use the Chart Web part pointing to that new column.

One alternative is to go for Performance Point if you have Enterprise License.

share|improve this answer
    
Unfortunately a calculated column won't help for data aggregation across items. –  Christophe Mar 28 at 16:01
    
True, you would need to resort to other means. –  C. Marius - MVP Mar 28 at 18:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.