Bug 61700 - PIVOTTABLE: Median and other functions in pivot table data fields
Summary: PIVOTTABLE: Median and other functions in pivot table data fields
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2013-03-02 17:38 UTC by krajcsi
Modified: 2016-11-27 11:59 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description krajcsi 2013-03-02 17:38:32 UTC
In pivot table several functions are available for the data fields. Still, the list of available functions are limited.

Median function could be a useful addition. More generally, custom functions would be useful for many users.
Comment 1 A (Andy) 2013-04-09 20:43:27 UTC
marked as enhancement request
Comment 2 David Filiatrault 2014-08-25 00:08:36 UTC
Also want to see PERCENTILE and PERCENTRANK options
Comment 3 Tamás Zolnai 2016-11-20 11:56:07 UTC
Median is added to pivot table functions:
https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=99dbbecb1c0838494b095e8338dc7e6b00ab2cb6..92c1128fb80b4e38df219ce60f018cfb1522b20a

It will be available in LibreOffice 5.3.
Comment 4 Phil 2016-11-27 11:49:28 UTC
Thanks very much for at last implementing functions for pivot table.

Now, regarding implementation of percentile (and in particular median, quartiles), see algorithm:

http://stackoverflow.com/questions/2374640/how-do-i-calculate-percentiles-with-python-numpy

Do notice the comment about the bug in the algorithm and its fix.

Must be function for pivot being:
sum
count
counta(non empty cell count)
and normal descriptive stat: min, max, average, variance, percentile.


I also seize the opportunity to also mention that in the User Interface it's disturbing to have one side the menu "Insert>Pivot table" in order to create it and "Data\Pivot table" on the other to delete or refresh it; all belong to context of pivot table and UI must reflect this.