divide by count in a chart disregarding dimension

[#1]

Hello

I have a barchart with this expression

=Count({<FlagDays={'>0'}>} FlagDays)  ---- This give me a total of 15

I then also use FlagDays as an dimension, and then i get the 15 spread out on this dimension.

Now i want to normalize these numbers, så i want to divide the result for each dimension with the total of 15

But how do i do that?

[MK_QSL]

=Count({<FlagDays={'>0'}>} FlagDays)/=Count({1<FlagDays={'>0'}>} FlagDays)

or

=Count({<FlagDays={'>0'}>} FlagDays)/=Count(TOTAL {<FlagDays={'>0'}>} FlagDays)

[rbecher · Accepted solution]

Hi Thomas,

have you tried:

=Count({<FlagDays={'>0'}>} FlagDays)  / Count(TOTAL {<FlagDays={'>0'}>} FlagDays)

- Ralf