What are the best practices for building metrics between several properties of different object types (please provide real example).
If there was a property I wanted to compare on “Object Type A” to a property on “Object Type B” how would I perform this action? assuming it is a many:many with a bridge table (or several bridge tables for different categorical properties.
What is the size and scope of your metrics aggregation? Can you give an example of the kind of comparison are you looking to make?
If the compared properties are the same type across multiple objects, Shared Properties could be good start, as this will make a lot of things easier down the line.
That said, more information could be useful to guide you in the right direction.
For an easy example, lets say I have the following tables (object types).
Many to Many, If this wasn’t an object set and I was working in SQL, Power BI, etc. I would pull the unique values from the “Team” and create a dimension table to gain the metric of “Max Members - MemberCount”.
I am unsure how to do this within an Object Type. Understanding that it can be completed by an action-backed property, how would I be able to materialize it at that point?
| Team | MemberCount | City |
|---|---|---|
| Red | 5 | New York |
| Green | 4 | San Antonio |
| Red | 6 | Miami |
| Blue | 3 | Miami |
| Red | 6 | San Antonio |
| Green | 5 | miami |
|Team| MaxMembers|
|— | — | — | —|
|Blue | 20 | | |
|Red | 15 | | |
|Green | 20 | | |
|Green | 15 | | |
|Red | 18 | | |
|Red | 20 | | |
Are you doing this in Workshop? If so, you can do an ObjectSet aggregation → unique count and then add them together in a variable transform. Would that work?