turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Visual Analytics
- /
- Using _ForAll_ in filter is not working correctly

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

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

Any ideas?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

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.