Create a chart XY using backend functions on two linked objects

[utilisateur3]

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!

[utilisateur7]

Hello utilisateur 3, I am facing exactly the same problem and I was wondering if you could tell me if you manages to do it ? And if yes, could you be able to explain me please ? Thank you in advance.

[utilisateur3]

Hello,
Yes, I was able to handle it using a back-end function. I first created a mapping to associate each ID with its corresponding column in the linked object. Then, I performed the aggregation and populated a result bucket. The implementation is similar to the following code:

Hope this helps!