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.
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 set)
One example are estimated hours.
Niels suggested the following solution.
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 set)