How to set group by in drupal 7 views?????????

Comments

spovlot’s picture

Do you want a grouping field such as :

Type 1
    Row 1
    Row 2
Type 2
    Row 3
    Row 4

If so, use the Format Settings to select a Grouping Field.

If you want to use COUNT() or SUM() aggregation, change "Use Aggregation" under the Advanced settings.

Khetam’s picture

do the following:

  1. Edit your view
  2. Click on setting (format setting)
  3. Choose the field that you want to group the view
  4. Save your view

or check this link:
http://drupal.stackexchange.com/questions/4770/how-do-i-group-elements-i...

Khetam
Drupal Developer, Yaab

khuram’s picture

I am actually trying to do something same but I have a View in Drupal 7 of type Content, instead of fields. Views can be of types Content and fields; for fields type of View, these options are surely available but for View of type Content this option isn't available for me at least. I am trying to figure out how to add Grouping in this case, when this option isn't there as I am using View of type Content instead of fields. Just to clarify, when I modify my View to be of type fields then that option becomes visible, and as soon as I modify the node to be of type Content(like showing whole nodes) that option goes away. Trying to figure out a way to do Grouping in this case, any sort of help would be greatly appreciated.

Thanks, Khuram!

spovlot’s picture

You can group by a field but still show the Content node or teaser. To do this, use the Fields setting. Add a the field that you will be grouping on and exclude it from display. Then add Content: Rendered Node as a field. You can set this field's setting to Display = "Show complete entity" and View mode = "Full Content" or teaser. Then set the grouping field to the first field you added.

fhdrupal’s picture

How can I group contents by titles with the similar topics like Google news. any idea?