Closed
Bug 718698
Opened 12 years ago
Closed 12 years ago
[SUMO KPI dashboard] display helpfulness of KB articles (“yes”/total votes)
Categories
(support.mozilla.org :: Knowledge Base Software, task, P1)
support.mozilla.org
Knowledge Base Software
Tracking
(Not tracked)
VERIFIED
FIXED
2012-01-31
People
(Reporter: atopal, Assigned: rrosario)
Details
(Whiteboard: u=sumo-team c=kpidash s=2012.2 p=2)
No description provided.
Assignee | ||
Updated•12 years ago
|
Assignee | ||
Updated•12 years ago
|
Whiteboard: u=sumo-team c=kpidash s=2012.2 p=2 → u=sumo-team c=kpidash s=2012.2 p=4
Assignee | ||
Updated•12 years ago
|
Assignee | ||
Comment 1•12 years ago
|
||
I added dependency on bug 718663 assuming that the query would be too expensive to do every time. Maybe it is worth a try to do this with just a query without denormalizing the data to the new table.
Summary: [SUMO KPI dashboard] display helpfulness of KB articles and Forum (“yes”/total votes for both) → [SUMO KPI dashboard] display helpfulness of KB articles (“yes”/total votes)
Whiteboard: u=sumo-team c=kpidash s=2012.2 p=4 → u=sumo-team c=kpidash s=2012.2 p=2
Comment 2•12 years ago
|
||
There's already a cron set up that pulls helpfulness data into redis for the aggregate "most unhelpful articles" list on the contributors dashboard. We could probably modify that if we do need to denormalize the data.
Assignee | ||
Comment 3•12 years ago
|
||
I looked at the HelpfulVote model and I am thinking this really might be a simple query where you group by created_date and is_helpful. We don't have to break it down by revision/document/locale/etc. I am going to try it out and see how it goes.
Assignee: nobody → rrosario
Reporter | ||
Updated•12 years ago
|
Priority: -- → P1
Assignee | ||
Comment 4•12 years ago
|
||
https://github.com/mozilla/kitsune/commit/116851b0d7c24101a75344425b3ee3e495225e6c
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Assignee | ||
Updated•12 years ago
|
Target Milestone: --- → 2012-01-31
Comment 5•12 years ago
|
||
Verified helpfulness graph displays on kpi dashboard
Status: RESOLVED → VERIFIED
You need to log in
before you can comment on or make changes to this bug.
Description
•