The table format is -
Date | Id | Other data
22/03/22 | 391 | other data 1
21/04/22 | 391 | other data 2
22/03/22 |310| other data 3
19/05/22 | 310 | other data 4
10/02/22 |310| other data 5
.
.
.
I want to add a column in vizlib chart that would give me 'other data' based on a given id number and max date corresponding to that id number.
i.e for id =391, I should be getting 'other data 2' as a result since the maximum date corresponding to this id is 21/04/22.
for id = 310, I should be getting 'other data 4' as a result since the maximum date corresponding to this id is 19/05/22.
