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!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...