Splunk Search

How to control values of a field relative to the values in the _time field

HattrickNZ
Motivator

I have this search, and this at least gives me some output but not as I would like.

index=_internal sourcetype="splunk_web_access" | timechart count(uri) | eval test=if(_time<="2015-04-29",450,600)

But what I want to do is be able to control the value of the test field relative to the _time field.
For instance, I would like test to be equal to 450 up to this date "2015-04-29" and then 600 afer that.
What is the corerct syntax to do this?

The output of my data looks something like this:

_time   count(uri)  test
2015-04-08  1   450
2015-04-09  1   450
2015-04-10  1   450
2015-04-11  0   450
Tags (2)
0 Karma
1 Solution

ramdaspr
Contributor

_time is actually a timestamp and not the %Y-%m-%d representation so if you do an

eval tcheck=strptime("2015-04-29","%F") | eval test=if(_time<=tcheck,450,600)

and that should work

View solution in original post

ramdaspr
Contributor

_time is actually a timestamp and not the %Y-%m-%d representation so if you do an

eval tcheck=strptime("2015-04-29","%F") | eval test=if(_time<=tcheck,450,600)

and that should work

HattrickNZ
Motivator

thank you!

0 Karma
Get Updates on the Splunk Community!

Index This | Why did the turkey cross the road?

November 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...