Dashboards & Visualizations

combining date fields into a single field for charting.

rhuss
Engager

Is it possible to somehow combine the date_year, date_month and date_mday fields into a single date field?

I need to do this for charting purposes.

Tags (1)
0 Karma
1 Solution

ziegfried
Influencer

Yes:

... | strcat date_year "-" date_month "-" date_mday date_str

or

... | eval datestr=date_year."-".date_month."-".date_mday

or

... | eval datestr=strftime(_time, "%Y-%m-%d")

I would suggest to use the last one, as it is possible that the date_* fields are missing from the event.

View solution in original post

justinhart
Path Finder

Try:

| eval full_date = date_year." ".date_month." ".date_mday

You can format that in whatever way you want, the area between " " is the seperator.

This was found under the eval command reference here.

ziegfried
Influencer

Yes:

... | strcat date_year "-" date_month "-" date_mday date_str

or

... | eval datestr=date_year."-".date_month."-".date_mday

or

... | eval datestr=strftime(_time, "%Y-%m-%d")

I would suggest to use the last one, as it is possible that the date_* fields are missing from the event.

Get Updates on the Splunk Community!

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...