Clarity: On Task Lists Page, Aggregated data is calculating higher then expected

Document ID : KB000028773
Last Modified Date : 14/02/2018
Show Technical Document Details


On the Task lists page, if you have multiple task levels, aggregation will appear higher then expected because it is calculating each lowest level task, plus the total at each higher level. Example, if you have three levels, Task, Activity, Phase, it will calculate the sum of Actuals as: Task + Activity + Phase) 

Steps to Reproduce:

1. In Clarity, navigate to a project that has tasks with multiple levels, then click on the Tasks tab.
2. Click the Options icon, then Configure.   
3. From List Column Selection drop down, select Aggregation.
4. Click the Add button to create a new Aggregation Row.  
5. Add a name for the Aggregate in the Label field.  
6. For ETC (or any other attribute), change the Function to Sum and click Save and Return. 
7. Click Save and Return again. 

Expected Result:  The ETC Aggregation Total only counts each task once. 

Actual Result:  The ETC Aggregation Total counts each task plus the totals of each level. 


This is working as designed.  The way to be able to get the accurate aggregation on the task list is to filter on Tasks Only. This can be done by going to the Task page, and in the Task list filter section, select Yes from the Tasks Only drop down. Key Tasks should be set to All to capture Key Tasks as well.

If you can provide specific use cases where an enhancement in this area would greatly improve your user experience in Clarity, please request an enhancement for our Product Management team to review, you can use the Idea feature of the Clarity Global User Community at: If you are not a member of the Clarity Global User Community, we encourage you to join today.