Help needed creating a trending chart

[#1]

Hi

I have the following data:

and I would like to have it displayed like this:

You know: rating on the left, timeline below and the trending. I want to show the changes of rating over time. I tried to create a trend chart but don't know what dimmensions and expressions to use. Please take into consideration there is a long list of clients. Probably all lines will be showed in the same chart, but that's ok.

Thanks for any help provided.

[sunny_talwar · Accepted solution]

Something like this?

Dimension: reporting_date2

Expression: =Match(rating, 'Red', 'Yellow', 'Green')