Duplicate data in Pie chart

Here is my data set stored in elastic;

index_name: my_data-2020-12-01
ticket_number: T123
ticket_status: OPEN
ticket_updated_time: 2020-12-01 12:22:12
 
index_name: my_data-2020-12-01
ticket_number: T124
ticket_status: OPEN
ticket_updated_time: 2020-12-01 12:32:11
 
index_name: my_data-2020-12-02
ticket_number: T123
ticket_status: INPROGRESS
ticket_updated_time: 2020-12-02 12:33:12
 
index_name: my_data-2020-12-02
ticket_number: T125
ticket_status: OPEN
ticket_updated_time: 2020-12-02 14:11:45

In Summary:

  • Data stored in 2 elastic indices; my_data-2020-12-01 and my_data-2020-12-02
  • Ticket status details of T123 are in both indices

I created a Pie chart to show Ticket count with latest status. But seems ticket T123 is appearing in both status segments in the Pie chart.

How can I show only the latest status?

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