Bug 161159

Summary: Add GROUPBY, PIVOTBY, PERCENTOF functions to Calc
Product: LibreOffice Reporter: Óvári <ovari123>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: miguelangelrv, stephane.guillou
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
URL: https://ask.libreoffice.org/t/how-to-aggregate-rows-using-group-by/33951
Whiteboard: Interoperability
Crash report or crash signature: Regression By:
Bug Depends on: 138749    
Bug Blocks: 150900    

Description Óvári 2024-05-18 10:14:18 UTC 
Description:
GroupBy function
https://support.microsoft.com/en-us/office/groupby-function-5e08ae8c-6800-4b72-b623-c41773611505

The GROUPBY function allows you to group, aggregate, sort, and filter data based on the fields you specify.

https://bettersolutions.com/excel/functions/groupby-function.htm

---

PivotBy function
https://support.microsoft.com/en-us/office/pivotby-function-de86516a-90ad-4ced-8522-3a25fac389cf

The PIVOTBY function allows you to create a summary of your data via a formula. It supports grouping along two axis and aggregating the associated values. For instance, if you had a table of sales data, you might generate a summary of sales by state and year.

https://bettersolutions.com/excel/functions/pivotby-function.htm

---

PercentOf function
https://support.microsoft.com/en-us/office/percentof-function-7c66da0a-ac30-45d0-bfc7-834a8bd7c962

Use the PERCENTOF function to return the percentage that a subset makes up of a given data set. It commonly used in GROUPBY and PIVOTBY functions.

Note: PERCENTOF is logically equivalent to =SUM(data_subset)/SUM(data_all)

---

Excel - First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel - Episode 2633
Published on Nov 15, 2023
https://www.youtube.com/watch?v=6jP7DflN4sw

Functions benefit from Lambda and Eta-Lambda functions
https://bugs.documentfoundation.org/show_bug.cgi?id=138749

Steps to Reproduce:
-

Actual Results:
-

Expected Results:
-


Reproducible: Always


User Profile Reset: No

Additional Info:
Excel - First Look at Amazing GroupBy PivotBy PercentOf Functions in Excel - Episode 2633
Published on Nov 15, 2023
https://www.youtube.com/watch?v=6jP7DflN4sw

Functions benefit from Lambda and Eta-Lambda functions
https://bugs.documentfoundation.org/show_bug.cgi?id=138749
Comment 1 m_a_riosv 2024-05-18 22:05:52 UTC 
+1
Comment 2 Óvári 2024-05-18 22:07:39 UTC 
(In reply to m_a_riosv from comment #1)
> +1
Can you please update the Status from UNCONFIRMED to NEW? Thank you
Comment 3 m_a_riosv 2024-05-19 02:55:02 UTC 
I can, but would be fine having more opinions.
Comment 4 Stéphane Guillou (stragu) 2024-06-03 07:02:10 UTC 
I support adding those, for similar data transformation tasks to what R's dplyr package's functions can do (themselves inspired by SQL operations). This would make it easier to work with "tidy data"[1].

[1]: https://www.jstatsoft.org/article/view/v059i10/