3 Replies Latest reply: Jul 26, 2012 9:07 AM by gabrielh

How to: percentage of whole (x-axis) in chart

Hello,

Considering a columnchart with {A,B,C} as series and {1, 2 ,3, 4} as x-axis.

The measure I'd like would be an count(Y) but as an percentage of [the total count(Y) from whole x-axis for that specific serie]

In other words, if we're looking at an example of A:

X-axis-member:     Count(Y)-measure:          The %-measure I'd like:

1                          25                                  25/52 => 48%

2                          5                                    5/52 => 10%

3                          12                                  12/52 => 23%

4                          10                                  10/52 => 19%

_____

total count(Y) =   52

The results would be different for each serie, as we calculate percentages not against the overall total but for the total of that one serie.

I belive i need a set expression but cant figure out how to do it.

Thank you

• Re: How to: percentage of whole (x-axis) in chart

try like:

count(Y)/count(total Y)

Regards

R

• Re: How to: percentage of whole (x-axis) in chart

Have you tried count(y)/count( total (y)?

Could you maybe upload a qvw file it might be easier to help you.

• Re: How to: percentage of whole (x-axis) in chart

Cheers!