My team and I are trying to include reports in our database that compare data from many connected objects, but are struggling with making this work.
For example, we have objects containing financial data separated by year (e.g. object 1 = 2017, object 2 = 2018, object 3 = 2019) that each contain records relating to the same journals (say there are 300 journals, each object contains a record for each of these).
The records are connected and this works well when building views displaying tables of info from each object, but not when building reports. Ideally, we would like line graphs taking the relevant data point for each journal from each year so that it is possible to see revenue or cost or some other metric over time.
This would be a super useful feature and I look forward to hearing any news on it’s development!