How to give custom timeframe for the timeseries while writing DQL?

[theharithsa]

Hey Team, 

I have a quick question to the community. How can we add custom timeframe for timeseries query (DQL)? It would help me in creating some workflows for the same. My use case is to create a workflow based on the result of DQL timeseries. 

[theharithsa · Accepted solution]

I found a way for it. It is as similar to the one while fetching logs. 

timeseries by:{jo.nce_code,jo.channel}, {
      nce_count=sum(log.jo.nceCount) 
  }, interval: 1h, from:now()-48h, to:now()-24h