Allocations By Resource: Error adding TSV Total Columns
search cancel

Allocations By Resource: Error adding TSV Total Columns


Article ID: 259742


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


In the Staffing Workspace, 'Allocations by Resource' when you add any TSV Total column (other than the Allocation field) you get the API-1057 Toast message. Adding the fields on the 'Allocations by Investment' layout works as expected. 

Steps to Reproduce: 

  1. Go to the Staffing Workspace Allocations Timeline tab
  2. For the 'Allocations by Investment' layout add one of the TSV Total columns such as Hard Allocation or any other Total field (the column is added successfully) 
  3. Switch to the 'Allocations by Resource' layout 

Expected Results: The page loads successfully without a Toast message. 

Actual Results: The results do not load and you get a Toast message: API-1057 : An attribute needs to be groupable or aggregatable to be used in group by or aggregation respectively. Attributes used in 'groupBy' and 'aggr' must be present in fields. 'sort' and 'expand' cannot be used with 'groupBy'. 

Workaround: When using the 'Allocations by Resource' layout remove the Total columns or switch to another view that does not use these columns in the layout. 



Release 16.1.1 




Due to the complexities of this issue, it has been determined it is not a candidate for a Patch request. 

Targeted Fix in Release 16.1.2