Here is my dql, but this seems to be not a valid timeseries, I am not able to enable davis for anomaly detection/forecast. Please help or suggest.
timeseries sodduration = max(`com.dynatrace.extension.sql-oracle.totaldurationmillis`), by: {tasknameshort, start_time,db.name },interval:24h
|filter {db.name == "DB" AND tasknameshort !="a"}
| summarize by: { start_time }, { maxDuration = toLong(max(toDouble(sodduration[])/60000)) }
|fieldsAdd start_day = toTimestamp(concat(substring(start_time, from: 6, to: 10),"-",substring(start_time, from: 0, to:2),"-", substring(start_time, from: 3,to:5)))
|fieldsRemove start_time
|summarize {totalDuration=sum(maxDuration[])} ,by:{start_day}
I am able to see the results, but not able to enable the davis analysis.
