Auto Extend Range not working at all

[Mal4ozo]

Kibana version: 6.2.2

Elasticsearch version: 6.2

Server OS version: Ubuntu 16.04.4 LTS

Browser version: Firefox Quantum 59.0.2

Browser OS version: Firefox Quantum 59.0.2

Original install method (e.g. download page, yum, from source, etc.): apt-get

Describe the bug: In Visualization tab, visualization type: (Gauge and Goal) , options > Auto Extend Range (check/uncheck), this feature is not working. The range is not updating according to any type of data.

Steps to reproduce:

1. Create Metric with aggregation : "Unique Count"
2. Field : "sysloghost.keyword"
3. Switch to Options and check: "Auto Extend Range"

Expected behavior:
Ranges option should update accordingly to total number of hosts. But it is not doing anything. Range wont change from the predefined range of 0-50, 50-75, 75-100.

Screenshots (if relevant):

Errors in browser console (if relevant):
unable to load ace/lib/es5-shim (not usre if relevant)
Provide logs and/or server output (if relevant):

Any additional context:

[timroes]

I guess this might be a confusion around the "Auto Extend Range" feature. If you enable it, the configured ranges will stay exactly the same. The difference is the following:

Auto Extend Range disabled

If the value within the chart is higher than your highest range, it will just "clip" the value, i.e. it will paint the gauge fully, and you won't see any difference between that and if you just had the maximum value, i.e. in your range example (0-50, 50-75, 75-100), all values above 100 will look exactly the same.

Auto Extend Range enabled

If you now have a value outside your ranges, the high value will still be drawn with the full chart, but it will scale the "range colors" inside of the gauge appropriate, i.e. if you draw the value 200, your color ranges will now only cover half of your chart.

An example in screenshots:

Without that option enabled:

With that option enabled

You can see that the color scale now ends at around 200 in your chart, and your chart is not just clipped at the maximum value anymore.

Was this confusion the cause for that issue?

[Mal4ozo]

Hello, it was kinda confusing at first but thank you for explaining it. Since this feature does not do what I expected it to do, is there any other options that would allow me to dynamically change the "Gauge's" max value according to data?
Allow me to explain:
Kibana logs all logs and filters all the information for unique data. Once unique data is gathered a total number of "machines/hosts" is available to us.
These hosts also send another kind of data but not all of them.
What I need is the percentage of (unique)hosts / (unique) messages = % of total hosts affected.
Is this possible? Thank you very much.

[timroes]

What you are trying to achieve is rather a use case for bucket script aggregations. These allow dividing bucket results by each other. Currently only the Visual Builder supports these bucket and your configuration could look as follows:

Replace the hosts and agent fields with your hosts and messages fields. If you want to filter that still for a specific data, go to the "Panel Options" tab and write any query into the "Panel Filter" box to filter it down.

Supporting Bucket Script in all non-experimental visualizations can be tracked in #4707

[Mal4ozo]

Hi Timroes, thank you for your response. The data you have provided are helpful unfortunately only to some extent. I can not select "Bucket Script" because it is not available as an option. Do you have any idea why is this happening? I updated Kibana and elastic-search this morning to the latest version. Could that be the issue or do I need to download some additional packages? Thank you very much.

[timroes]

The option itself has been renamed several times, unfortunately. Depending on which Kibana version you are using, this might still be named "Calculation" instead. But it will behave the very same.

[Mal4ozo]

Thank you. Found it.