We would like to be able to aggregate data and group results based on nested properties in Appfarm. This would allow us to expose deeper insights to some of our users.
Example:
We have three object classes with one-to-one relations like this: A ↔ B ↔ C.
We would like to aggregate A.property grouped by A.B.C.property, or alternatively aggregate C.B.A.property grouped by C.property. None of these alternatives seems to be supported by the “Aggregate Data” action node today.
Loading all the data to the client and performing calculations client-side is not desirable, as the data sources are large and growing.
Denormalizing the data is not desirable due to:
-
Permissions. Most users can read and update A; very few can do the same with C. Denormalizing data from C to A would expose data in A that should not be widely available. Denormalizing data from A to C would also require us to give all users at least update access to C, which could be tricky when they cannot read C.
-
Data inconsistency. A is updated throughout our solution. Ensuring every developer always remembers to update C everywhere they update A, or vice versa, could quickly lead to data inconsistency.
