Dashboards & Visualizations

How to add a trend line to a line chart with 2 lines?

joeferranti99
New Member

I have a query that produces a line chart with two plotlines; I would like to add a trend line for each line.

sourcetype=OktaIM2:log (debugContext.debugData.requestUri=/app/office365/xxxxxxxxxxxxxxxxxxxxxxx/sso/wsfed/active OR debugContext.debugData.requestUri=/app/office365/xxxxxxxxxxxxxxxxxxxxxxx/sso/wsfed/passive) AND debugContext.debugData.requestUri=office AND loginName=*
| timechart span=1d count by debugContext.debugData.requestUrialt text

Thanks!

Labels (1)
Tags (1)
0 Karma
1 Solution

to4kawa
Ultra Champion

sample:

index=_internal sourcetype=splunkd_*
| timechart count by sourcetype
| untable _time sourcetype count
| trendline sma5(count) as trend
| xyseries _time sourcetype count trend

try untable and trendline

View solution in original post

0 Karma

to4kawa
Ultra Champion

sample:

index=_internal sourcetype=splunkd_*
| timechart count by sourcetype
| untable _time sourcetype count
| trendline sma5(count) as trend
| xyseries _time sourcetype count trend

try untable and trendline

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...