Get dimensions for a metric when metric has no data

susmita_k — Mon, 19 Aug 2024 07:19:40 GMT

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

Re: How to get dimensions for a metric when metric has no data

Esam_Eid — Sun, 28 Jul 2024 12:46:13 GMT

Hi @susmita_k ,

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

topic Re: How to get dimensions for a metric when metric has no data in Extensions

Get dimensions for a metric when metric has no data

Re: How to get dimensions for a metric when metric has no data