I'm trying to setup aggregation so that rows that have the same term are displayed as a SUM in a single slice of a pie chart.

Aggregation type on the field used for labels: Groups results together
Aggregation type on the field used for data (decimal): SUM

Screen capture of pie chart

CommentFileSizeAuthor
#2 aggregation-type-SUM-with-integers.png61.6 KBbisonbleu
pie-chart-aggregation-not-working.png129.7 KBbisonbleu
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

bisonbleu created an issue. See original summary.

bisonbleu’s picture

bisonbleu CreditAttribution: bisonbleu commented
Title: Can't get aggregation SUM to work in a pie chart » Aggregation type SUM does not support decimals (floats)
Priority: Normal » Major
Issue summary: View changes
Related issues: +#2735997: Decimal separator and decimals settings ignored when aggregating decimal fields
FileSize
aggregation-type-SUM-with-integers.png61.6 KB

Updated the title and pushing Priority to Major just to get the attention of a maintainer.

I was able to aggregate SUM on IDs (integers).

Views preview of aggregation SUM on IDs

But it appears that an aggregation of type SUM on decimals isn't supported by Views (#2735997: Decimal separator and decimals settings ignored when aggregating decimal fields). If that's true then it is possible that this issue has nothing to do with Charts - and therefore should be set to Works as designed. But I'll let someone more competent do this as I'm not 100% sure.

I found an alternative: views_aggregator + highcharttable