757028 - Add daily and weekly data to contributors chart

Status: RESOLVED FIXED

(support.mozilla.org :: General, defect, P2)

Description

[Kadir Topal [:atopal]]

Please add daily and weekly data to contributors chart, similar to the "questions" chart.

Comment 1

[Ricky Rosario [:rrosario, :r1cky]]

We currently get the data for this graph with a SQL query for each of the series. I am pretty sure we will now need to pre-calculate these values into our metrics table and update daily. Making it a 3 for now but if it might need to be broken up for each series.

Comment 2

[Ricky Rosario [:rrosario, :r1cky]]

Also, what are the definitions of a contributor when showing daily and weekly data?

Comment 3

[Will Kahn-Greene [:willkg] ET needinfo? me]

Has the question in comment #2 gotten answered? If not, we should bump it from the sprint since we don't know what this is about. If it has gotten answered, that answer should get codified in a comment.

Comment 4

[Ricky Rosario [:rrosario, :r1cky]]

Kadir, can you answer comment 2? How are do I count contributors for any given day? Does it take into account the activity of the past 30 days?

For example: if I replied on the army of awesome any time in the past 30 days but not today, should I count as a contributor today?

Comment 5

[Kadir Topal [:atopal]]

For contributors we count everyone who has been active within the last 30 days.

So, the answer to your question is yes, if you have contributed to AoA yesterday, but not today, you still count as a member of the AoA community. The goal is not so much to figure out how many people were active on a given day, but how many people strong the community is at any given point in time. We assume that only after 30 days of inactivity can we no longer count on you as an active member. 

I also see value in seeing how many people were active on a certain day, but I think that's a measure for the Karma dashboard, rather than a KPI.

Comment 6

[Ricky Rosario [:rrosario, :r1cky]]

In a pull request:

https://github.com/mozilla/kitsune/pull/662

Comment 7

[Ricky Rosario [:rrosario, :r1cky]]

Landed:
https://github.com/rlr/kitsune/commit/114a1053fcf21e5b81baa3f6f75c1944340e35ec

Pushed to production by Rehan at 2012-06-19 15:52:00 EDT

New graph should be up after cron job runs overnight (3AM Pacific).

Comment 8

[Ricky Rosario [:rrosario, :r1cky]]

And don't forget to RESO FIXED your bugs!