Take/calculate value from dashboard

[blukit]

Hi guys...

Is it possible to calculate value directly from a dashboard?
The underlying logic of existing metrics kinda complex, so i think it would be more simple if I could take the output for other calculation.

example: (purchase-cashout)/purchase

ps: using version 6.8

[lukeelmers]

Is it possible to calculate value directly from a dashboard?

The short answer is "no" -- you can't do this directly from a dashboard. However, you can achieve this using a TSVB visualization (which can then be embedded in a dashboard).

What you're looking to do is called a bucket script aggregation, which is not yet supported in our standard agg-based visualizations, but can be done using TSVB as shown here. Another more detailed example can be found in this thread:

Weighted Average in a DataTable of Kibana

Hi Henrique, I think solving your problem will be a two-step process. You'll need to create a per-document field for cost * volume, e.g. a field called volumeCost. You could create this field two ways, either by reindexing your data and adding the field with a Painless script, or by creating a scripted field that calculates this value on the fly. The first option is a little more performant when querying your data but the second option might be easier. I think you can create a Timeseries v…

[blukit]

Thanks for the feedback & link.

I've tried 'bucket script' & 'math' aggregation in visual builder, but sometimes it didn't shows data correctly in dashboard (0 result) when i know for sure data exist. But when I edit it, it shows correctly. Any clue to solve this?

[lukeelmers]

@blukit

sometimes it didn't shows data correctly in dashboard (0 result) when i know for sure data exist. But when I edit it, it shows correctly

What do you mean exactly by "when I edit it"? It works after editing the dashboard, or editing the TSVB visualization again?

[blukit]

sometimes during edit/save, other times when I move forward/backward with the time picker

i'm using visual builder:
value count --> cumulative sum --> bucket script