I'm trying to use the new webform integration with charts to show a pie chart of submitted webform data for a single field, but I'm unable to get the aggregation to work. It works fine on other fields eg content type, but for webform submitted data, views always seems to see the entries as different so each displays as having 1 entry. Any ideas? I've attached a screenshot of my view.

CommentFileSizeAuthor
webform_submission_data.png206.94 KBchris_h

Comments

mrosenbaum’s picture

mrosenbaum commented

I have also run into the same issue. Were you able to find any solutions? I can aggregate the non web form data without issue, but I can't even get the web form data to aggregate on a number field.

I'm running Views 7.x-3.7 and Webform 7x-4.0-beta1.

Any thoughts you have would be very helpful.

quicksketch’s picture

quicksketch
he/him
commented
Issue summary: View changes

When aggregating on submission data, you first need to add a relationship for the component you want to aggregate on. Then instead of using "Webform submission data: value" you should use "Webform submission data: value (raw)". This will JOIN over to the data table and use that when counting the number of values. The normal submission data handler (used in your screenshot), doesn't actually JOIN to other tables, it loads the entire submission and pulls out the values from each one.

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Closed (fixed)

Closing after lack of activity.