Splunk Search

Drop down menu loses trend line

DTERM
Contributor

I have the following code that works fine in a view and chart...

<searchTemplate>index=MyApp Alert_Type&lt;2 earliest=-2w GroupName!="No Support Group"| dedup Serial | timechart count as yvalue | `lineartrend(_time,yvalue)` | timechart sum(yvalue) sum(newY)</searchTemplate>

When I add a dropdown option for the groupname, the chart loses the linear trend. Here is the code that does not work..

<searchTemplate>index=MyApp Alert_Type&lt;2 earliest=-2w GroupName=$GroupName$ | dedup Serial | timechart count as yvalue | `lineartrend(_time,yvalue)` | timechart sum(AlertCounts) sum(newY)</searchTemplate>

How do I keep the trend line with the drop down menu? Thanks in advance.

Tags (1)
0 Karma

HiroshiSatoh
Champion

This right?
・・・・・ | timechart sum(AlertCounts) sum(newY)
sum(AlertCounts) -> sum(yvalue) ?

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...