We are currently migrating an existing Report Definition to Pega Insights as part of UI kit to Constellation migration. In the Report Definition, we use a sub-report to join a secondary table and perform aggregations (for example, retrieving the latest record using MAX() and other aggregated values) before joining the results back to the primary table.
What is the recommended approach to achieve a similar design in Pega Insights?