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?
Thanks in advance!