Help Implementing a Complex Kibana Metric in OpenDashboard

Open Source Elasticsearch and Kibana
1

Hi everyone,

I need some guidance on how to implement the following metric in OpenDashboard. For reference, I have included a screenshot from Kibana and the formula I used.

image
image2551×735 70.4 KB

(
  sum(delivery_count, kql='_index : "index1"') +
  sum(home_collection_success_count, kql='_index : "index1"') +
  sum(store_collection_visit_count, kql='_index : "index1"') +
  sum(store_drop_visit_count, kql='_index : "index1"') +
  sum(client_pickup_visit_count, kql='_index : "index1"')
)
/
(
  sum(courier_on_road_minutes, kql='_index : "index2"')
  /
  60
)

I have already tried using the Time Series Visual Builder (TSVB), but I could only add two conditional aggregations, which is not enough for this formula.

Could anyone suggest another method or a workaround to implement this calculation in OpenDashboard?

Any help would be greatly appreciated.

Thank you.

2

Hi @balakrishnan.s.dsrc ,

Did you manage to get this working? You can use TSVB to add multiple aggregations and then use the math aggregation to equate your final result.

Leeroy.

3

Hi @Leeroy,

Apologies for the delayed response. No, I couldn’t manage to make this work. Are you sure we can able to achieve this using TSVB?

I wasn’t able to add more than two conditional aggregations in TSVB.

I might be missing something. If possible, could you help me by providing some screenshots on how to do this?