two levels of sum in a bar chart - _ForAll_ _ByGroup_

[ANLYNG]

Hi,

I want to show column percentages in a bar chart that comprises of two aggregation levels - en per unit and one for all units. I want to show it in the same bar chart but with different colors.

However I can only get the summed values to be shown on each unit. I want to show it only onece on the bar chart.

See the image below

Do you have any ideas how to solve it? we are running SAS VA 7.3 right now. But soon we will upgrade to 8.3.

Below is first the graph I want and below is the graph i made in sas VA.

I hope you can help  - thanks in advance.

Want:

[PetriRoine]

Hello @ANLYNG 

I didn't quite understand what exactly did you want to:

a) highlight the category closest to the "average of all"

b) highlight the "median of all" category

c) add a new category (and bar) which represents "avg/median of all".  Needs to be logically correct place considering sort order.  This would mean data needs to be added to create that extra category.

I don't think a) or c) are doable.

a) VA doesn't have closest value functionality.

c) in VA one can't add data per se f.ex. . creating new categories split data.

While playing around with this I wondered would it be ok just to show the aggregate for all units as a line instead of bars?

With VA8.x you could of course utilize D3.js charts which might help you in this matter.

Best regards,

Petri