topic Re: Time format not being recognized as data point in Getting Data In

Time format not being recognized as data point

HCadmins — Tue, 29 Sep 2020 12:12:21 GMT

I have a search with multiple time formats, and the "Duration" time format isn't being recognized when I to a chart. Take a look at the screenshot:

I am trying to overlay "Duration" with "Throughput _GB_Hour", but on the chart Duration is always zero, whereas in the table we can see different time stamps.

My guess is I need to convert this somehow, but I am stuck as to how to make this work.

Here is my search
eventtype=cv "Source Client"=* "Destination Client"=slc-p-res* OR dab* Duration=* "Start Time"=* "End Time or Current Phase"=* "Throughput _GB_Hour"=* | convert ctime(_time) | table _time "Source Client" "Destination Client" "Start Time" "End Time or Current Phase" Duration "Throughput _GB_Hour"

Re: Time format not being recognized as data point

gokadroid — Wed, 28 Dec 2016 17:51:10 GMT

your Duration and Throughput _GB_Hour have different units. One in time and other in real number. What is your expectancy when your are trying to plot them on the same y axis?

Re: Time format not being recognized as data point

HCadmins — Wed, 28 Dec 2016 17:53:28 GMT

I just wanted to overlay the time it takes for a particular backup with its throughput.

Re: Time format not being recognized as data point

HCadmins — Wed, 28 Dec 2016 17:59:20 GMT

Okay, got it!

convert dur2sec(Duration) AS Durationsec | eval Durationhrs=(Durationsec / 60)

Lets me use that duration time as hours, and makes my chart work!

Re: Time format not being recognized as data point

HCadmins — Wed, 28 Dec 2016 18:05:20 GMT

But wait... is this really giving me the hours? Or do I need to do eval Durationhrs=(Durationsec / 60/60)?

Re: Time format not being recognized as data point

gokadroid — Thu, 29 Dec 2016 08:15:28 GMT

Since your duration in hours will be a very small number in comparison to the throughput values which are in 100s or 200s range hence to represent both values on same scale better try to use the log scale to represent the y axis. It can be chosen from the format option of the visualization.
The hour should be eval Durationhrs=(Durationsec / 60/60).