wmf.amgine3691 wrote:

#Pleonasm.

Include contribution median, not just mean.

pgehres wrote:

This would be a great community enhancement :-)

I'm going to go ahead and mark this bug as "easy". I haven't actually dug into the code too much (at least not any time recently), but I believe this shouldn't be too difficult to knock out. Feel free to remove the "easy" keyword if you feel it doesn't apply.

I'm intrested to work on this bug.Can someone please assign this to me?

mwalker wrote:

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

Aravind: Are you (still) working on this? If not, please reset the assignee to default and the status to NEW. Thanks!

[[mw:Extension:ContributionReporting]] has not been maintained for a while and has been superseded in Wikimedia Foundation by http://frdata.wikimedia.org/

It is currently unlikely that there will be any further active development of ContributionReporting.
Closing this report as WONTFIX to reflect reality.
Please feel free to reopen this report in the future if anyone takes the responsibility for active development of ContributionReporting again.