topic Rounding axes values, e.g. displaying $1,000,000 as $1M in SAS Visual Analytics

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

jamesdean — Mon, 31 Oct 2016 13:16:19 GMT

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!

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

XavierBizoux — Tue, 08 Nov 2016 09:28:39 GMT

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

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

SASKiwi — Tue, 08 Nov 2016 19:17:22 GMT

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...

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

XavierBizoux — Tue, 08 Nov 2016 19:39:50 GMT

Hi,

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

Have a good day