I have a search query which gives me the following information in the table:
Device | MsgType | TimeStamp
A |MSG1 | 2016 11 08
Also, I have a kvstore which has for the sake of my question, let us consider the following fields with the following entries:
Device | MsgType |timestamp
A |MSG1 |2016 11 07
A |MSG1 |2016 11 06
A |MSG1 |2016 11 05
A |MSG2 |2016 11 07
B |MSG1 |2016 11 07
What I want to do is compare, how many times, MSG1 has occurred on Device A in the last two days (for 11/6 and 11/7 in the above example). So in the above solution, my resultant table should be the following :
Device | MsgType | TimeStamp | 2DayHistory
A |MSG1 | 2016 11 08 | 2
... View more