Splunk Search
Highlighted

search by range & dashboard help

Communicator

i am trying to search by year

i have a field like movie_year ( ex: 1991, 1999, 2000)

and i want make a dashboard which is seperated by 10years

what can i do ?

Tags (3)
0 Karma
Highlighted

Re: search by range & dashboard help

Champion

For example, a search sentence can be made in this way.
・・・・|eval years=substr(movieyear,1,3) + "0'S"

movie
year,years,・・・
1980,1980'S,・・・
1981,1980'S,・・・
1992,1990'S,・・・
1999,1990'S,・・・

I do not know that there is no image dashboard.

View solution in original post

Highlighted

Re: search by range & dashboard help

Communicator

thanks for your help

0 Karma
Highlighted

Re: search by range & dashboard help

SplunkTrust
SplunkTrust

Are looking to group movies by decade? If yes than try this

your search | eval decade=floor(movie_year/10)*10

This will give values like this
movie_year decade
1991 1990
1999 1990
2000 2000
2003 2000

field value which is 10 year apart.