I am building a chart widget using an object with a many-to-one link and I would like to segment my chart using the foreign key used for this link. But it’s not really readable because I am using the id (uuid type) of the linked object as a foreign key.
It would be nice to add the possibility to select a property to display through the linked object instead of the property used as a foreign key. (e.g. the name)
It will be really useful for:
“Group by” feature in pie chart widget
“Segment by” feature in xy chart widget
I’m quite sure that it’s not possible for now, let me know if I am wrong.
You are right, derived properties is still in beta. At the end it is the same functionality as pulling derived columns into an object table. But with the difference that you can use derived properties as like a normal object property and perform a bit more simple math. Meaning you can use it in filter widgets, charts etc.
just watch out, derived properties are queried at runtime. You will notice some slightly increased loading times and increased costs. We only use it if dynamic runtime updates from those linked properties is expected.
