topic Re: create summary report in sas visual analytics designer in SAS Visual Analytics

create summary report in sas visual analytics designer

rajisivarajan — Thu, 31 Jul 2014 14:53:49 GMT

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

Re: create summary report in sas visual analytics designer

sat_lr — Fri, 01 Aug 2014 06:42:28 GMT

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

Re: create summary report in sas visual analytics designer

rajisivarajan — Fri, 01 Aug 2014 11:58:08 GMT

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

Re: create summary report in sas visual analytics designer

Rune_sas — Fri, 01 Aug 2014 13:30:21 GMT

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

Re: create summary report in sas visual analytics designer

sat_lr — Tue, 05 Aug 2014 10:38:46 GMT

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

Re: create summary report in sas visual analytics designer

MichelleHomes — Tue, 05 Aug 2014 10:54:27 GMT

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

Re: create summary report in sas visual analytics designer

sat_lr — Tue, 05 Aug 2014 12:46:45 GMT

thanks Michelle. greetings

satlr

Re: create summary report in sas visual analytics designer

skillman — Tue, 05 Aug 2014 13:09:13 GMT

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

Re: create summary report in sas visual analytics designer

rajisivarajan — Tue, 05 Aug 2014 13:29:10 GMT

HI Shawn and Rune,

Thanks for your advise.

It works for me.

Thanks.

Re: create summary report in sas visual analytics designer

Rune_sas — Tue, 05 Aug 2014 14:03:08 GMT

Great Raji, glad to help.

BR,

Rune

Re: create summary report in sas visual analytics designer

AnnaBrown — Tue, 05 Aug 2014 14:34:25 GMT

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