Hi, everyone. Sorry for the confusing title, but I need some help.
I have an object that contains a lot of information, including a property with people’s names.
Some names appear more than once because multiple items belong to the same person.
What I want is to display, in a kind of table, a list showing each unique person’s name (even if it appears multiple times in the original object) along with the total number of items that belong to them.
Does that make sense?
Example:
Name
Alice A
Alice B
Alice A
Alice A
Gustave A
Gustave A
Harry B
Diogo A
So i want to show…
Name
Count
Alice A
3
Alice B
1
Diogo A
1
Gustave A
2
Harry B
1
I don’t want to use functions and return a array of string…
because i want to show in red people that have less than 2 objects in their names.
Hi @Gabriel Not sure if I am seeing this too simple, but your description sounds like you are looking for the pivot table?
Put the name on the row grouping and use as aggregate the count. You can also define conditional formatting such as „if count > 2 set red“.
Here is the link to documentation: https://www.palantir.com/docs/foundry/workshop/widgets-pivot-table/
In case you need a more concrete example I can take a look again tomorrow
Yep pivot will do, we do exactly the same with around 82 financial reports. You can also use the Beta derived properties linking an Object Type with an other Object types. for multi hop you need a Function.
Hi Phil,
We’ve been working on replacing reports originally built in SAP-BW, and much of that relies heavily on pivot tables. During this process, we ran into a familiar challenge: the need to include data from other Object types—something a relational database handles more naturally.
Palantir provides a solution with single-hop joins. For multi-hop joins, however, you’ll need to write a function that defines how the data should be pulled across multiple links, which fortunately is quite manageable.
We’re currently evaluating with PLTR whether a full multi-hop setup is the best path forward or write functions
Here’s a quick rundown of how it works:
Open a Pivot Table widget.
Navigate to your primary Object type.
In the Derived Property window (1), select a linked Object type. (I guess you understand how to link Object types.)
A configuration window (2) will appear where you can define all the necessary settings for your pivot.
Good luck—and feel free to reach out if you get stuck!
