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

Rounding axes values, e.g. displaying $1,000,000 as $1M

Reply
New Contributor
Posts: 2

Rounding axes values, e.g. displaying $1,000,000 as $1M

Hi,

 

I have a report where I have displayed multiple measures on a bar chart. These are all in the millions and so the report axes displays $1,000,000, $2,000,000 etc. However it would appear much cleaner to display this as $1M, $2M etc. Is this possible within SAS Visual Analytics?

 

Interestingly when I selct to show the Y axes label, the values display as $1, $2 etc, however this isn't satisfactory as it doesn't show that these are millions, plus the axes label display all 5 of the measure names which is rather ugly.

 

Thanks!

SAS Employee
Posts: 10

Re: Rounding axes values, e.g. displaying $1,000,000 as $1M

Hi

 

What you want to achieve can only be done through user-defined formats.

The following note covers the information about user-defined formats in SAS® Visual Analytics:

 

http://support.sas.com/kb/47/100.html

 

Have a good day

Respected Advisor
Posts: 2,902

Re: Rounding axes values, e.g. displaying $1,000,000 as $1M

Just be aware that the usual way of doing this with a user-defined format would be with a PICTURE statement. PICTURE formats are explicitly not supported in the current release of SAS VA. This is unfortunate as they would add a lot of flexibility to the way data can be displayed. I live in hope that they may be supported in a future release...

SAS Employee
Posts: 10

Re: Rounding axes values, e.g. displaying $1,000,000 as $1M

Hi,

You can use ranges in to define the format. I guess that should do the trick for your case.

Have a good day


Post a Question
Discussion Stats
  • 3 replies
  • 160 views
  • 0 likes
  • 3 in conversation