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

Conditionally Show or Hide a Time Series Data.

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Conditionally Show or Hide a Time Series Data.

[ Edited ]

Hi,

 

I'm trying to create a filter to show or hide a time series data. My dataset has three columns: a Historical Data, Reconciled Forecast, and Forecast. I want a filter to choose which of these columns will appear on my chart. My chart needs to dynamically design the data, is it possible to use a checkbox for this?

For example, if the checkbox for Historical Data is selected then the green line should be shown (Just like the image below), otherwise, the green line should disappear.

 

 

Thanks in Advance.

 

 

 

 

 

 

grafico.PNG


Accepted Solutions
Solution
3 weeks ago
New Contributor
Posts: 4

Re: Conditionally Show or Hide a Time Series Data.

Hi,

 

I found a solution to my problem and would like to thanks for the help! I based my solution on the Renato Answer in the following topic:

 

https://communities.sas.com/t5/SAS-Visual-Analytics/Using-measures-in-list-or-dropdown-controls/td-p...

 

 

I make myself available to anyone who had the same problem and needs help beyond the link above, just contact me!

 

Thanks!

 

View solution in original post


All Replies
New Contributor
Posts: 3

Re: Conditionally Show or Hide a Time Series Data.

Hi,

 

you could do the following.

 

Create a `List` (From Objects / Controls) based on the field you want to filter ( Historical Data, Reconcilled Forecast, Forecast) and then Create an interaction between this List and your `Line Chart`.

 

 

New Contributor
Posts: 4

Re: Conditionally Show or Hide a Time Series Data.

[ Edited ]

Hi Amos, thanks for the answer.

I tried to use a List object, but just categorical data are accepted by this object so I tried to create a new custom categorical data based on the field I want to filter and created an interaction between this list and my time series plot, but nothing happens when I activate/deactivate the check box. Sorry, I don't know what I'm missing, I'm new with V.A!

 

grafico.PNG

Solution
3 weeks ago
New Contributor
Posts: 4

Re: Conditionally Show or Hide a Time Series Data.

Hi,

 

I found a solution to my problem and would like to thanks for the help! I based my solution on the Renato Answer in the following topic:

 

https://communities.sas.com/t5/SAS-Visual-Analytics/Using-measures-in-list-or-dropdown-controls/td-p...

 

 

I make myself available to anyone who had the same problem and needs help beyond the link above, just contact me!

 

Thanks!

 

☑ This topic is SOLVED.

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

Discussion stats
  • 3 replies
  • 437 views
  • 3 likes
  • 2 in conversation