How to create a bar chart to show the completion status in Green color if it is Yes and Red if it is No? Please help me

[Anonymous]

Greetings all,

For the above table i want a stacked bar chart with color green if comp_status is yes and red it is no. Can someone help me with that please?

[Anil_Babu_Samineni]

You can use BG color like from expression expand.

If(comp_status='yes', Green(), If(comp_status='no', Red()))

[Anonymous]

Hello Anil,

Thank you for the reply. I would like to know what expression should i mention in the expression tab of the chart. I took comp_status as Dimension

[trdandamudi · Accepted solution]

Hope the attachment will help:

[Anil_Babu_Samineni]

That's based on your business. In your table you have 3 columns. Which is your dimension and measure that you have to decide. But, Try Count(subject) or Sum(cycle)

[Anonymous]

Thank you very much

[trdandamudi]

You are welcome.