Create Custom Metric from missing log entries

[detk72]

Hi,

I created a metric "cluster-availability" using Log Monitoring - Metric extraction (mointoring availability of a JDBC database by checking the log entries which are ingested by custom extension/SQL data source). In this way I get the value of availability which I can use in chart.

I want to create a metric that shows the unavailability which would concern the missing datapoints of metric "cluster-availability"

How can I do this?

Thank you very much for your help.

[marco_irmer]

What does your metric data look like during times of unavailability? Are you getting 'null' values or something else?

[detk72]

Hi there,

Thanks for your reply. During times of unavailability it's lacking datapoints, since in this case datapoints are only created when the cluster is available. I could use the default(0,always)

db_cluster.avail:filter(eq("dt.entity.custom:my_db_cluster",CUSTOM_DEVICE-XXXX)):splitBy("dt.entity.custom:my_db_cluster"):default(0,always)

So I could set "0" for the missing datapoint.

Thanks for your support.

[PacoPorro]

You can use Missing data alert parameter.
https://docs.dynatrace.com/docs/shortlink/anomaly-detection-configuration#missing-data

[detk72]

Hi, 

Thanks for your reply. The anomaly detection/missing-data is in place. However additonally the requirement is to display the unavailbity within a chart oder dashboard.

Kind regards,