Cognite FDM 1 (on behalf of Celanese)

Hi @Jay Vansickle thanks for your inputs. 

While it is not possible to aggregate across edges or by filtering on edge properties, it is possible to aggregate and filter on direct relations. This may be a feasible option for your use cases - add a direct relation property in the reporting unit's type to the reporting site type, and group on or aggregate on that property. Diving into the details here would require having a proper look at your data model definition.

Direct relations are a form of lightweight edge - they cannot have types or properties, but are inexpensive to store and scan and hence computationally feasible to consider during aggregation operations.

Thanks and regards

Elka