Using a chart to get data from three related entities.

Hello Mendix Community,    I have three entities product, orderLine and Order and I want to create a sales report about the products. These data will retrieved from three tables. How can I use the chart to get data from these tables.   Thanks
1 answers

If the data is comming from different entities, it needs some logic to combine it. This logic can live within your associations or in some custom process logic (microflow).

The easiest way to have three different entities combined in one chart is by creating objects of a non-persistable charthelper entity in a microflow. On these helper objects, you can combine the data as you need it.