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

Elastic Stack Kibana
1

Hello,

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.

2

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