How do I include other "extended stats" in a data table?

Brian_Frantz · February 22, 2017, 11:44pm

I'm new to kibana and loving it so far, but I'm stuck on something that I think should be simple but can't figure it out.

I'm creating a Data Table on which I want to order the data by the standard deviation of a particular field (and display it, obviously). Unfortunately, choosing the "standard deviation" metric only seems to show the "standard deviation bounds" upper and lower metrics, which isn't really what I want. The annoying thing is if I look at the API response that kibana received when running my query, I can see that all of the extended stats are there, including the standard deviation, variance, etc. But I can't seem to figure out any way to select these instead to show in a data table or order by them.

Please help! How can I choose from all of the extended stats options on a data table? I was wondering if the JSON Input might get me there, but can't find any documentation on what I can put in this field for this metric.

Thanks!

Brian_Frantz · February 23, 2017, 12:37am

So I poked around the code and it appears this metric is defined here:

github.com

elastic/kibana/blob/2f6654bcec1db4f74a673906f5819581b94279ee/src/ui/public/agg_types/metrics/std_deviation.js

import _ from 'lodash';
import AggTypesMetricsMetricAggTypeProvider from 'ui/agg_types/metrics/metric_agg_type';
import AggTypesMetricsGetResponseAggConfigClassProvider from 'ui/agg_types/metrics/get_response_agg_config_class';
export default function AggTypeMetricStandardDeviationProvider(Private) {
  const MetricAggType = Private(AggTypesMetricsMetricAggTypeProvider);
  const getResponseAggConfigClass = Private(AggTypesMetricsGetResponseAggConfigClassProvider);

  const responseAggConfigProps = {
    valProp: function () {
      const details = this.keyedDetails(this.params.customLabel)[this.key];
      return details.valProp;
    },
    makeLabel: function () {
      const fieldDisplayName = this.getFieldDisplayName();
      const details = this.keyedDetails(this.params.customLabel, fieldDisplayName);
      return _.get(details, [this.key, 'title']);
    },
    keyedDetails: function (customLabel, fieldDisplayName) {
      const label = customLabel ? customLabel : 'Standard Deviation of ' + fieldDisplayName;
      return {

This file has been truncated. show original

Is adding options for the other extended stats as easy as creating modified copies of this file and adding them to this folder (and rebuilding, etc.)? I couldn't find documentation on writing new metrics, is there someplace I can look for explanation of how these work and how to write my own (otherwise I can just experiment)? Does this one file also handle the sorting behavior for this value? Or is there already a supported way to do what I want?

Thanks!

lukas · February 23, 2017, 3:50pm

This used to be possible, but at some point the Extended Stats metric was replaced with a single Standard Deviation metric which, as you've pointed out, only gives you the bounds.

I've opened an enhancement request to provide this feature. Please add your feedback and +1 here: https://github.com/elastic/kibana/issues/10533

system · March 23, 2017, 3:51pm

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Kibana Visualize. Lower and Upper Standard deviation Kibana	2	3904	November 26, 2019
Bar charts in kibana missing extended_stats? (4.1 version) Kibana	3	1025	July 6, 2017
Terminlogy used in Standard deviation in timeseries builder in kibana 7.1.1 Kibana	2	698	September 25, 2019
Data Table Related Query Kibana	2	254	May 25, 2020
Sort in a Data Table Kibana	2	3089	July 6, 2017

How do I include other "extended stats" in a data table?

Related topics