I have to create a dashboard in a domain where there are orders and parcels. Right now there is an existing index named "parcels". To simplify my question, lets say that this index contains the "parcel_id", "order id" and a flag "is_big_parcel" and "order_date".
I have to create two visualizations
show against time, the order count which contains "big_parcels".
In a given time range, the order count which had 1 parcel, 2 parcels, 3 parcels.. etc
It seems to me that this can be achieved if I had an index "orders" with order_id, order_date, parcel_count, and order_has_big_parcel. But this is an aggregation on the already existing "parcels" index. Is it possible to create such a view based on existing "parcels" index? If not what would be the best way to achieve these visualizations?
for (2) , I'm a little stumped on that. I don't see right away how you could do that with your current index structure. you basically want to count the number of parcels by order-id first, and then count the number of order-ids by that count. That's a two-step aggregation, and we do not expose this into Kibana as-is right now.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.