2

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)?

Improve this question
1
  • I don't think you can do it in the chart web part so your looking at 3rd party stuff.
    – Ryan
    Feb 28, 2012 at 20:22

6 Answers 6

Reset to default
2

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.

Improve this answer
2
  • 1
    Unfortunately a calculated column won't help for data aggregation across items.
    – Christophe
    Mar 28, 2014 at 16:01
  • True, you would need to resort to other means.
    – Marius Constantinescu
    Mar 28, 2014 at 18:39
1

Plumsail Dashboard Designer supports aggregation and grouping as well. Also, it works in Office 365 and SharePoint on-premises. Not free but good value for price - flexibility, modern view, animation, interactivity, and no coding.

Improve this answer
0

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.

Improve this answer
0

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.

Improve this answer
0

Look into SQL Report Builder. It works well with SP2010 lists, and be displayed on a SharePoint site rather easily.

Improve this answer
0

Another 3rd party chart web part for those who are researching this is Collabion. similar to Nevron, it enables grouping of data

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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