Wednesday, July 8, 2026

#1152 - OIC Service Metrics in OCI Management Dashboards - suppressing null values

Introduction

I want to have a widget that displays errors by the hour, however, only for hours where I have errors.
So here is my widget in my OCI Log Analytics dashboard -

The dashes naturally indicate no errors.

Let's try out the following in OCI Management Dashboards, i.e. I'm leaving Log Analytics

I see the same dashboards here, the one I'm interested in his the suffix _V2.

I open it and click edit - 

The MQL - MessagesFailedCount[1h]{resourceId = $(params.instance_ocid)}.sum()

Click on JSON
Add the following line - 
"preventFillGaps": true
Click Apply, then check out the result - 

I run a couple of integrations that will throw errors - 

6 errors - 2 each for the following integrations - 

  • async process order
  • child create order
  • sync update order
Back in Management Dashboards - I change the visualisation to Bar Chart - 

Note: I also reduced the time window in the MQL to 1 minute, so I'd see the result immediately.

A big thanks to my colleague Sindhuja B. for the tip!

Note how only 2 of the integrations are visualised - I need to amend the widget configuration - 

I set the series to flowCode.


I cannot set the Series to flowCode + flowVersion, so please note this limitation.

I can now open the dashboard in OCI Log Analytics and see the amended widget -



No comments: