topic Re: How to plot multiline chart with results of different length? in Dashboards & Visualizations

How to plot multiline chart with results of different length?

SkyeCoder — Fri, 02 Jun 2023 16:47:49 GMT

Hi there,

I have a query like this:

message="A" | timechart count AS AA | appendcols [search message="B" | timechart count AS BB]

I want to plot this on the same chart with two lines, AA and BB. But AA have a length of 20 and BB has a length of 60. I believe this is why I am not seeing any line? if so, how can I pad AA with extra 40 zeros so that it is the same length as BB?

Many thanks

Re: How to plot multiline chart with results of different length?

isoutamo — Mon, 05 Jun 2023 11:43:45 GMT

could this solve your issue?

message="A" OR message="B" | timechart sum(eval(message=="A")) as AA sum(eval(message=="B")) as BB | fillnull value=0

r. Ismo

Re: How to plot multiline chart with results of different length?

SkyeCoder — Mon, 05 Jun 2023 12:28:50 GMT

Thanks for your answer, it did not quite work, even though I see how it should really work! I will look into it a bit more

Re: How to plot multiline chart with results of different length?

isoutamo — Mon, 05 Jun 2023 12:31:09 GMT

Let's hope that you could fix it. Please add also needed indexes, source types etc. to your main query to be sure that you (and especially other users) are using correct events. It's not sure that all user have the same default search indexes as you have!