Objects are created in a Workshop application (no backing dataset). I want to add a column that shows how much time has passed since each object was created, based on the current day.
I’ve set up a function-backed column in my object table to do this. However, I’ve run into a problem: I can’t seem to use this backed column to create metrics, charts, or other visualizations in Workshop.
My backup solution is to create a property with an initial value (0) and then update it each night using an ontology edit function using an automation process.
What I’d like to know:
Is it possible to use function-backed columns for metrics, charts, or similar tools in Workshop or should I go with my backup solution ?
Or maybe there’s an even better way to handle this?
You should be able to leverage these functions as part of metric cards and charts. However, you will need to write a wrapper function to access the values as charts and metric cards will each expect a slightly different input and output.
A metric card will just expect a value of a certain type. So you can use the object property transformation to get property_1. You can also use similar code as your function backed column, however, you will need to have a function that takes in Object of type A and return a string / num / timestamp etc.
I have created a new @Function to make the mean of my backed column function, based on https://www.palantir.com/docs/foundry/functions/create-custom-aggregation/