Add option to configure Column Grouupings in Workshop pivot tables

Quick feedback / feature request.

We have a lot of Workshop pivot tables, where we need to group by either by Year, Month, Week, Day.

Currently this means copying over the same pivot table config and manually changing the Column Grouping Time Interval field.

Is this imaginable to give end users the ability to to configure column groupings and choose their Time interval ?

This is possible by configuring expandable or hidden columns in the Pivot Table widget. The below screenshots show an example where a user can set the visible column to year or month or expand from year to month, week, and day. One wild caveat is that these columns can’t be renamed in a pivot table.


Thanks for the solution, this is definitely interesting.

Not exactly our use-case though, let me share some more details : we have a pivot table with row groupings like product category, warehouse logistics center etc…

And our columns are month / week or day.

We currently have one pivot table with Month columns, one with Week columns, and one with Day columns.

The idea here would be to be able to configure the time interval of the column grouping dynamically in the UI