984588 - Aggregate information about Reps with no recent activities

Status: VERIFIED FIXED

(Mozilla Reps Graveyard :: reps.mozilla.org, task)

Description

[William Reynolds [:williamr]]

This bug is to aggregate information about Reps with no recent activities so program stakeholders can measure the health of the program.

These statistics could find a home at the upcoming stats dashboard (bug 970400).

A minimal viable feature would display this information about Activities:
- Number of Reps with their most recent activity reported in the last 4 weeks
- Number of Reps with their most recent activity reported between 4 to 8 weeks ago
- Number of Reps with their most recent activity reported over 8 weeks ago

Note: The time boundaries may change based on bug 984573

Comment 1

[William Reynolds [:williamr]]

Attachment: Stats - Recent activities.png

Here is a mockup showing how many Reps had their most recent activity happen during one of the three time periods.

Comment 2

[Brian King [:kinger]]

Just throwing it our there, but some sort of chart view might be nice. Some people interpret visuals better.

Comment 3

[Justin Crawford [:hoosteeno] [:jcrawford]]

I suggest the initial implementation of this use the timespans we earlier specified for this flag, since they are already implemented. They're covered in https://bugzilla.mozilla.org/show_bug.cgi?id=970395:

"As a mentor I get an email when a mentee of mine doesn't have reports with report_date between 3 weeks in the past and 3 weeks in the future from now."

Comment 4

[William Reynolds [:williamr]]

I spoke with nemo about this today. We agree it makes sense to use the same time periods as the mentors dashboard (bug 984573). We will only look at past activities and not use any future activities.

The mockup in comment 1 is still accurate. The queries are:
- Number of Reps with their last activity in the past 4 weeks
- Number of Reps with their last activity between 4 and 8 weeks in the past
- Number of Reps with their last activity more than 8 weeks in the past

Comment 5

[Justin Crawford [:hoosteeno] [:jcrawford]]

We have clear specs for the entire activity feature, including the stats dashboard: https://remo.etherpad.mozilla.org/inactive-rep-specs-v2-2014-04-03

The mockup for this is here: 
http://cl.ly/image/1g3J3B3r1z28

Comment 6

[[github robot]]

Commits pushed to master at https://github.com/mozilla/remo

https://github.com/mozilla/remo/commit/6b83265aaf8fce079290d23cf4e3b37a8b4ab4a8
[Fix bug 984588] Aggregate inactive reps in stats dashboard.

https://github.com/mozilla/remo/commit/404ba6f981b73ecb7e91fc259b3c3ca45aeb774a
Merge pull request #717 from johngian/984588-aggregate-inactive

[Fix bug 984588] Aggregate inactive reps in stats dashboard.

Comment 7

[William Reynolds [:williamr]]

This looks great! Verified on stage.

On the /stats page, I see a handy table displaying when Reps last did an activity. While I can't easily verify the accuracy of the numbers displayed in the table, they seem right. Great work here.