Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Using _ForAll_ in filter is not working correctly

Reply
Contributor
Posts: 53

Using _ForAll_ in filter is not working correctly

[ Edited ]

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...

 

Any ideas?

 

 

Contributor
Posts: 53

Re: Using _ForAll_ in filter is not working correctly

[ Edited ]

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.

Ask a Question
Discussion stats
  • 1 reply
  • 230 views
  • 0 likes
  • 1 in conversation