topic Re: SAS Visual Analytics 7.4 - Use a parameter and control to filter a list table in SAS Visual Analytics

SAS Visual Analytics 7.4 - Use a parameter and control to filter a list table

Robert_T — Mon, 27 Aug 2018 22:23:35 GMT

Hi, In SAS Visual Analytics 7.4, we are trying to use a control object to filter a list table.

Ideally, it should allow the report viewers to adjust a control, like a slider, and have it filter the list table by the Aggregated Values, not just the Detail Values.

The steps taken so far are as follows:

Create a numeric parameter ("Customer Units Parameter")
Create a slider control, and add the parameter
Create a list table with two columns: one category ("Customer") and one measure ("Units").
Apply an advanced filter to the list table "Units >= Customer Units Parameter"

With the above set-up, when the slide control is used, it filters the underlying row level data so that the table only displays the sum of the row level unit values greater than the parameter.

However, the effect we want is for the list table to filter to customers with aggregated units greater than the parameter.

Is this doable?

Side Note: This parameter, control and list table work well when using display rules to brush the values in the table. For example, you can set the aggregated values to be highlighted when greater than the parameter. But unfortunately, that is not the desired effect we want for this particular visualization.

Thank you.

Re: SAS Visual Analytics 7.4 - Use a parameter and control to filter a list table

FredrikE — Tue, 28 Aug 2018 07:50:41 GMT

Hi!

I haven't found a way to do this in an straight way, but think I have a work around 🙂

I tested this with sashelp.class:

I added the data set and created a parameter "sumwieght":

I then added three objects (the left list for checking the values only), the parameter is assigned to the slider:

I created a filter on the right table, but instead of creating it from scratch I selected weight and then clicked the "Add filter"-button:

As you see there is a check box for aggregated values and the slider values are the aggregated ones.

Next step was to edit the filter by clicking the small arrow:

Then I added my own filter expression and I now is able to filter the list table on aggregated values with the slider.

Hope this was what you tried to achieve 🙂

//Fredrik

Re: SAS Visual Analytics 7.4 - Use a parameter and control to filter a list table

Robert_T — Tue, 28 Aug 2018 13:05:38 GMT

Indeed a PROC Star!