Hi everyone,
I'am trying to do vulnerability trending dashboard but ı have a problem.
Let me explain shortly,
I'm doing this query search, Total vulnerability number (5,680) is true but the increasing number is false because of ;
_time last(totalvalue)
2018-06-17
2018-06-18
2018-06-19
2018-06-20
2018-06-21
2018-06-22
2018-06-23
2018-06-24
2018-06-25 5599
2018-06-26 5626
2018-06-27
2018-06-28 5641
2018-06-29 5653
2018-06-30
2018-07-01
2018-07-02
2018-07-03
2018-07-04 5669
2018-07-05 5680
As you can see at 2018-07-03 there is no any count value. Actually, if not any count, previous count is valid. So, I want to fill this empty areas with last totalvalue. In this case, 2018-06-30, 2018-07-01, 2018-07-02, and 2018-07-03 should be 5653 for example.
Anyone help? 🙂
Thanks.
