how to put a loop in my expression?

[#1]

Hello everybody,

I need your help for a bar chart where i need to see everything over 100%.

I have tried to check the box "relative" and it's close to work but the problem is:

If I select only one of my categories then this category is well over 100% (f.e.g. 56% True and 44% False)

But if I want to see all my categories then the total is over 100% but each one of the category is over 25%, 5% etc...

That's why I wanted to put a loop "foreach" like "foreach categories, do the expression" but it seems like I can't put a loop in an expression.

I'm not sure to be clear in my request. So I link to pictures: What I have and what I need

[Clever_Anjos]

Would you mind putting your expression?

Let´s play with some SUM(total <category> values)

[Clever_Anjos]

Please find attached an example

[#4]

I have a: count(values).

I just tried the SUM(total <category> values) and also count(total <category> values) but none of them is working..

And I can't open your attached example because I'm using a personal edition.

[Clever_Anjos · Accepted solution]

Try using

count(values). / count(total <category> values) and format your number as percent

[#6]

It almost work. But everything is reaching 12.5% like (CO2: 8.5% and 4.5% / Gas: 11% and 1.5% etc...)

How to make it reach 100%??

But thank you for the answer!

[Anonymous]

try  it.

Sum(fieldValue)/Sum(Total <Category> fielValue)

or

Sum(fieldValue)/Sum(Total fielValue)

and  Properties--Tag Number  Select

Regards!

[#8]

Still at the same point.

See what I get. I'm getting close but still not solved.

[#9]

I have 8 categories and that's why everything is over 12.5% and not 100%. I still have my "loop" problem. I need somewhere to put this foreach loop isnt it?

[Anonymous]

you can  share  your  app please