topic Re: Creating a chart based on time values, not epoch time in Splunk Search

Creating a chart based on time values, not epoch time

loatswil — Wed, 20 Sep 2017 21:42:17 GMT

Is it possible to create a chart using time values "4:53:43" vs. converting them to epoch time "1505930393"?

I'd like the Y-Axis to be time (3:41:32) - (6:43:21) and the X-Axis to be a name.

Basically these are race results and I'd like the chart to show the times of each participant. Do I have to convert the time value to a real number?

Thanks!

Re: Creating a chart based on time values, not epoch time

DalJeanis — Wed, 20 Sep 2017 23:49:46 GMT

Currently the vertical axes don't work that way on any of the viz that I'm aware of.

Two possible workarounds:

First, as you said, but divide the epoch duration by 3600 to get hours duration.

Second, flip the axes, where names are along the left, and race duration is the length of the horizontal bar. Change the mouseover to display the HH:MM:SS value.

Re: Creating a chart based on time values, not epoch time

lfedak_splunk — Fri, 22 Sep 2017 00:02:44 GMT

Hey @Ioatswil, if DalJeanis solved your problem, please don't forget to accept an answer! You can upvote posts as well. (Karma points will be awarded for either action.) Happy Splunking!

Re: Creating a chart based on time values, not epoch time

sureshvenkatach — Fri, 30 Apr 2021 14:48:04 GMT

Can you share some sample query over here as I'm working similar kind of requirement. Please someone help on this.