Last Comment Bug 843046 - New Users Chart
: New Users Chart
Product: Marketplace
Classification: Server Software
Component: Statistics (show other bugs)
: 1.0
: x86 Mac OS X
-- normal (vote)
: 2013-04-18
Assigned To: Tarek Ziadé (:tarek)
Depends on:
Blocks: 838912
  Show dependency treegraph
Reported: 2013-02-20 07:12 PST by Tarek Ziadé (:tarek)
Modified: 2013-04-12 10:45 PDT (History)
3 users (show)
See Also:
QA Whiteboard:
Iteration: ---
Points: ---


Description User image Tarek Ziadé (:tarek) 2013-02-20 07:12:15 PST
URL: /statistics/mmo_user_count_new/
Comment 1 User image Hanno Schlichting [:hannosch] 2013-04-11 07:24:24 PDT
This doesn't show any data in staging.

In addition there's lots of duplicate rows for key='new-user' with the same user_hash and value columns. The recorded date column is different, sometimes with just minutes and often with differences of hours or days.

We need to figure out what happens here.
Comment 2 User image Tarek Ziadé (:tarek) 2013-04-12 06:14:33 PDT
there's a bigger problem with the zamboni plugin - it's not doing one aggregate per day per dimension - instead it's returning every recorded line. Fixing this
Comment 3 User image Tarek Ziadé (:tarek) 2013-04-12 06:33:35 PDT
The real solution:

=> change the zamboni API so we publish records aggregated by day (grouped by user hash) with sums.

The thing we're doing for now:

=> changing the monolith plugin so it groups and sums on its side. 

It's more network activity, so we'll need to consider moving that aggregation work on the server side
Comment 4 User image Tarek Ziadé (:tarek) 2013-04-12 07:27:20 PDT
I have released monolith.aggregator with the current fixes:

1. "--date yesterday" now works as expected
2. the zamboni plugin is now sending back the expected data

we'll update monolith stage, dump the data and see how things look from there
Comment 5 User image Tarek Ziadé (:tarek) 2013-04-12 10:32:58 PDT
we've also fixed a typo in the field name  -

data is showing now

Note You need to log in before you can comment on or make changes to this bug.