Kibana: Dynamic range in pie chart for Kibana

[vincentmarian90]

Feature request to make the range in pie chart as dynamic instead of having static values ?

Example:

From : 0 To : Average(Duration)

[weltenwort]

Thanks for submitting a enhancement request. It would be helpful if you could kindly provide a more detailed description of the desired functionality. A drawing or mockup would probably go a long way too :wink:

[vincentmarian90]

Hi Weltonwort,

Thanks for your reply.

Please find the detailed description.

This enhancement request is for Kibana Pie Chart Visualization. For Split Slices bucket, in Range Aggregation, we can specify static numerical values for the Field in "From" and "To" text box.

The current requirement is to specify aggregations like Average, Sum for the Field in "From" and "To" text box.

For example,

Field - duration

From To

1. Average (duration)
   Average (duration). Max(duration)

Thanks

[vincentmarian90]

In the above comment, the space got truncated.
Please find the below which is the desired functionality

Field - duration
From : 0 To: Average (duration)
From : Average (duration). To: Max(duration)

[melvynator]

I think that kind of features will be great not only for Pie chart but as well for other chart like Gauge or Goal where for instance your goal is a ratio of two counts in your indexed data.

[SKumarMN]

+1

[jonhkr]

I have an use case where I want to show a gauge with the approval rate of transactions, in the gauge visualization this would be done like this:
range: 0 to filter(message: "Transaction created") count()
split group: filter(message: "Transaction approved")

But without dynamic ranges I can't do that :(

[burgermannetje]

+1 for scripted variables in/or dynamic ranges
I have a similar usecase, when reindexing from one to another, I made a goal-gauge-visualisation of both indices and how many docs. Setting the upper limit as a variable would be welcome.
I would like to see the Range Max value as a variable, and then define the intermediates as %:
Range 1: 0-25%
Range 2: 25%-50%
Range 3: 50%-75%
Range 4: 75%-Max(script or query of value of desired object)

Or as dynamic ranges: Goal-gauge options: max(script or query of value of desired objects) + # of steps (which will make up the number of ranges on the scale)

Regards,

Jeroen

[giogranda85]

I am currently using 5.6.5 and do not see a way to add a variable as the max value in the gauge visualization.

If this were possible it would make the percentages relevant as there are several use cases where the max value is not static. We have a use case where test results are being aggregated but the number of test ran can fluctuate on a daily basis and thus a static value as the maximum will cause the percentages to be skewed from one day to the next.

@weltenwort Can you please update the label of this to include the gauge, goals, and metric visualizations? Is there an ETA on this enhancement/feature request?

[weltenwort]

I don't have any insights into the roadmap. Maybe the @elastic/kibana-visualizations team has something planned?

[ppisljar]

its currently not on our short term roadmap

[mnaor]

So sad news...I would like to see this feature too.