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
