Get dimensions for a metric when metric has no data

[susmita_k]

I have an SQL Extension, where the metric has no data, which I am defaulting to 0 in my timeseries. But I also need the device (Instance Name) to pull it in the dashboard. For the scenario when there is no data in my metric, the other dimensions are also null. How can I get the correct value because the device always has value which is the DB instance.

My Timeseries below :

timeseries db_invalid_object = avg(`com.dynatrace.extension.sql-oracle.ally.db_invalid_object`, default: 0), by: { owner, device },nonEmpty: true
| fieldsAdd db_invalid_object = arraySum(db_invalid_object)
| sort db_invalid_object desc

[Esam_Eid · Accepted solution]

Hi @susmita_k ,

have you tried to add :default(0, always) NOT :default: 0