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

VERIFIED FIXED in 2012-01-31

Status

P1
normal
VERIFIED FIXED
7 years ago
7 years ago

People

(Reporter: atopal, Assigned: rrosario)

Tracking

unspecified
2012-01-31

Firefox Tracking Flags

(Not tracked)

Details

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

Comment hidden (empty)
(Assignee)

Updated

7 years ago
Blocks: 718663, 717342
Whiteboard: u=sumo-team c=kpidash s=2012.2 p= → u=sumo-team c=kpidash s=2012.2 p=2
(Assignee)

Updated

7 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

7 years ago
No longer blocks: 717342, 718663
Depends on: 718663
(Assignee)

Comment 1

7 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
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

7 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
(Assignee)

Updated

7 years ago
No longer depends on: 718663
(Reporter)

Updated

7 years ago
Priority: -- → P1
(Assignee)

Comment 4

7 years ago
https://github.com/mozilla/kitsune/commit/116851b0d7c24101a75344425b3ee3e495225e6c
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
(Assignee)

Updated

7 years ago
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.