I have a content type that contains a taxonomy term reference field. each user can create unlimited nodes of this content type and select different term at each time. now we want make a view of count of this terms selected by users as a table like this:

enter image description here

is there any plugin to support create these type of tables in views? or we should do it programmatically? I appreciate any help.

2 Answers 2


In the Advanced > Other section of the view, you should be able to enable aggregation.

  • thanks for your answer but aggregation doesn't work in this instance.
    – jshosseini
    Commented May 8, 2015 at 6:06

To my knowledge there is no solution to create such kind of view using the Views module. But the Forena module (disclosure: I'm a co-maintainer) can be used for this type of reporting. More specifically by using its facility to create a Display of a table in crosstab format.

A crosstab table is a table with a special layout. It is formatted as a grid, with:

  • the rows representing one or more (combinations of) facts, such as countries or regions, names of persons (or users) like employees / salespeople (or user IDs / user names), etc.
  • the columns representing one or more other facts, such as periods (months of a year, years, etc), available types/flavors of something (like types of errors), etc.
  • the intersections of rows and columns containing the actual information (data), such as summarized information (counts of something), timestamps, etc. and which might (optionally) include a hyperlink to a drill-down report.

Below is a sample of such crosstab report (including drilldown links also, i.e. the numbers in red in it):

enter image description here

Refer to my comment in the Forena issue queue for more details about the above screenshot. And/or have a look at the video about How to generate crosstab reports with graphs (Forena also supports charting of those data, a typical related requirement ...).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.