Calculate a no of rows in the straight table whose color is green and want calculate that count of no of rows in to another graph

[#1]

I have one straight table in which I have red,green and yellow colors of row.

I want to calculate the count of the no of rows whose color is green and the total no of rows.

and want to calculate Count(no of rows whose color is green) / Count(no of rows whose color is green,red,yellow).

And Want to calculate that expression in to the bar chart with the formula

Count(no of rows whose color is green) / Count(no of rows whose color is green,red,yellow).

[settu_periasamy]

Hi,

how do you get the colors (green,red, yellow)? if it is your expression background color, then you can use same expression for your other calculation.

[mightyqlikers]

hi

please post sample data with desired requirement.

[PradeepReddy]

As Settu suggested, use the color coding expression to get the count..