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

SAS VA

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

SAS VA

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.


Accepted Solutions
Solution
‎11-30-2017 10:33 AM
Regular Contributor
Posts: 208

Re: SAS VA

Posted in reply to Akas_wankha

Hi @Akas_wankha,

 

Sorry for the late Reply...Man Sad

 

 

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

View solution in original post


All Replies
Regular Contributor
Posts: 208

Re: SAS VA

[ Edited ]
Posted in reply to Akas_wankha

Hi @Akas_wankha,

 

 

 

Untitled.png

 

is this your requirement?

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

 

 

 

Thanks,

Teja Surapaneni

Occasional Contributor
Posts: 14

Re: SAS VA

[ Edited ]
Posted in reply to TejaSurapaneni

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.

Regular Contributor
Posts: 208

Re: SAS VA

[ Edited ]
Posted in reply to Akas_wankha

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.

 

Untitled.png

 

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

 

Untitled.png

 

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

Occasional Contributor
Posts: 14

Re: SAS VA

Posted in reply to TejaSurapaneni
Also tell how did you implemented above
Solution
‎11-30-2017 10:33 AM
Regular Contributor
Posts: 208

Re: SAS VA

Posted in reply to Akas_wankha

Hi @Akas_wankha,

 

Sorry for the late Reply...Man Sad

 

 

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

Occasional Contributor
Posts: 14

Re: SAS VA

Posted in reply to TejaSurapaneni

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.

 

 

 

Regular Contributor
Posts: 208

Re: SAS VA

Posted in reply to Akas_wankha

Hi @Akas_wankha,

 

 

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

 

 

 

Thanks,

Teja

SAS Employee
Posts: 18

Re: SAS VA

Posted in reply to Akas_wankha

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.

 

total.JPG

SAS Employee
Posts: 18

Re: SAS VA

total2.JPG

 

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 9 replies
  • 910 views
  • 5 likes
  • 3 in conversation