Populating RAG status based on Date

[sayadutt]

Hi,

I have a requirement where I need to plot the RAG status (Red, Amber, Green). Below is how my data look.

Team	Date	RAG Status
A	8/19/2019	Green
B	8/19/2019	Green
A	8/20/2019	Green
B	8/20/2019	Amber
A	8/21/2019	Red
B	8/21/2019	Red

Based on this, I need to populate like below.

[Arthur_Fong]

There you go:

Qvw attached for reference. 

Refer to Chart Properties>Expressions>Expand the '+' and look at Background and Text Color.

Thanks and regards,

Arthur Fong

[Arthur_Fong]

Attached is a better way to show your result without Team show as null value: 

Do take a look on the logic at script level.

Thanks and regards,

Arthur Fong

[sayadutt]

Hello, 

The Edit Script has more tabs. 

Do we need these many tabs?

[Arthur_Fong · Accepted solution]

You may discard the tabs right after the exit script.