Summary admin view

[michael-james]

As a researcher, I want to be able to see how many contributions each user has made and how they've interacted with the system.

A view with a table that shows, by user:

• user (user_id)
• user (created_at)
• most recent taskHist (updated_at)
• for each of the following types, show thre following columns: Ideas, Links, Feedbacks, Total
  • submitted (taskHist:action = 1)
  • skipped (taskHist:action = 5)
  • exited (taskHist:action = 2 | 3 | 4)
  • no action (taskHist:action = null)

At the top of the total, show grand total rows between the header and first user that aggregates the information in the table. One row is a sum of everything in that column where applicable. A second row is the percentage of that pane. For example, the Ideas:Submitted column would have a percentage that is the count of all taskHist records with task=40 and action=1 divided by the count of all taskHist records with task=40.

Sort the users in descending order (most recent first) by column 3 (most recent taskHist:update_at).

[michael-james]

https://github.com/creativecolab/CommunityCrit/tree/feature-admin-view
http://communitycrit.dev/admin/summary/user