Summary: | PIVOTTABLE: Median and other functions in pivot table data fields | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | krajcsi <krajcsi> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | david.filiatrault |
Priority: | medium | ||
Version: | unspecified | ||
Hardware: | Other | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 103381 |
Description
krajcsi
2013-03-02 17:38:32 UTC
marked as enhancement request Also want to see PERCENTILE and PERCENTRANK options 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. 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. |