Closed Bug 718698 Opened 13 years ago Closed 13 years ago

[SUMO KPI dashboard] display helpfulness of KB articles (“yes”/total votes)

Categories

(support.mozilla.org :: Knowledge Base Software, task, P1)

Product:
support.mozilla.org
Component:
Knowledge Base Software
Type:
task

Tracking

(Not tracked)

Status:
VERIFIED FIXED
Milestone:
2012-01-31

People

(Reporter: atopal, Assigned: rrosario)

Details

(Whiteboard: u=sumo-team c=kpidash s=2012.2 p=2)

No description provided.
Blocks: 718663, 717342
Whiteboard: u=sumo-team c=kpidash s=2012.2 p= → u=sumo-team c=kpidash s=2012.2 p=2
Whiteboard: u=sumo-team c=kpidash s=2012.2 p=2 → u=sumo-team c=kpidash s=2012.2 p=4
No longer blocks: 717342, 718663
Depends on: 718663
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
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.
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
No longer depends on: 718663
Priority: -- → P1
https://github.com/mozilla/kitsune/commit/116851b0d7c24101a75344425b3ee3e495225e6c
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Target Milestone: --- → 2012-01-31
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.