topic Conditionally Show or Hide a Time Series Data. in SAS Visual Analytics

Conditionally Show or Hide a Time Series Data.

thiagoglima — Wed, 26 Jul 2017 20:43:50 GMT

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.

Re: Conditionally Show or Hide a Time Series Data.

AMos — Thu, 27 Jul 2017 06:19:57 GMT

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`.

Re: Conditionally Show or Hide a Time Series Data.

thiagoglima — Thu, 27 Jul 2017 12:51:05 GMT

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!

Re: Conditionally Show or Hide a Time Series Data.

thiagoglima — Thu, 27 Jul 2017 14:43:19 GMT

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/207643

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

Thanks!