topic Re: Timechart, trendline and table in Dashboards & Visualizations

Timechart, trendline and table

fedejko — Wed, 30 Sep 2020 00:37:47 GMT

I am using a timechart and trendline search commands, and then I want to pipe the results into a table and add a field there:

index=xxx sourcetype=yyy some_search_criteria
| timechart span=12h count
| trendline sma10(count) as trend
| table _time count trend sourcetype

In the table I can see all fields populated except for "sourcetype" - they are empty.

But, if I remove timechart and trendline commands, the "sourcetype" field in the table is populated.

How to make it populated while using timechart and trendline?

Re: Timechart, trendline and table

Sukisen1981 — Sun, 19 May 2019 17:26:21 GMT

try this :

| timechart span=12h count ,values(sourcetype)
| rename values(sourcetype) as sourcetype| trendline sma10(count) as trend
| table _time count trend sourcetype

Reasonable to assume you have only 1 sourcetype per event?

Re: Timechart, trendline and table

fedejko — Mon, 20 May 2019 10:16:34 GMT

Thank you, it works. Although I modified it slightly:

Instead

| timechart span=12h count ,values(sourcetype)
| rename...

I did the following:

| timechart span=12h count values(sourcetype) as sourcetype

Regards.

Re: Timechart, trendline and table

fedejko — Wed, 30 Sep 2020 00:38:10 GMT

I have tried the following with another field - src_ip instead of sourcetype.
With "sourcetype" I had only 1 sourcetype per event.
With src_ip I've got more.

They appear in a table one after another, and if I want to exclude IP addresses from "10.*" range - nothing happens, because if in the table, I've got:

10.1.1.1 80.10.20.30 212.123.21.12

and if I exclude 10.* using | search src_ip!="10.*" then nothing appears there, because 10.1.1.1 was among the results.

How to correct it?

Re: Timechart, trendline and table

Sukisen1981 — Wed, 30 Sep 2020 00:36:57 GMT

Hi @fedejko - so this scr_ip has multiple values the output you are referring to probably comes combined together vertically and not horizontally in a single field? Something like this -
10.1.1.1
80.10.20.30
212.123.21.12
If this is correct before the trendline add this code, so your code looks something like this :
| timechart span=12h count values(src_ip) as src_ip

add this
| timechart span=12h count values(src_ip) as src_ip|mvexpand src_ip |rest of your trendline and table commands...
If my understanding is not correct, please provide a screen shot of your as is and to be outputs.

Re: Timechart, trendline and table

fedejko — Mon, 20 May 2019 17:24:59 GMT

Hi,

IPs expand from left to right: https://ibb.co/Bsx3ZFv

After adding what you suggested it messed up my chart: https://ibb.co/8c0YBRj

What I do there is the following:
I use rex to extract an IP address from the beginning of the log
I exclude internal IPs
Plot it on the chart
Introduce new value: threshold - which equals 5 * trend
and the aim of all that is to detect spikes in traffic which are bigger that threshold.

Here's the example of a proper graph: https://ibb.co/r7FQsf7

In the previous graph, the bars would never intersect with threshold line, hence the alert would never fire.

Re: Timechart, trendline and table

fedejko — Mon, 20 May 2019 17:39:21 GMT

Hi,

IPs expand from left to right: https://ibb.co/Bsx3ZFv

After adding what you suggested it messed up my chart: https://ibb.co/8c0YBRj

Here's the example of a proper graph: https://ibb.co/r7FQsf7

In the previous graph, the bars would never intersect with threshold line, hence the alert would never fire.