How to display unique count with latest value in Kibana

zizou_elk · August 24, 2020, 1:27pm

Hello All, Heeelp please

whenever logistic partner update the order status then new status is pushed into elasticseach.

Now every order is having multiple enteries with order status like "ORDER CONFIRM" , "APPOINTMENT SCHEDULED" , "OUT FOR DELIVERY" etc..

Problem arise when i need to see how many order are in which status. Total Order Count is 2, but in order status i get total count 4. because it count older values too. as you can see in attached screenshot.

I'm using TopHit to show the latest and actual status for each id ,and it works perfectly , but when i use a filter , the table show all status (old and latest).

majagrubic · August 24, 2020, 1:56pm

Hi, I'm not sure I fully understand what the problem is here. Could you provide some more insight into your dataset? How many orders do you have and how many do you expect to see? What do you mean "it count older values too"? And what filter are you using, on what field?

zizou_elk · August 24, 2020, 2:44pm

thanks for your response,
here is schema that explain my essue:

majagrubic · September 7, 2020, 2:56pm

In the visualization, can you click Inspect > View Data > Response? Can you verify the data returned from ES is the one you expect to see?

system · October 5, 2020, 2:57pm

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