I've got a db query that returns an activity name and then the elapsed time of the activity that I would like to chart
date returned is in the following format
Activity timing
a 0:0:33 (hh:m:ss)
b 0:0:54
c 0:1:23
d 0:0:2
but when I give the query to the chart, it only puts the activities on the x axis.
I figure I need to tell the chart that the timing part of the data set is a timespan, I just don't know how to
Try this:
base search involving dbquery | rex field=timing "(?<h>\d+):(?<m>\d+):(?<s>\d+)" | eval duration = s + 60 * (m + 60 * h) | chart avg(duration) by Activity
Try this:
base search involving dbquery | rex field=timing "(?<h>\d+):(?<m>\d+):(?<s>\d+)" | eval duration = s + 60 * (m + 60 * h) | chart avg(duration) by Activity