I created the following DQL to generate this graph.
It adds and removes fields within the timeframe.
Is there a more efficient way to achieve this?
timeseries req_now=avg(dt.service.request.response_time),timeframe:“2025-11-21T12:00:00+0900/2025-11-21T15:00:00+0900”
| fields interval, req_now
| fieldsAdd timeframe = timeframe(from:“2025-11-14T12:00:00+0900”,to:“2025-11-14T15:00:00+0900” )
| append [
timeseries {req_old=avg(dt.service.request.response_time),timeframe:“2025-11-14T12:00:00+0900/2025-11-14T15:00:00+0900”}
]