The fields are named date, node, seq_num, and seq_total_time. The date changes with the new reporting node. Seq_total_time represents a transaction time in seconds.
I'm trying to create a mutiseries timechart where on the Y axis is seconds. For the data points I need to avg all of the seq_total_times reported by each individual node for a given seq_num and time. I would have multiple data points for each time slot (1 hour) representing the avg for each seq_num.
I think I need to use a transaction for this - but I'm not sure of how to format the search. Can anyone help to provide a few ideas?