858297 - Add Average Rating to app detail statistics

Status: VERIFIED FIXED

(Marketplace Graveyard :: Statistics, enhancement, P2)

Description

[Wil Clouser [:clouserw]]

Please add a simple 1-line graph to the app-specific statistics pages (eg. https://marketplace.firefox.com/app/twitter/statistics/?last=30)  called "Average Rating".

The only selector on this graph is date, like the current graphs.

This follows the regular permissions of being developer only unless they opt-in to public.

Comment 1

[Rob Hudson [:robhudson]]

Added ability to do these queries to the Monolith API:
https://github.com/mozilla/zamboni/commit/c1ab915

Comment 2

[Rob Hudson [:robhudson]]

Added to stats api:
https://github.com/mozilla/zamboni/commit/b5d824f5

See docs on usage:
http://firefox-marketplace-api.readthedocs.org/en/latest/topics/stats.html#average-ratings

Comment 3

[Iulian Timis]

Please add STR here or mark it with [qa-] if no QA is needed.

Comment 4

[Rob Hudson [:robhudson]]

Same as https://bugzilla.mozilla.org/show_bug.cgi?id=858299#c4 but for average ratings.

Comment 5

[Victor Carciu]

I can't see this graph on -dev : http://screencast.com/t/FpbxWKM0Oy

Please correct me if I am doing something wrong.

Comment 6

[Wil Clouser [:clouserw]]

The API is done but not the front-end.  Bug should stay open (or Rob can file a separate one for front end if he wants to close this)

Comment 7

[Rob Hudson [:robhudson]]

Added per-app average rating charts:
https://github.com/mozilla/marketplace-stats/commit/5d783042

Comment 8

[krupa raj[:krupa]]

Review count @ https://marketplace-dev.allizom.org/api/v1/stats/app/twitter/totals/ (44 reviews) doesn't match the count in the apps details page where the app has 271 reviews

However, supposedly stats weren't run forever and just 2014. So, i will mark this as verified.

{"installs":{"min":1.0,"sum_of_squares":1954653.0,"max":257.0,"std_deviation":69.199010050778824,"variance":4788.5029920077895,"total":11901.0,"mean":37.901273885350321},"ratings":{"min":1.0,"sum_of_squares":94.0,"max":4.0,"std_deviation":0.90872919602854041,"variance":0.82578875171467747,"total":44.0,"mean":1.6296296296296295},"abuse_reports":{"min":1.0,"sum_of_squares":18.0,"max":2.0,"std_deviation":0.24944382578492946,"variance":0.062222222222222241,"total":16.0,"mean":1.0666666666666667}}