Splunk Search

How to create a timechart with a time field?

Marco_Develops
Path Finder

I'm trying to make a time chart where it uses the time value specified in my table.  Rather than the default _time value.

Currently I'm trying something like this:

base search
|eval Failures = if(STATUS ="Failed",1,0)
| timechart sum(Failures) by TIME

DATE TIME  SYSTEM Failures
03/01/2022 12:00 Development 10
03/01/2022 13:00 Development 2
04/01/2022 15:00 Development 3
05/01/2022 18:00 Development 8

 

 Any suggestions help :-).

 

Thank you,

Marco

Labels (3)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
base search
| eval Failures = if(STATUS ="Failed",1,0)
| chart sum(Failures) by TIME

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
base search
| eval Failures = if(STATUS ="Failed",1,0)
| chart sum(Failures) by TIME
Get Updates on the Splunk Community!

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...