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?