BookmarkSubscribeRSS Feed
triptiagg200
Fluorite | Level 6

Hi,

 

I am trying to build a dashboard in SAS VA from an excel spreadsheet.

I have imported the sheet in SAS VA, but I am not able to refresh the charts when the new row fields are added in the spreadsheet.

 

Is it possible to refresh the excel data source? 

 

 

1 REPLY 1
Sam_SAS
SAS Employee

Hello,

 

To update the spreadsheet manually, I believe you would just import the spreadsheet again and select "Replace file" in the import window.

 

I believe it is also possible to set up a scheduled job to do this every day (or every hour, etc) if you have data admin permissions, but this is not an area of expertise for me.

 

Sam

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

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
  • 678 views
  • 0 likes
  • 2 in conversation