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 

[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