BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Akas_wankha
Obsidian | Level 7

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.

1 ACCEPTED SOLUTION

Accepted Solutions
TejaSurapaneni
Lapis Lazuli | Level 10

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

9 REPLIES 9
TejaSurapaneni
Lapis Lazuli | Level 10

Hi @Akas_wankha,

 

 

 

Untitled.png

 

is this your requirement?

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

 

 

 

Thanks,

Teja Surapaneni

Akas_wankha
Obsidian | Level 7

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.

TejaSurapaneni
Lapis Lazuli | Level 10

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

Akas_wankha
Obsidian | Level 7
Also tell how did you implemented above
TejaSurapaneni
Lapis Lazuli | Level 10

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

Akas_wankha
Obsidian | Level 7

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.

 

 

 

TejaSurapaneni
Lapis Lazuli | Level 10

Hi @Akas_wankha,

 

 

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

 

 

 

Thanks,

Teja

KeithM
SAS Employee

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

KeithM
SAS Employee

total2.JPG

 

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 9 replies
  • 2896 views
  • 6 likes
  • 3 in conversation