Creating a pie chart by department name from linked Employee and Department datasets in Workshop Application

Hi everyone,

In the Palantir Workshop Application, I have an Employee object set that contains a foreign key department_id linked to a Department dataset with department names.

Since these datasets are already linked, I want to create a pie chart showing the count of employees grouped by the department name from the Department dataset.

How can I best leverage these linked datasets in the Workshop Application to create this pie chart without manually joining the datasets?

Thanks for your help!

Hi @AryanThadani022. If you are not bound to a pie chart, you can use the function-backed option for XY charts.
Within your function, you can perform the searcharound to get the linked department. Check out the official documentation:

docs/foundry/workshop/widgets-chart/#function-aggregations-function-backed-layers

However, it would be a neat first class experience for us builders to e.g. enable linked properties to be selected as segment by option. So +1 on a feature request :slight_smile:

2 Likes