Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

create summary report in sas visual analytics designer

Reply
New Contributor
Posts: 4

create summary report in sas visual analytics designer

how can i design report to show summary value in text in section. E.g: 'Total Items handled per hour : 152'

Frequent Contributor
Posts: 85

Re: create summary report in sas visual analytics designer

Text object available for full text viewing. But it would be static. As far as I know there is no option to create a full text to show summarized value, provided the value is dynamic and must update automatically.

- satlr

New Contributor
Posts: 4

Re: create summary report in sas visual analytics designer

Hi,

I want to display value like this, where the strings are typed text and the numeric figured are from source.

Can I achieve  this in SAS VA Designer (Reporting)?

Total Weight (Kg):           2578

     Docs Weight:              578

     Non Docs Weight:      2000

Thanks,

Raji

SAS Employee
Posts: 4

Re: create summary report in sas visual analytics designer

Hi Raji,

There are currently no easy way on achieving this.

However if you use "precision" design, you can position a text element next to a small list table without headers. Depending on how data is structured you would need three list tables, "Docs Weight" and "Non Docs Weight" should have a filter do subset it correctly.

I have done similar multiple times. It is more tedious compared to "side by side" layout, but I think the end result is better and you get more flexibility.

Hope it can help you achieve what you need.

Best Regards,

Rune

Frequent Contributor
Posts: 85

Re: create summary report in sas visual analytics designer

hi Rune...I am interested to try this approach. I am using 6.3

could you pls help me how I can access precision design.

greetings

satlr

Super User
Posts: 1,228

Re: create summary report in sas visual analytics designer

Hi satlr,

A SAS Visual Analytics report layout can be changed in the section property as documented at SAS(R) Visual Analytics 6.3: User's Guide

The default layout of a report is tiled.

Kind Regards,

Michelle

Frequent Contributor
Posts: 85

Re: create summary report in sas visual analytics designer

thanks Michelle. greetings

satlr

SAS Employee
Posts: 85

Re: create summary report in sas visual analytics designer

To get VA to render the way you want it to, you will need to prep the data to include total, docs weight and non-docs weight then add one list table and follow Rune@sas instructions. Preparing the data to show summary details outside of VA you can also add additional filtering capabilities (i.e. if you have specific product names you can sumarize by product name and include a drop-down list filter to show summary data by product). With only one list table you can avoid the need to constantly adjust each of the list tables anytime and instead just adjust one.

I have also done this multiple times and it resonates with the business side.

-shawn

New Contributor
Posts: 4

Re: create summary report in sas visual analytics designer

HI Shawn and Rune,

Thanks for your advise.

It works for me.

Thanks.

SAS Employee
Posts: 4

Re: create summary report in sas visual analytics designer

Great Raji, glad to help.

BR,

Rune

Community Manager
Posts: 463

Re: create summary report in sas visual analytics designer

Yes, happy to see you got what you needed, Raji! Can you mark appropriate answers as "correct" or "helpful" so other community members can easily reference what worked?

Thanks!

Anna

Ask a Question
Discussion stats
  • 10 replies
  • 663 views
  • 2 likes
  • 6 in conversation