How to create a statistics dashboard of my users using Views?

Question

I'm working on a Drupal website based on its users. They can login, pay their debts, set and update their personal and contact information, etc.

I would like to create a Dashboard showing statistics of these users, based on my user's fields, something like:

• GENDER: Male 54% - 46% Female

• ACTIVE USERS: 67%

• AGES: 20% KIDS - 56% Young - 16% Old - 8% Other

I even have a design for it, I´m just trying to figure it out technically using the Views module. Any idea?

Answer 1

Use the Charts module and its integration with the Views module. A straight forward cloning of the delivered views example would do what you are asking for. Have a look at this online example to get a first impression.

Some more examples of the Charts integration with Views, using data contained in "nodes" (so not using any Views aggregation facilities):

• Single chart, not attached to a table, and without aggregation.
• Table with attached charts, and without aggregation.
• Combination chart without aggregation.

Disclosure: I'm a (co-)maintainer of Charts.

Answer 2

You can also do just normal (the Views) blocks, maybe a charts view using any of the charting modules mentioned in the Comparison of charting modules. And place the block(s) on the default drupal dashboard.

Answer 3

Assuming you wish to create an Admin dashboard with no coding:

You will need more than one view. You either have multiple views or a single view with attachments. If it is multiple views you will have to find a way of embedding them on one page, probably using Panels.

Your view(s) will use aggregation as you are accumulating stats by grouping.

Modules that might assist:

Page Manager (part of CTools)

Contextual Administration which is a nice module to assist in creating admin path dashboards:

Contextual Administration is an administration tool based on CTools Page Manager module. It allows for the deployment of custom administrative pages through a typical database driven mechanism or can take advantage of the typical page_manager exports through custom modules + exports or features module.

Tutorial for using Contextual Administration:

https://www.youtube.com/watch?v=Luc-bGGxa6c&list=PLEFD8FDE69D61DCA3