I have a usecase which is as follows.
I am counting no of db hits per second in application in kibana.
I want to compare the db hits per second of last 15 mins with that of db hits which was 7 days ago in same time.
If current time is 1st october 4.40P.M.
Then i want to compare the current db hit count with db hits on 24 th sept.
How is it achievable.
I tried with date range query but i am unable to finally achieve it.
Basically i need a comparison graph of last 15 mins with the same 15 mins 1 week ago.
What i did is something tedious.
First create a time field by splitting the timestamp. Name as field-time.
Now in x axis take the field term and take max field 50.
use custom metric and take max timestamp(the timestamp field that you choose during index creation).
then subaggregate on date-range.
in the range field you give the time you want to compare.
in one u give now-h to now
in the other you give now-25h to now-24h.
try and let me know the result
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.