Kevin J Morse.ca - Most Popular Tags in Drupal using Views

Submitted by Kevin on March 23, 2013 - 00:54

I wanted to add a sidebar block showing the most popular tags on the site but didn't want to use any extra contributed modules. It turns out it's actually quite easy to do using Views.

  1. Download and install Views if you don't have it already.
  2. Create a view to Show Taxonomy Terms and click Create a block if you want the sidebar block.
  3. Click Advanced and add a Relationship to Taxonomy term: Content using Tags
  4. In Advanced under Other set Use aggregation to yes.
  5. Add the Taxonomy term: Name field twice. Set the aggregation settings of the first to Group results together and the second to Count.
  6. You can add a Prefix and Suffix of ( and ) so that the number of times the Tag appears is in parenthesis.

Enjoy!

Tags:

Comments

nicholas (not verified)

April 7, 2013 - 03:00

thanks for giving the correct way to add sidebar.

Kevin

April 17, 2013 - 01:06

You're welcome!

Mike (not verified)

April 28, 2014 - 14:26

Thanks Kevin! The steps above worked for me, but step 5 is a little unclear. The following modification worked for me:

5. Add the "Taxonomy term: Name" field twice. Set the first to aggregate by "Group by", and the second by "Count". I also added a prefix of " (" and suffix of ")" to the second field, such that the output of a single term looks something like: hamburgers (5)

Mike (not verified)

April 28, 2014 - 14:30

Also in Show: Fields > Settings, check the two fields under "Inline fields" to get them to appear next to each other, or alternatively set up some form of Rewrite.

Kevin

May 3, 2014 - 22:22

I made this change to the instructions.