How to do a vulnerability trending dashboard?

[rasty]

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.

[renjith_nair · Accepted solution]

Hi @rasty,

You could use filldown to fill the empty area with last known value

[rasty]

thanks @renjith.nair its working 🙂