Color and Title Gantt Chart pucks by Calculated field

We would like to be able to dynamically color and title individual pucks based on a calculated value (or linked object aggregation) rather than by properties of the object being charted.

Example, if we are showing an employee’s forecasted hours on a single project, but they are assigned to multiple projects in the system, we want to display the hours assigned to the current project AND the sum of all hours, across all projects in that same period. Ideally, we want to color the puck based on the overall capacity of the person (not by hours assigned to the project being viewed, but by the total hours they are assigned overall).

Right now, the only way to do this, is to have a total hours and capacity property on each period per person per project, and update ALL of them if a single one changes - just to have the total and capacity reflected across all projects.

Howdy!

Tagging in the Ontology Management team as they own conditional formatting across the Foundry platform. The Ontology Management team can better speak to any plans for allowing function backed conditional formatting.

On the Scheduling Gantt front you could use the recently introduced function backed puck properties feature which allows you configure conditional formatting rules. For this specific use case:

  1. Write a function that calculates total assigned hours across all projects for a given period

  2. Add the property to be displayed on your Scheduling Gantt pucks

  3. Configure conditional formatting rules on that property.