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.
Thanks in advance.