Splunk Search

How come my trendline is not displaying on a single visualization?

jaj
Path Finder

How can I get trendline data to show up on a single visualization using the following query? The results come back fine as timechart count, but the panel won't display:

index=ui_logs source="*.logs*" | search ("Start Transaction" "status=COMPLETE")  OR ("Start Transaction" AND "status=FAILED") |
stats count(eval(searchmatch("Start Transaction") AND searchmatch("status=COMPLETE"))) as successCount 
      count(eval(searchmatch("Start Transaction") AND searchmatch("status=FAILED"))) as errorCount |
eval totalCount = successCount + errorCount |
timechart count as totalCount

I would like to map the results to a single trendline display as such:
alt text

0 Karma
1 Solution

niketnilay
Legend

@jaj your command with stats is removing _time field which is required by timechart

index=ui_logs source="*.logs*" search ("Start Transaction" "status=COMPLETE")  OR ("Start Transaction" AND "status=FAILED") 
| timechart count(eval(searchmatch("Start Transaction") AND searchmatch("status=COMPLETE"))) as successCount 
       count(eval(searchmatch("Start Transaction") AND searchmatch("status=FAILED"))) as errorCount 
| eval totalCount = successCount + errorCount 
| table _time totalCount

As stated in one of my precious answers, you can directly use the following after your base search:

  | timechart count as totalCount

PS: move your | search ... to the base search as in answer above since the SPL in your question is asking for all the results from index and then filtering required data.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

0 Karma

niketnilay
Legend

@jaj your command with stats is removing _time field which is required by timechart

index=ui_logs source="*.logs*" search ("Start Transaction" "status=COMPLETE")  OR ("Start Transaction" AND "status=FAILED") 
| timechart count(eval(searchmatch("Start Transaction") AND searchmatch("status=COMPLETE"))) as successCount 
       count(eval(searchmatch("Start Transaction") AND searchmatch("status=FAILED"))) as errorCount 
| eval totalCount = successCount + errorCount 
| table _time totalCount

As stated in one of my precious answers, you can directly use the following after your base search:

  | timechart count as totalCount

PS: move your | search ... to the base search as in answer above since the SPL in your question is asking for all the results from index and then filtering required data.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

jaj
Path Finder

@niketnilay thank you again!

0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...