Displaying aggregation of properties in Pivot Table from not directly linked objects

Ask the Community
1

Hi everyone,

I’m trying to create a pivot table in Workshop which displays properties from not directly linked objects. e.g. The link is built in this way A→B→C. Starting with object A, I can only choose properties in A, or add properties in B as derived variables. Is there any way for me to add properties C in the pivot table?

2

I dont think you can, sadly.
However, there is a way that may work. I have done it for some internal reports, and it will not look as good as a workshop native widget:

Use a Quiver Transform Table in a Quiver dashboard and then use said dashboard embedded in the workshop. Again, not pretty, but you will be able to traverse several links within the transform table if I remember correctly

1 Like
3

Thanks Pedro. I tried the Quiver solution and as you said, it gets the job done but not pretty :joy: Indeed, it allows me to traverse multiple objects, beyond only the direcly linked objects. I’m hoping to make use of the “expandable“ features in Workshop pivot tables but it is sadly missing from Quiver.