Sum of all values of a field

[#1]

Hello everyone,

I am asking your help about how can I automatically doing the count of lines of all the values of a field, to display it by percent.

For exemple, I have my field Code :

And the result is a chart, with the sum of lines with A, lines with B and lines with C, for a total of 100% :

Do you know if it is possible ?

Hope I was understandable.

Thanks !

[yduval75]

Add an expression with Count (YourField) / Count (TOTAL YourField)

[#3]

You can use stacked bar chart. If 'Code' is you only dimension, add dummy dimension before it.

[#4]

Thanks for you responses.

I think I will do that.

Create all the expressions and use the stacked bar.

The only thing is that it will not be optimized when adding new values ​​in the fields.

See you

[santharubban]

try this 100% chart

sum(fabs(COMMENROLL_ENROLLTYPE_GRP_COUNT))
/sum(total <COMMENROLL_ENROLLTYPE_DATE> fabs(COMMENROLL_ENROLLTYPE_GRP_COUNT))