Currently, VA doesn't allow to create a filter on a field that uses a table calculation.
We need to flush this out first. Consider the following:
A | B | C | D | E ---+----+----+----+---- 3 | 1 | 0 | 2 | 4 <== original values 30%| 10%| 0% | 20%| 40% <== % of total table calc
Now suppose we want to apply the following filter: table calc < 30%
Thus columns A and E are now filtered out. The following is the result:
B | C | D ----+----+---- 1 | 0 | 2 <== original values 33%| 0% | 67% <== % of total table calc
Note the table calc values are changed due to the filter. AND the result does NOT appear to respect the filter; 33% and 67% should be filtered out!
We need a specific use case from the requesting customer before we can proceed.
Another approach:
Another approach:
Issue #15381 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
We need to flush this out first. Consider the following:
Now suppose we want to apply the following filter: table calc < 30%
Thus columns A and E are now filtered out. The following is the result:
Note the table calc values are changed due to the filter. AND the result does NOT appear to respect the filter; 33% and 67% should be filtered out!
We need a specific use case from the requesting customer before we can proceed.