Content
View differences
Updated by Markus Kahl almost 7 years ago
The display of sums for certain columns which are derived from relations can be confusing. What could we do to make this easier to understand?
One example are estimated hours.
Niels suggested the following solution.
 


> Separate work package attributes that show the user what is included in the presented cell value:
>
> * Estimated time: Aggregated values including the values of children
> * Total estimated time: Only the estimated time that is logged on this work package
>
> So for the attribute "Estimated time - total" it is not possible to create sums.
This does still not address the issue of how the sum should be calculated in the following scenario:
* the query includes a parent which has 3 children with 1 hour each (so the parent has an estimated time of 3)
* of the 3 children only 2 are included in the query
What does the sum say in this case?
a) 3 hours (estimated time of the parent which is in the result set)
b) 2 hours (sum of estimated time of the two children in the result resultĀ
answer
Niels: b) because a is wrong
One example are estimated hours.
Niels suggested the following solution.


>
> * Estimated time: Aggregated values including the values of children
> * Total estimated time: Only the estimated time that is logged on this work package
>
> So for the attribute "Estimated time - total" it is not possible to create sums.
This does still not address the issue of how the sum should be calculated in the following scenario:
* the query includes a parent which has 3 children with 1 hour each (so the parent has an estimated time of 3)
* of the 3 children only 2 are included in the query
What does the sum say in this case?
a) 3 hours (estimated time of the parent which is in the result set)
b) 2 hours (sum of estimated time of the two children in the result
answer
Niels: b) because a is wrong