In addition, When you series are missing some values, example, with given result from :
_time A B
2020-04-20 07:15:00 1 1
2020-04-20 07:20:00 2
2020-04-20 07:25:00 3
2020-04-20 07:30:00 5 6
2020-04-20 07:35:00 7
2020-04-20 07:40:00 10 11
The option to "Connect" does not work as expected and connect when using the stack display mode with an aera chart (if not stack, the connect option works like a charm).
You can use streamstats to progapate the last value :
somesearch | streamstats last(*) as *
That would transform your results to :
_time A B
2020-04-20 07:15:00 1 1
2020-04-20 07:20:00 1 2
2020-04-20 07:25:00 1 3
2020-04-20 07:30:00 5 6
2020-04-20 07:35:00 7 6
2020-04-20 07:40:00 10 11
Hopping it will help someone.
... View more