11-02-2016 11:05 AM - edited 11-02-2016 11:59 AM
We are using following aggregated measure in SAS VA 7.3:
( Count [_ByGroup_] ('Inspection_ID'n) / Distinct [_ByGroup_] ('Inspection_ID'n) ) -
( Count [_ForAll_] ('Inspection_ID'n) / Distinct [_ForAll_] ('Inspection_ID'n) )
Filtering on this aggregated measure does not return results as expected. We suspect the _ForAll_ is not returning the correct numbers...
11-15-2016 10:34 AM - edited 11-15-2016 11:20 AM
I think the problem was using filters and ranking on the graph. Those are influencing the outcomes.
Using a filter on an aggregated measure which uses _ForAll_ is not returning outcomes as I expect. I expect it to behave like the 'HAVING' clause in SQL but that is not the case because the _ForAll_ value is changed by applying the filter. The _ForAll_ value is based on the result set that is displayed in the graph.
With ranking it's very important to display 'All Other' when using an aggregated measure which uses _ForAll_. That way the numbers are correct when ranking the graph.