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
+1
(In reply to m_a_riosv from comment #1) > +1 Can you please update the Status from UNCONFIRMED to NEW? Thank you
I can, but would be fine having more opinions.
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/
Fine… maybe? But so far I see nothing in that youtube, which cannot be done with ⇒Data⇒Pivottable⇒create… and some intuitive drag&drop … so what? ( !! as a little reminder: there is still the problem of outputting arrays in dynamic size from formulas !!)
(In reply to Werner Tietz from comment #5) > ( !! as a little reminder: there is still the problem of outputting arrays > in dynamic size from formulas !!) Added bug 127808. Thank you
(In reply to Óvári from comment #0) > 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 https://driftbossgame.co/ > > 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 I got it