I am using File Beat & LogStash to Collect the logs from various source and indexing the raw logs/CDRs to ES 5.0 and the key purpose of monitoring is the transaction KPIs such as TPS, Latency min wise or so... The aggregation/summary of the KPIs is done by Kibana over detailed logs.
I would need to generate the aggregated KPI historical statistics for reporting purpose in Kibana..
Is there anyway I can run the Queries in ES to collect the aggregated KPIs and store/redirect the output into a KPI Index.
Appreciate if any one can give sample example.