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.
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¶mstartDateParameter=2013-01-10¶mendDateParameter=2013-01-24¶mproductParameter=Firefox¶mchannelParameter=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
Hi Maria, thanks. What are the numbers? Average over time, sum, something else?
sum of total requests
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.
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¶mstartDateParameter=2013-01-10¶mendDateParameter=2013-01-24¶mproductParameter=Firefox¶mchannelParameter=aurora&outputType=csv
That times out for me, rather consistently :-( , getting connection-reset errors after pondering for a few minutes.
(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.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.