Posted by leeksoup on Fri, Feb 17, 2023 - 12:23pm

Is there a way to sort a list of taxonomy terms in a View by the number of nodes tagged with that term? So that the maximum frequency tags are shown first?

Thanks!

Accepted answer

Thanks for the suggestion. I am not able to do step 2 in your list:

2. Add node group in relationship

"Node group" is not in the list of available Relationships on my site. I was able to add a Relationship to "Taxonomy term: Content with term" and then the nid field appeared as an option under Fields.

I could do the other steps but the result is actually not properly sorted. 

Oh, but when I then add a sort criterion of "nid" and set the aggregation on that to "count" as well, then it works.

Cool, thanks!

So what worked for me, based on your post:

  1. Create a taxonomy view
  2. Add "Taxonomy term: Content with term" in relationship
  3. Add term name and node nid fields for display
  4. Enable aggregation in "Other" section (Use aggregation: Yes)
  5. Click nid field settings icon, choose group type "count".
  6. Add a sort criterion of "nid" and set aggregation (group) on it to "count", then choose ascending or descending.

Comments

Mon, Mar 06, 2023 - 5:02pm by onyx

Thanks, just happened to need this.

The following works for me:
 

  1. Create a taxonomy view
  2. Add node group in relationship
  3. Add term name and node nid fields for display
  4. Enable aggregation in "Other" section (Use aggregation: Yes)
  5. Click nid field settings icon, choose group type "count".

I also created another view to link to the unique Nodes that have that taxonomy chosen.

Wed, Mar 08, 2023 - 8:41pm by leeksoup

Thanks for the suggestion. I am not able to do step 2 in your list:

2. Add node group in relationship

"Node group" is not in the list of available Relationships on my site. I was able to add a Relationship to "Taxonomy term: Content with term" and then the nid field appeared as an option under Fields.

I could do the other steps but the result is actually not properly sorted. 

Oh, but when I then add a sort criterion of "nid" and set the aggregation on that to "count" as well, then it works.

Cool, thanks!

So what worked for me, based on your post:

  1. Create a taxonomy view
  2. Add "Taxonomy term: Content with term" in relationship
  3. Add term name and node nid fields for display
  4. Enable aggregation in "Other" section (Use aggregation: Yes)
  5. Click nid field settings icon, choose group type "count".
  6. Add a sort criterion of "nid" and set aggregation (group) on it to "count", then choose ascending or descending.