Dashboard Metric Explorer

[DBAJames]

I can not longer add SQL metrics to my dashboard.  Despite giving me the metric or using one in user on another dashboard it says doesnt exist:

"errorType": "FIELD_DOES_NOT_EXIST",
"errorMessage": "The field `avg(sql-server.buffers.cacheHitRatio)` doesn't exist.",

[AntonPineiro]

Hi,

Can you show a Data Explorer screenshot?

Best regards

[DBAJames]

what information do you require, just the list of SQL 

[AntonPineiro]

Hi,

Just one metric coming by extension. My point is if you are getting datapoints for some metric by extension.

Best regards

[DBAJames]

Explore Metrics produces this (not working):
timeseries avg(`sql-server.general.userConnections`), by: { `dt.entity.sql:sql_server_instance` }
| fieldsAdd value.A = arrayAvg(`avg(sql-server.general.userConnections)`)
| limit 20

[DBAJames]

SQL Server overview uses(working):
timeseries
connections = avg(`sql-server.general.userConnections`),
by: {`dt.entity.sql:sql_server_instance`}
| sort arrayAvg(connections) desc
| fieldsAdd entityName(`dt.entity.sql:sql_server_instance`)
| limit 20

[sia_h · Accepted solution]

Please raise a support ticket. I’ve encountered similar issues and managed to find a workaround by accessing the classic data explorer, querying the metric, and then opening it in DQL.