topic Re: How to add trend line in saved search in Dashboards & Visualizations

How to add trend line in saved search

aditsss — Fri, 26 Feb 2021 03:29:49 GMT

Hi Everyone,

I have one panel which consists of saved search.

The query is below:

|savedsearch "splunk_data_last_24_hours"

<panel>
<single>
<search>
<query>|savedsearch "splunk_data_last_24_hours"</query>
<earliest>$earliest$</earliest>
<latest>$latest$</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="colorBy">value</option>
<option name="colorMode">none</option>
<option name="drilldown">none</option>
<option name="numberPrecision">0.00</option>
<option name="rangeColors">["0x53a051","0x53a051"]</option>
<option name="rangeValues">[0.175]</option>
<option name="refresh.display">progressbar</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trellis.enabled">0</option>
<option name="trellis.scales.shared">1</option>
<option name="trellis.size">medium</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="underLabel">Splunk Data - Last 24 hours</option>
<option name="unit">GB</option>
<option name="unitPosition">after</option>
<option name="useColors">1</option>
<option name="useThousandSeparators">0</option>
</single>
</panel>

How can I add trend here.

Can anyone guide me on this.

Thanks in advance

Re: How to add trend line in saved search

ITWhisperer — Fri, 26 Feb 2021 07:56:33 GMT

What does your saved search return?

Re: How to add trend line in saved search

aditsss — Fri, 26 Feb 2021 08:04:41 GMT

@ITWhisperer

This is the base query for saved search

index="abc*" OR index="xyz*" | eval raw_len=len(_raw) | stats sum(raw_len) as total_bytes by sourcetype |eval MB=total_bytes/pow(1024,2)| stats sum(MB)

I want to convert it in trend line.

I want to show this for today.

what changes are required in my query

Can you guide me in that.

Re: How to add trend line in saved search

ITWhisperer — Fri, 26 Feb 2021 08:08:45 GMT

Your saved search only returns a single value with no time component so you don't have anything to trend against

Re: How to add trend line in saved search

aditsss — Fri, 26 Feb 2021 08:12:07 GMT

@ITWhisperer

I want to convert it into trend. I don't want sum now .

Can I used timechart.

Can you guide me on that.

Re: How to add trend line in saved search

ITWhisperer — Fri, 26 Feb 2021 08:15:59 GMT

How have you done trends in the past? What do you want to base the trend on? What time periods do you want?

Re: How to add trend line in saved search

aditsss — Fri, 26 Feb 2021 08:24:41 GMT

@ITWhisperer

I want to use this query

index="abc*" OR index="xyz*" | eval raw_len=len(_raw) | stats sum(raw_len) as total_bytes by sourcetype |eval MB=total_bytes/pow(1024,2)

How can I make this as trendline on time bases

Re: How to add trend line in saved search

ITWhisperer — Fri, 26 Feb 2021 08:34:42 GMT

You know how to do trends as you have demonstrated in the past e.g. https://community.splunk.com/t5/Dashboards-Visualizations/How-to-display-total-counts-for-SUCCESS-AND-FAILURE-in-a-trend/m-p/535703