topic Re: SAS VA in SAS Visual Analytics

SAS VA

Akas_wankha — Tue, 28 Nov 2017 09:58:28 GMT

Hi All,

I have 3 Bar charts in designer and I want to add total label in each bar chart to display a total of all measure in bar,

Is there any workaround?

Please suggest.

Re: SAS VA

TejaSurapaneni — Wed, 29 Nov 2017 12:35:14 GMT

Hi @Akas_wankha,

is this your requirement?

There are two ways to show the TOTAL Value in Bar Chart.

Thanks,

Teja Surapaneni

Re: SAS VA

Akas_wankha — Wed, 29 Nov 2017 09:07:34 GMT

I want label like above image in Bar chart which will show total of bar values in it..

like above label should contain 190..

Please suggest.

Re: SAS VA

Akas_wankha — Wed, 29 Nov 2017 10:37:18 GMT

Also tell how did you implemented above

Re: SAS VA

TejaSurapaneni — Wed, 29 Nov 2017 12:36:35 GMT

Hi,

In my knowledge... option is not available to show Label value (TOTAL) in Bar Chart Instead of that you can use Data tip value (which is available Bar Graph roles) to show Total Value.

create an Aggregated Measure and Name it as Total Budget/your Measure name.

Then assign this Agg. Measure to Date tip value.

The Previous Graph (In my last post) is done through Custom Graph builder.

If you want I will share the steps.

Thanks,

Teja Surapaneni

Re: SAS VA

KeithM — Wed, 29 Nov 2017 16:12:06 GMT

I was able to accomplish this in VA 7.4 by simply using a precision layout and centering a Text Object that uses a dynamic measure.

Re: SAS VA

KeithM — Wed, 29 Nov 2017 16:23:20 GMT

A more graceful approach is to use tiled layout and simple center the Dynamic text above the bar chart. See above

Re: SAS VA

TejaSurapaneni — Thu, 30 Nov 2017 06:40:38 GMT

Hi @Akas_wankha,

Sorry for the late Reply...

Steps for Custom Graph:

1) Drag and drop Two Bar Charts into canvas area (Not Side by Side).

2) Create a shared Role.

3) assign/share the created Shared Role with Bar charts Measure. (Right Click on Bar Measures you will get an option USE SHARED ROLE)

Then Save it.

In your Designer Create a Calculated (Character)/Custom Category and Name it as Total (as per my Exmple: IF Region in (EAST, West, North, South) Return Total else ' ')

after that assign the roles for Custom Graph.

Category 1 : Region

Category 2: Total

Shared Measure : Budget/Measure.

Let me know if you found any difficulties while doing.

Thanks,

Teja Surapaneni

Re: SAS VA

Akas_wankha — Wed, 06 Dec 2017 08:04:17 GMT

Hi Teja,

I have created shared rule and assigned required measures and categories to Role. The problem I am facing is with mandatory category value.

Please find attached screenshot 1 after assigning roles and

screenshot 2 for roles available after creation of custom bar chart.

Re: SAS VA

TejaSurapaneni — Wed, 06 Dec 2017 09:16:14 GMT

Hi @Akas_wankha,

Can you please share the screenshot of ROLES (with Assigned columns).

Thanks,

Teja