Whiteboard: u=sumo-team c=kpidash s=2012.2 p=2 → u=sumo-team c=kpidash s=2012.2 p=4
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
Status: NEW → RESOLVED
Last Resolved: 7 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.