Workshop: Pivot Table: Dynamic Column Grouping

Propose an Improvement
1

Hello everyone!

  • I am developing a pivot table in workshop
  • User can choose between 4 granularity: year, year_month, year_quarter, snapshot_date
  • 4 pivot tables to maintain because the column grouping is static
    • the year pivot table
    • the year_month pivot table
    • the year_quarter pivot table
    • the snapshot_date pivot table
  • I need to create a serie of 4 of these tables with different aggregations
  • I end up creating and maintaining 16 pivot tables

My suggestion:

  • the string variable “pivot_table_granularity” has “year” or “year_month” or “year_quarter” or “snapshot_date”
  • only one pivot table is created and maintained
  • this pivot table accepts “pivot_table_granularity” as its column grouping configuration
  • I only need to create one pivot table by aggregation serie.
  • Less widgets to maintain!
1 Like
2

Hi @jf_baudron, thanks for the feature suggestion! We are planning to add support for function-backed groupings and aggregations to the Pivot Table in the late 2024 / early 2025 timeline, so there should be an easier way to accomplish this setup in the near future.

Appreciate the post!