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

[SAS VA] how can I filter charts based on a calculated field that is based on a parameter?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

[SAS VA] how can I filter charts based on a calculated field that is based on a parameter?

Hi Community,

 

A 2nd post, for a different problem that I have in SAS VA. 

See the attached Excel for the problem description. 

 

To briefly repeat it here: 

- I have a report, in which many charts are filtered on 1 parameter (named NR). This is no problem 

- Now I want to make a new tab, and filter its charts on the entity that is associated with this number. In my data, 1 entity has multiple NRs and 1 NR always has 1 entity (so based on the NR parameter, I'd like to lookup the entity and filter the charts on this)

- I prefer to avoid a 2nd parameter "entity", since it can be derived from NR

 

I cannot get this (filtering on a calculated field based on my parameter) working in SAS VA... Is this somehow possible?

 

I have attached an Excelfile with a sample dataset and scenario's to explain the problem better.

I discussed it with some colleagues too, but so far no luck (yet).


I hope you can shine some bright light on it, or advise me on the solution that fits my requirement best.

 

Thanks!

Roberto


Accepted Solutions
Solution
‎05-20-2016 07:19 AM
SAS Employee
Posts: 35

Re: [SAS VA] how can I filter charts based on a calculated field that is based on a parameter?

Roberto:

 

Now re: this post of yours ...

You can avoid requiring the users having to input an additional parameter "ENTITY" but you still need to have it.

It can automatically be filtered by the NR Parameter though.  And then it can automatically filter the List Table.

See attached screen capture.

 

I used a Button Bar for ENTITY.  I imagine you could use other Controls as well.

They key though is ...

1) Don't show Frequencies for ENTITY within the Control

2) Under Properties ... un-check 'Enable selection in the viewers' and check 'Required'

3) For hard-coded Filter for the Control, eventhough it's displaying ENTITY, create an Advanced Filter where NR = NR_PARAM

4) Under Styles for the Control, try to make it as "Invisible" as possible to the end user OR use Precision Layout for the Section and "Hide" the Control behind the List Table.  Keep in mind that my screen capture really didn't do any of this so you can see it.

 

Hope this helps,

Ted Stolarczyk, SAS Customer Loyalty team

 

 


2_Param_Filter_Only_Enter_1.jpg

View solution in original post


All Replies
Solution
‎05-20-2016 07:19 AM
SAS Employee
Posts: 35

Re: [SAS VA] how can I filter charts based on a calculated field that is based on a parameter?

Roberto:

 

Now re: this post of yours ...

You can avoid requiring the users having to input an additional parameter "ENTITY" but you still need to have it.

It can automatically be filtered by the NR Parameter though.  And then it can automatically filter the List Table.

See attached screen capture.

 

I used a Button Bar for ENTITY.  I imagine you could use other Controls as well.

They key though is ...

1) Don't show Frequencies for ENTITY within the Control

2) Under Properties ... un-check 'Enable selection in the viewers' and check 'Required'

3) For hard-coded Filter for the Control, eventhough it's displaying ENTITY, create an Advanced Filter where NR = NR_PARAM

4) Under Styles for the Control, try to make it as "Invisible" as possible to the end user OR use Precision Layout for the Section and "Hide" the Control behind the List Table.  Keep in mind that my screen capture really didn't do any of this so you can see it.

 

Hope this helps,

Ted Stolarczyk, SAS Customer Loyalty team

 

 


2_Param_Filter_Only_Enter_1.jpg
Occasional Contributor
Posts: 5

Re: [SAS VA] how can I filter charts based on a calculated field that is based on a parameter?

Perfect! This indeed works for me.

 

I have to see a little more about how to hide the buttonbar best, but I'm sure we'll find a way to do this.

 

Thanks a lot for answering both my questions :---)

 

Roberto

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 420 views
  • 1 like
  • 2 in conversation