Take/calculate value from dashboard

[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…