topic Best way to follow percent over time in SAS Visual Analytics

Best way to follow percent over time

Allan_dk — Thu, 21 Aug 2014 11:30:55 GMT

Is the costumers moving to Internet/Catalog?

If I look at the numbers in this report based on Orion Star we will see that

In 02.2007 there was sold 720 items

in 01.2012 there was sold 1674 items

http://databank.socialstyrelsen.dk:8080/SASVisualAnalyticsViewer/guest.jsp?reportPath=/Public/&reportName=Orian%20star%20percent

But what I really want to show is that

in 02.2007 it was 8 %

in 01.2012 it has dropped to 7 %

How do I show that in the best way?

We are running 6.3 but expect to jump to 7.1 when available.

Re: Best way to follow percent over time

skillman — Thu, 21 Aug 2014 13:11:06 GMT

Allan,

Have you looked into using the waterfall chart to show this differential of percentages for the given time frame? The waterfall can show different colors based on positive or negative growth differentials.

I tried to open the link you provided but received the following error:

The following data source errors have been found:

ORION_STAR_SCHEMA_NOFORMAT: The data source contains no data items or is not available in memory. To restore the data source, contact your system administrator.

-shawn

Re: Best way to follow percent over time

Allan_dk — Fri, 22 Aug 2014 06:36:01 GMT

I have tried the waterfall chart.

But I have not been able to calculate the percent, so it will only be en actual sales numbers.

The link should be working again.