created below DQL to monitor the Disk with used.percent and disk.avail condition however we are getting below error message.
Could you please help to fix this issue ?
DQL
timeseries { averageDiskU = avg(dt.host.disk.used.percent), averageDiskA = avg(dt.host.disk.avail) }, by: { dt.entity.disk, dt.entity.host, host.name, dt.entity.host_group }, filter: {contains(entityName(dt.entity.disk), "sapdata") and dt.entity.host_group == "HOST_GROUP-B86DECA59DA2RM07" }
| lookup [fetch dt.entity.disk | fieldsAdd component = arrayFirst(tags) ], lookupField:id , sourceField:dt.entity.disk
| fieldsAdd dt.entity.disk.name = entityName(dt.entity.disk)
| fieldsadd averageDiskUsed = toLong(arrayLast(averageDiskU))
| fieldsAdd averageDiskAvailable = toLong(arrayLast(averageDiskA))
| filter averageDiskUsed >= 85
| filter averageDiskAvailable <= 32212254720
| fieldsAdd Priority = if(averageDiskUsed >= 95 and averageDiskAvailable <= 10737418240 , "P1", else:(if(averageDiskUsed >= 90 and averageDiskAvailable <= 21474836480, "P2", else:(if(averageDiskUsed >= 85 and averageDiskAvailable <= 32212254720, "P3", else:"OK")))))
Error message -- The query results in multiple metrics, but anomaly detectors only support single metric
