Create a chart XY using backend functions on two linked objects

Ask the Community
1

I am working on a Workshop Application, and I would like to create an XY chart using two linked objects (A and B), which are connected via a link created in the Ontology Manager.

The X-axis should display values grouped by a string property from Object A.

The Y-axis should show the sum of an integer property from Object B, segmented by another property of Object B.

To achieve this, I have explored three approaches:

  • When I use “Traverse to – Get linked objects”, only the properties of the linked object set (B) are available in the widget configuration.
  • When I use “Combine with another object set”, only the properties of Object A are shown.
  • I tried using the TypeScript function: ThreeDimensionalAggregation to join the two objects, but the join option is not working. I also tried using the “Search Around” option, but that didn’t work either.

Does anyone have recommendations on how to properly achieve this?

Thanks a lot!