06-18-2015 07:32 AM
I have created a sparkline in List table in SAS Visual Analytics. I have rquirement to put date filter on the sparkline to get the sparkline of exposure till the date selected in Date filter. For example:-
We have below variables Date and Exposure, based on which I have created my sparkline.
so if in the dropdown list of Date, we select 20/6/2014 then the sparkline shoud show the spearkline of exposure for 18/6/2014, 19/6/2014 and 20/6/2014, similarly if we select 21/6/2014 in the dropdown it should show the spearkline for 18/6/2014, 19/6/2014, 20/6/2014 and 21/6/2014.
It would be really great if somebody can help me to achive the same.
06-18-2015 11:57 AM
if you are using 7.1 i can advise you to use a parameter for this.
if you link a parameter to your date selection, you can user the parameter value to filter the data.
This way, the report wil only show the data filtered bij de formula ( date>parameter-5 or somthing like this).
greetings and good luck
06-21-2015 12:13 PM
Thank you for your response.
But first let me explain the whole scenario.
I have 4 objects in the report area, drop-down-list, cross-tab, 1st List Table, 2nd list table.
In the drop-down-list, I have date filter. Now the drop-down-list has interaction with cross-tab and 1st List Table only.
The 2nd list table is independent because it contains spark-line in it, and as we know if I will interact it with drop-down list which contains date filter then the spark-line will effect.
Now the requirement is to show the spark-line till the date selected in drop-down-list, for which expression would be date<=selected date in drop-down-list.
I have already tried to create parameter based on the Date column but I think we cannot create parameters from date column, it is my finding till now.
If anyone have any idea on how to create parameter from date column for drop-down-list, then request you to please share the same on this post, it would be really great if you can put some example for reference.
06-22-2015 08:47 AM
Changing the object will not do as the cross tab & 1st list table are showing the selected date values which I can get only by using drop-down.
I just want to know if there is any why using which I can filter my 2nd table with Date column by comparing it with the selected date in dropdown list.
I hope I am clear, if not please let me know.
06-23-2015 12:09 AM
Sorry but I cannot share the dashboard, as it contains sensitive data..
I just need help to identify how can I filter one of my list table based on the condition (Date<=Selected Date in the dropdown), I am doing this because I want the data displayed in one of my list table should only display the data till the date selected in dropdown list. I cannot use slider because in one of the other list table and cross tab, in the same report, I need to show the selected date data only.
I am having SAS VA 7.1, so was trying to use Parameters to apply the condition (Date <=Selected Date in the dropdown) to pass the selected date in the dropdown as parameter on list table, but it is not helping with the date format. I tried changing the date column to numeric but then the issue is we cannot use numeric columns in the dropdown list.
It would be really great if somone can help me to achive the above.
06-23-2015 10:12 AM
Actually in my world your requirement is not possible
just i will suggest you an alternative way which is shown in below.
Hope this will help you.
Thanks & Regards,