https://bugzilla.wikimedia.org/show_bug.cgi?id=42521

Matt Walker <mwal...@wikimedia.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mwal...@wikimedia.org

--- Comment #5 from Matt Walker <mwal...@wikimedia.org> ---
Anjana; ContributionReporting as such doesn't exist any more. However; we have
scripts which generate the same data and then present it on
frdata.wikimedia.org.

You will find the script that creates this data in the
wikimedia/fundraising/tools.git repository in gerrit; the script itself is
called FundraiserStatisticsGen/fundstatgen.py [1]

You will need to change or write new SQL in the getPerYearData() and
getPerCampaignData() functions to calculate a median. The difficultly of this
problem lies in the following caveats: MySQL does not provide a median
function, the column in question (con.total_amount) is not indexed -- though it
could be if required, and we have > 5M rows in this database.

[1]
https://git.wikimedia.org/blob/wikimedia%2Ffundraising%2Ftools/7411ecf8745bfd93ffd25b4c97a82772d8634fbd/FundraiserStatisticsGen%2Ffundstatgen.py#L72-85

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to