BookmarkSubscribeRSS Feed
Quentin
Super User

Hi All,

I'm new to VA.  Have v6.4.

I had hoped to design a report that shows a time series (of counts) and a table listing.  With an interaction such that when user clicks a point in the time series, the values corresponding to that point are shown in the table listing.

I was unhappy to find this in the documentation:  "Tables, graphs, and gauges can be the source of an interaction, with the exception of time series plots."

Is there any recommended work-around that would allow me to fake using a time series plot as the source of an interaction?

In GTL, for example, it's easy to overlay an invisible scatterplot, and use the scatterplot symbols as the source of the interaction (URLdrill ).  But VA didn't want to make a scatterplot of date*count, because the date variable has a role of categorical.  Even if I could trick VA into making a scatterplot, not sure how I would overlay them.  Perhaps I would need to make a custom plot, which is a time series with a 100% transparent  scatterplot overlayed?

I'm on day 2 of playing with VA, so happy for any suggestions.

Thanks,

--Q.

BASUG is hosting free webinars Next up: Jane Eslinger presenting PROC REPORT and the ODS EXCEL destination on Mar 27 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.
1 REPLY 1
rmalcata
Quartz | Level 8

Hi,

 

I have tried to use a customized graph with a time series and a scatter plot. The combined graph still cannot be used for the interaction. So this is not a solution. 

Can you let me know if you have come across any potential solution?

 

Regards,

 

Rita

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 855 views
  • 0 likes
  • 2 in conversation