is there an option how to set up a pie chart to show count of last string values, but if there are two records with same ID, count only last one based on timestamp?
record 1: ID: 123, variable: "value_1", timestamp: 14.3.2022@12:00
record 2: ID: 123, variable: "value_2", timestamp: 14.3.2022@13:00
record 3: ID: 456, variable: "value_3", timestamp: 14.3.2022@14:00
There will be value_2 and value_3 in a pie with count of 1.
I tried top hit, but it can be configured only for number, not string.
Thanks for any help.