I would like my view to display just one field and additionally group by this field. So, I set the following:
- checked "Use Aggregation" in Advanced settings
- added the field to FIELDS section
- in FORMAT section set the Format->Settings to group by this field
- in FIELDS section, in Field->Aggregation chose "Group fields together"
As a result, I get the following output, assuming the field contains color values:
Blue
Blue
Blue
Red
Red
Red
Red
Green
Green
How to prevent displaying rows and only display group headers together with the COUNT of rows? Like this:
Blue (2)
Red (3)
Green (1)