833873 - Custom report about users on localized versions per channel

Status: RESOLVED FIXED

(Mozilla Metrics :: Frontend Reports, defect)

Description

[Axel Hecht [:Pike]]

Chris had a similar request back in bug 696140.

Here's what I'd like to get out of our ADI data:

For all, or possibly a given list of locales:

How many users have been on the aurora, the beta, and the release update channel over the past N days.

N being something like two weeks is fine. Averages don't really work, we're in particular interested in small locales, where the noise in ADIs is around 100%.

JSON output would work for me, or CSV, not sure which is more tricky for you.

Comment 1

[mroldan]

Hi Axel,
Here you have a link for your data:

https://metrics.mozilla.com/pentaho/content/cda/doQuery?solution=metrics2&path=%2Fblocklist%2FdailyADU_filteredBy_countryLocale&file=aduByCountryLocale.cda&dataAccessId=LocalesByChannelADUQuery&paramstartDateParameter=2013-01-10&paramendDateParameter=2013-01-24&paramproductParameter=Firefox&paramchannelParameter=aurora&outputType=csv

In this sample link I put these values:
startDate=2013-01-10
endDate=2013-01-24
product=Firefox
channel=aurora

You can change any of them.
Also, this link exports to csv. You can change the output format to json, xml, xls, or html

Please let me know if you're ok with this, or if you need some adjustment,
thanks

Comment 2

[Axel Hecht [:Pike]]

Hi Maria, thanks.

What are the numbers? Average over time, sum, something else?

Comment 3

[mroldan]

sum of total requests

Comment 4

[Axel Hecht [:Pike]]

Could we get the actual data per day instead? I can extract that right now by doing per-day queries, but I guess that's adding unnesseary load.

I'm afraid that the sum is scewing results differently for large and small locales.

Comment 5

[mroldan]

Axel,
The first query in here:

https://bugzilla.mozilla.org/show_bug.cgi?id=696140#c3

gives you the detail day by day (unless I'm missing something...)

This is the link with the same parameters as above:

https://metrics.mozilla.com/pentaho/content/cda/doQuery?path=%2Fmetrics2%2Fblocklist%2FdailyADU_filteredBy_countryLocale%2FaduByCountryLocale.cda&dataAccessId=allTimeLocalesADUQuery&paramstartDateParameter=2013-01-10&paramendDateParameter=2013-01-24&paramproductParameter=Firefox&paramchannelParameter=aurora&outputType=csv

Comment 6

[Axel Hecht [:Pike]]

That times out for me, rather consistently :-( , getting connection-reset errors after pondering for a few minutes.

Comment 7

[Paula Clemente [:paula]]

(In reply to Axel Hecht [:Pike] from comment #6)
> That times out for me, rather consistently :-( , getting connection-reset
> errors after pondering for a few minutes.


Sorry for leave this bug open for so long.
Can you check if it's working now?

Thanks.