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.
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
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
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
we've also fixed a typo in the field name - https://github.com/mozilla/zamboni/commit/10178737eef0dd78b3f58a20ca8bca94d0ea342e
data is showing now