Count of orders in a certain state

Elastic Stack Kibana
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!

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.

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!

6

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