xeraa
I actually ended up doing something a bit different
- I created a regular
Transform
that calculates today's inventory - I ran a simple
Watcher
that copies those entries to a newData stream
. See this Q\A for reference. It adds the inventory date as an extra field to each document, hence creating an inventory history index. - I then used
ES|QL
to query the inventory index.
So at this point, supporting ESQL
to create that inventory data stream would be a cool addition, but no desperate measures needed to be taken!
Thanks