I am trying to look at a few apps transactions over a couple of hour period where we had some slowness to work out which of the apps was having trouble.
SELECT average(duration) FROM Transaction WHERE appName in(‘APP1’, 'APP2, ‘APP3’) since ‘2018-08-19 22:00:00’ UNTIL ‘2018-08-19 23:00:00’ FACET name LIMIT 20 TIMESERIES
This is showing a graph with the top 20 transactions with a few nice peaks that we can investigate.
The problem is, the dates I specified are not what I get in the results!
I am seeing on the X axis the times are from 06:00PM to 07:00, and when I hover over the graph the latest time recorded is 18:59 to 19:00!
I’m guessing I need to format the dates in the request maybe?