971782 - Weekly view in support forum metrics dashboard is broken

Status: RESOLVED FIXED

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

Description

[Kadir Topal [:atopal]]

I was looking at the new product specific charts on the support forum metrics dashboard, and something that caught my eye is that in the daily view for Firefox OS and Android we can see the solution rate at 100% for some days, but switching to weekly shows the solution rate at 0% for the last 6 month. It should probably be closer to a few percent.

Firefox OS showing 0% solved threads in weekly view:
https://support.mozilla.org/en-US/questions/dashboard/metrics/en-US?product=firefox-os

Firefox for Android alternating between 0% and something in weekly views:
https://support.mozilla.org/en-US/questions/dashboard/metrics/en-US?product=mobile

Comment 1

[Ricky Rosario [:rrosario, :r1cky]]

Guessing this is a small and easy to track down js bug -> 1pt

Comment 2

[Ricky Rosario [:rrosario, :r1cky]]

Moving along during sprint planning.

Comment 3

[Ricky Rosario [:rrosario, :r1cky]]

Moving our P4s to the backlog.

Comment 4

[Kadir Topal [:atopal]]

Moving to next sprint per request.

Comment 5

[Michael Cooper [:mythmon]]

Looking closely at the data, I think this may be because there are holes in the data. I'll need to pull down a new DB dump to look more closely at it.

Comment 6

[Ricky Rosario [:rrosario, :r1cky]]

(In reply to Mike Cooper [:mythmon] from comment #5)
> Looking closely at the data, I think this may be because there are holes in
> the data. I'll need to pull down a new DB dump to look more closely at it.

That's what I was suspecting too. I think this broke when I switched from tastypie to django rest framework. So we either need to make the js lib handle that or we need to zero fill the data in python or js.

Comment 7

[Ricky Rosario [:rrosario, :r1cky]]

This missed the sprint. Moving to next.

Comment 8

[Ricky Rosario [:rrosario, :r1cky]]

Moving to next sprint during planning.

Comment 9

[Ricky Rosario [:rrosario, :r1cky]]

Q1 is over. Bring it on, Q2!

Comment 10

[Ricky Rosario [:rrosario, :r1cky]]

Pushing this to next sprint.

Comment 11

[Ricky Rosario [:rrosario, :r1cky]]

Moving to the next sprint.

Comment 12

[Ricky Rosario [:rrosario, :r1cky]]

upping to a P3

Comment 13

[Ricky Rosario [:rrosario, :r1cky]]

pushing to next sprint again.

Comment 14

[Ricky Rosario [:rrosario, :r1cky]]

I'll look!

Comment 15

[Ricky Rosario [:rrosario, :r1cky]]

In a pull request:
https://github.com/mozilla/kitsune/pull/2003

Comment 16

[Ricky Rosario [:rrosario, :r1cky]]

Landed on master:
https://github.com/mozilla/kitsune/commit/a1aac167219a9dd38e28e8eeb322fcfd2271ea7c

Comment 17

[Ricky Rosario [:rrosario, :r1cky]]

Deployed to prod now.