Feature Request: Workshop Grouping By Property

Ask the Community
1

Hi everyone,

looking for a way to easily group workshop tables by property.
Please see attached Simple Power BI example (notional data):

Grouping Example
Grouping Example1675Ă—780 84.4 KB

Thanks!

2

I played around and couldn’t find a nice way to do this; I know the Workshop team keeps an eye on feature request here, so it should make it into a backlog, but in the meantime, you could look at building a custom OSDK React widget to get exactly the functionality you need.

1 Like
3

You should be able to do this with the Pivot Table widget! Coming soon is function backed pivot tables for full flexibility to aggregate data however you wish from a custom function, but for something simple like the the pivot table widget should work out of the box.

But +1 to creating a custom OSDK React widget whenever you hit the limits of what Workshop supports!

4

Hey @evanj - I tried playing with the pivot table and, while I agree you can create the “grouped” rows, I don’t see any way to expand those groups and show the individual object rows for each as the OP has in their Power BI screenshot. Something I’m missing?

5

I think in this case you should be able to group on projectManager with an expandable grouping on projectName - the pivot table widget docs for expandable rows have a screenshot that roughly speaking looks like the original ask.