Aggregate of webform submissions not working

Hi aduhour.

The aggregation functionality of Views works by adding SQL aggregation functions to the database query, such as COUNT, GROUP BY and SUM. Unfortunately, because of the architecture of Webform (e.g. submitted webform component data are not stored in separate tables, but rather in one table, webform_submitted_data). This makes Views queries for Webform submissions very different from the types of queries that Views uses for "normal" Backdrop fields and entities. A lot of it, for example the separation of component data into different columns in the resulting View, is done post-query and pre-rendering. 

The authors of Webform managed to make available ways to include, sort and filter submissions, but I think they stopped short of making aggregation available, since SQL aggregation (with this architecture) is either impossible or very difficult.

I'd suggest you look into Views Aggregator Plus, which aggregates fields post-query. I've never tried it with webform, but it may allow you do bypass some of these limitations.

Andrés, I was able to show the label rather than the numerical ID of the option.

I assume you are using a "Select options"  component and that you want to group by option selected.

Let's say I want to create a Webform with one component (Select option - "Favorite cartoon"), with two choices: Bug Bunny, and Tom & Jerry. I want to count how many people choose BB and how many T&J.

When creating the component, be sure to select "Customize keys" and enter the exact same text in the key as in the label. See image.

Then I created a View (please note that I'm using a regular "Page" since I haven't installed Charts, but the aggregation works the same way there).

Fields:

• Webform Submissions: Serial Number
• Webform Submission Data: Value (raw)

Relationships:

• Webform Submission: Data
  • Settings: 
    • Component Data: Favorite cartoon (the name of the component)
    • Relate using: Component Form Key

Filters:

• Just to be sure, I filtered by the NID of the Content that holds the Webform. Not sure if it's needed

Then I enabled aggregation. I chose COUNT for the first field, and Group results together for the second.

Result:

Then you can use Value (raw) as the source for your labels in the Chart. Let me know if that worked! 

(I have to clarify that even though the Column Header reads "Serial Number" in the image above, the numbers shown are actually COUNTS: I have 3 submissions with "Bugs Bunny" and only 1 with Tom & Jerry. Though I must confess I like T&J much better!!!)

EDIT: In the relationship, you can use any of the other options for "Relate using". It doesn't make a difference as long as the keys of your component are the same text as the label.