Hi I have been using below query to get average response time for application for duration of a day. Is it possible to group this daily summary by date and view it in dashboard??
SELECT average(duration) FROM Transaction WHERE appName IN (… app…names…) TIMESERIES 1 hour FACET
appNameLIMIT 20 SINCE yesterday UNTIL today