Hi!
I have a lookup table with time srings like this: 2013.11 and I want splunk to understand it is a time and make it use it in timechart but can't make it work properly.
Here's a piece of csv file:
"uid",date,"type"
1010174,"2013.11",MIX
1014625,"2013.11",MIX
Here's how I try to do it:
| inputlookup file.csv
| eval date=strptime(date, "%Y.%m")
| eval _time=date
| timechart count
and got nothing
OR
| inputlookup file.csv
| convert timeformat="%Y.%m" mktime(date)
| eval _time=date
| timechart count
Treats all entries like they were in 1970th, so it couldn't parse it and assigned epochtime 0.
Where is the mistake?
Thanks in advance
... View more