Help with visualization and data prep.

[Anonymous]

Hello all,

I have a table which looks like below data set.

One Article can have many products based on date and Country.

As you see Product B07CN9D18C has a creation date after creation date of B0777J1KP1, so any rating after this date for B0777J1KP1 should be ignored.

Artikelnummer	Product	Country	Product_Coutry_Art	Aktiv	New rating	Creation_date	Rating_Date
10029872	B0777J1KP1	DE	B0777J1KP1DE10029872	0	2	07/11/2017	13/12/2017
10029872	B0777J1KP1	DE	B0777J1KP1DE10029872	0	3.1	07/11/2017	18/12/2017
10029872	B07CN9D18C	DE	B07CN9D18CDE10029872	0	0	25/04/2018	25/04/2018
10029872	B0777J1KP1	DE	B0777J1KP1DE10029872	0	3	07/11/2017	26/04/2018
10029872	B0777J1KP1	DE	B0777J1KP1DE10029872	0	2.7	07/11/2017	29/01/2019
10029872	B07MCKXF9X	DE	B07MCKXF9XDE10029872	0	5	11/01/2019	25/02/2019
10029872	B07MCKXF9X	DE	B07MCKXF9XDE10029872	0	2.9	11/01/2019	09/05/2019
10029872	B07MCKXF9X	DE	B07MCKXF9XDE10029872	0	2.6	11/01/2019	16/07/2019
10029872	B07MCKXF9X	DE	B07MCKXF9XDE10029872	0	2.4	11/01/2019	05/08/2019
10029872	B07MCKXF9X	DE	B07MCKXF9XDE10029872	0	2.6	11/01/2019	23/08/2019
10029872	B07YSD8DMF	DE	B07YSD8DMFDE10029872	1	0	07/10/2019	07/10/2019

I need the visulization like below:

[v-diye-msft]

Hi @Anonymous 

I can't see your expected results, could you please repost it?

Also, please kindly explain "any rating after this date for B0777J1KP1 should be ignored." thanks!