Count of orders in a certain state


#1

I have data coming into elastic search throughout the day. Each data consist of an order or an order update. For example: Order A created, Order B created, Order A processed, Order A Shipped, etc...
The state of the order goes from created, processed then shipped.
I have the field order_id and order_status for each document. I want to have a count of the orders that are CURRENTLY in the processed state.
How would I be able to do that? Also I am using Kibana 4.6.4
Thanks!


(Bhavya R M) #2

Unfortunately I don't think you can do this with just one index pattern. Is it possible for you to create another index pattern which will have an update for order_status at the end of the day? Then we can use scripted fields to get processed value and then do a data table viz on it to get the count per day.

Thanks,
Bhavya


#3

Hi thanks for the response!
If data is coming through real time that tells us the status of an order, do you have an idea on how I can differentiate the latest orders to only go into one index? It seems a bit complicated where I would have to tell Order A created to go into the new index but when Order A processed comes in, I would move Order A created to another index and put Order A processed in the new index.


(Bhavya R M) #4

Hi,

This is definitely data modeling question. I will see if I can get help.
If I don't though would you mind asking in ES discussion forum?

Thanks,
Bhavya


#5

Thank you so much! Any help would be appreciative!


(system) #6

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