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?
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.