748244 - ADU breakdown by language

Status: RESOLVED FIXED

(SeaMonkey :: Project Organization, defect)

Description

[Karsten Düsterloh]

We have ADU numbers broken down by version on Kairo's dev pages, but for certain planning reasons ;-) it's important to get a breakdown of our ADUs by language.
A statistical representative snapshot ;-) with plain
  language = sum of active users
(for all languages) would suffice, I don't care about OS, version, etc.

You can throw whole data blobs at me for excavation if that's easier for you. ;-)

Comment 1

[Robert Kaiser]

Callek, if you don't remember a reasonable pentaho query for this, I think I have some post in some update-related bug where I posted queries including language splits.

Comment 2

[Justin Wood (:Callek)]

(In reply to Robert Kaiser (:[e-mail]) from comment #1)
> Callek, if you don't remember a reasonable pentaho query for this, I think I
> have some post in some update-related bug where I posted queries including
> language splits.

If you find this bug/comment/whatever it would help me, the queries I know are all manual and hard to deal with.

Comment 3

[Robert Kaiser]

Callek, bug 657272 has some queries. It's helpful to post those whenever you make a query successfully so someone else later is able to track this back and has something helpful. ;-)

Comment 4

[Justin Wood (:Callek)]

Attachment: ADU by locale code...

This is just a raw copy/paste from pentaho as an html file... forgive lack of CSS I didn't feel like translating that over (couldn't find a handy save/export for my manual query)

Comment 5

[Justin Wood (:Callek)]

Attachment: ADU By locale code...

so apparantly "Start Excel" actually creates a downloadable .xls file that is *really* just an HTML format. So this works better.