About Oscarboots

Oscarboots · ‎07-15-2015

Thanks Anna, Hi Teja, This looks great! Can you run through how you built your example? Do these use the same dataset? Are they created separately & then imported into a new report? Anything else relevant Thanks Peter

Oscarboots · ‎07-15-2015

Thanks Teja, I won't need to animate the charts, just view them. If you're having trouble uploading the images, you can just give me the roles & the fields I need to use to get the behaviour I need. For the snapshot I posted, I used the software program 'Printkey' (free version is available on the net) & uploaded my charts as an image. Peter

Oscarboots · ‎07-15-2015

Hi Teja, I've found that I can create 2 Charts and have, for example, a drop down box that changes the filters for both charts in SAS VA, however, what I want is to have 2 charts that can have filters separately so a user can look at data from different periods in each chart in the same screenshot. In my screenshot you could look at the WK1 - WK4 chart & compare the data from the same table for WK5 - WK8. Hope that makes sense. Peter

Oscarboots · ‎07-15-2015

I'm not sure what you mean? Can you advise how to do this in SAS VA or not?

Oscarboots · ‎07-15-2015

Hi Teja, Here's a mockup from Excel, I would like something close to this if possible, otherwise I'll use your other suggestion, I'd like to have the date ranges able to be selected independently for each chart so the User can select whatever periods to compare Thanks

Oscarboots · ‎07-14-2015

Thanks for your response Teja, That's an idea, but I was thinking of something like 2 Line charts that display different periods based on the same data. I've tried creating 2 separate reports with Sliders to give the user the option to choose a time period for each. Is it possible to put a report into a container & have its filters only work for that report? Cheers

Oscarboots · ‎07-14-2015

Hi Forum, I've tried to create some charts & then put them into Horizontal containers so I can have a drop Down filter on each. That was the theory anyway as the Drop Down filters the whole container. Ideally, I want 2 or more charts showing weekly sales data for various Products side by side so I can compare one week with another for the Products. Can anyone advise the best way to do this? Thanks

Oscarboots · ‎06-18-2015

I found out through SAS Tech support that the 'BASE' table was the table that held all the appended data & I was looking at the 'JOB' file instead. Should've realised this but there it is... So append was working correctly & appending my records.

Oscarboots · ‎06-17-2015

Thanks but I have plenty of VA resources & this is what I need to do. I just need to know how it can be done. VA already allows the slicing & dicing of tables via the Add In, I just want to be able to append data to those tables. Anyone?

Oscarboots · ‎06-17-2015

Hi Boschy, I'm not trying to export to Excel if that's what you mean. I want to connect to a SAS VA table through the Excel SAS Add In & then view & slice/dice the data with a Pivot table. So the data I'm using is in memory. Because I want to add more data to the table each week, I want to append more data. I've found that once I append the data it isn't visible through Excel. I need to either change the object after the append or something else so I can access via Excel.

Oscarboots · ‎06-17-2015

OK, I've found that if I upload as separate tables I can then go to 'LASR' >> Append tables & append the tables. Now I want to view this new consolidated table through Excel, but as it isn't a table object, it isn't available to select? Is there a way to change the new tables so I can access through Excel? Thanks

Oscarboots · ‎06-17-2015

Thanks Teja

Oscarboots · ‎06-16-2015

Hi Forum, I can upload through EG to VA without a problem but I want to keep adding data to the same table. Is this supported? if so, how can it be done? Thanks

Oscarboots · ‎06-16-2015

Thanks Chris/Roy, I'd at least like to know if it's supported or not. Then I could look for other ways to solve the problem, not knowing is frustrating...

Oscarboots · ‎06-09-2015

Hi, I have what was originally an Excel Worksheet with about 20 Columns. I've uploaded this to VA & created a List table report to email to the audience. I can't work out where to find the controls to allow all Columns to be exported as a pdf report? It cuts off the Columns after about 8 Columns. I've tried creating the report within a Horizontal container, adding a Text heading but no luck. Where can I make this report either allow more Columns OR make it a 2 page report? Stacked Container maybe? Thanks

Online Status	Offline
Date Last Visited	‎05-31-2016 02:14 AM

Re: SAS VA Version 7.1 Visualisation Stop List Greyed Out

SAS VA Version 7.1 Visualisation Stop List Greyed Out

Re: Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Re: Aggregated measures not showing results?

Re: Aggregated measures not showing results?

Re: Aggregated measures not showing results?

Aggregated measures not showing results?

Re: Problem Uploading .xlsx file to VA

Re: Automating SAS Enterprise Gude Graphs with Batch & vbs only, no Wi...

Re: SAS VA Version 7.1 Visualisation Stop List Greyed Out

Re: SAS VA Version 7.1 Visualisation Stop List Greyed Out

Re: Aggregated measures not showing results?

Re: Sankey Diagrams in SAS VA

Re: Select Case expression in SAS EG 5.1 Expression builder

Re: Sankey Diagrams in SAS VA

Re: Stored Procedure to trigger a SAS EG Graph

Re: Multiple Charts side by side with different Date Ranges

Re: Multiple Charts side by side with different Date Ranges

Re: Multiple Charts side by side with different Date Ranges

Re: Multiple Charts side by side with different Date Ranges

Re: Multiple Charts side by side with different Date Ranges

Re: Multiple Charts side by side with different Date Ranges

Re: Multiple Charts side by side with different Date Ranges

Multiple Charts side by side with different Date Ranges

Re: Upload & append data to existing table from EG to VA

Re: Upload & append data to existing table from EG to VA

Re: Upload & append data to existing table from EG to VA

Re: Upload & append data to existing table from EG to VA

Re: Distributed List table reports truncated as exported to pdf

Upload & append data to existing table from EG to VA

Re: Distributed List table reports truncated as exported to pdf

Distributed List table reports truncated as exported to pdf