Pie chart - show last string value of two records with same ID


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?

Test records:
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.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.