Splunk Search

How to edit my timechart search to display time on the x-axis and duration on the y-axis?

HCadmins
Communicator
eventtype=cv "Source Client"=* "Destination Client"=slc-p-res* OR dab* Duration=* | convert ctime(_time) | convert dur2sec(Duration) AS Durationsec | eval Durationhrs=round(Durationsec/60/60,2) | fields - "Destination Client" | table _time Durationhrs 

Returns a beautiful table with time and duration in hours.

I want to have a line chart that shows time as the X axis, and duration as the Y axis, however

eventtype=cv "Source Client"=* "Destination Client"=slc-p-res* OR dab* Duration=* | convert ctime(_time) | convert dur2sec(Duration) AS Durationsec | eval Durationhrs=round(Durationsec/60/60,2) | fields - "Destination Client" | timechart span=1d sum(Durationhrs)

Returns only the time stamp, and the Duration column is empty.

What am I doing wrong?

0 Karma
1 Solution

niketnilay
Legend

Take out convert ctime(_time) from your search

Timechart expects the time field in epoch format not ASCII.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

0 Karma

niketnilay
Legend

Take out convert ctime(_time) from your search

Timechart expects the time field in epoch format not ASCII.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

0 Karma
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!