Typically I have a wide range of values and I prefer to use the "advanced edit" option when applying my filters, however it looks like when I put aggregated measures in there (frequency, custom calculations) the advanced edit option is grayed out and I am not able to select it. Is there no way to more specifically edit the bounds of a filter on aggregated measures? (Using the sliders goes from 1 to 1000 with no in between, my goal is to set it at 30)
Thanks in advance!
I'm using VA 8.5 and did the following test. I have simple a source data and I created a simple aggregated measure using New Calculated Item functionality: My Aggregation = Avg [_ByGroup_] ('Measure'n).
I have a List table and I created a filter using My Aggregation. This is how it looks like:
When I go to Advanced Edit it looks like this:
I wonder what version of VA you have and the complexity of the aggregation?
I'm using SAS v8.3. I have a simple aggregation that looks like this:
But when I try to use Advanced Edit to create a filter for it, it is greyed out.
The only thing I can think of which might be causing this is that I created my aggregated measure from an aggregated data source. Can you try to create an aggregated data source from your list table, and then try to create an Advanced filter using the aggregated data source?
I followed your steps.
I found out that I was able to got to Advanced edit...
This really puzzles me. I wonder if you could try to replicate the problem with one the data sets you can find from Data Sources > cas-shared-default > Samples ? That way I could use the same data as you and the only difference would be our versions of sw.
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.