The order documents include key-value pairs, where the key is the name of a particular order lifecycle status (e.g., "shippedFromCustomer", "ReceivedAtWarehouse", etc.) and the value is a unix timestamp when the order lifecycle status occurred.
In the data table, I would like to break the order lifecycle statuses down into respective rows, and have the columns sum the totality of order lifecycle status occurrences in a particular month. The image below shows the desired table.
It's a bit complicated to do in Kibana with how your data is structured (I think it can be done in Kibana Canvas using ESSQL, but I am no expert on that).
If you can change the data to be like this:
{
"id": ""
"action": "shippedFromCustomer"
"timestamp": 1612204599000
}
Then you do a simple Terms aggregation by the Action field and a Date histogram to split it by month.
The way your data is structured already is pretty much aggregated already and what ES and Kibana do is aggregate data themselves, so you can see why it's difficult to fit already aggregated data.
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.