I am new to Kibana and am having trouble creating a desired data table.
In short, I have an index comprising documents representing order lifecycle, similar to the image shown below:
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.
Ultimately I am open to any and all suggestions, even reshaping the documents.
Thanks in advance and preemptive apologies if this is a silly question or doesn't abide by forum norms.