Is it possible to create an Object table backed by a TS function where I have aggregated. And what needs to be the structure of the final return that I should be creating inorder to be used in a widget. Currently the object table widget seems to be unhappy with the object I return. What should I return inorder to display the value?
@Benutzer7, can you provide more details with what/how you’re trying to aggregate? Without an example, the best I can do is provide a link to the TS function-backed column documentation: Workshop • Core display widgets • Object Table
Hi @Joel,
The following is what I was looking out for -
I wanted to create a derived objectTable by aggregating the count of a particular value of a property of whole backing objectTable. So if there was a property called “Stage” and another property called “Cost“. I wanted to derive an objectTable with Stage vs Count and also aggregate(Sum) of a Property “Cost” for a particular Stage and call it “TotalCost”.
So, The expected return of the TS function would be
Stage=In Process, Count(Number of occurances)=23,TotalCost=12345.12
I was able to achieve this through derived properties. Wanted to know if this was possible through TS nacked function and directly call the output structure to an ObjectTable.
Thanks
I don’t believe you can do that but you could make a markdown table from a function backed variable. https://www.palantir.com/docs/foundry/workshop/widgets-markdown/#configuration-options