Hi, I have this table: [image] When I split the rows again with layers.elem.bandwidth all layers receive all bandwidths (instead of just adding a column) also, all rows are being multiplied by the amount of layers. See partial image: [image] Adding data doc example: > { > "_index": "device…

This behavior is actually expected. It has to do with how you are asking Elasticsearch to aggregate the data you have. The order of the aggregations matters, as the data is chunked up in that order. As an example, if you're splitting on "Layer Name", and then splitting again on "Layer Bandwidth", y…

I would like to display each layer with it's bandwidth - not an average of all layers nor any other metric. How can I do that without getting all the sparse values as shown in the image? David

I would like to display each layer with it's bandwidth If you want one value per layer, you have to roll up that value. Otherwise, what would you show as a single value for a given layer? Maybe this is a communication breakdown though... can you give me an example of what you were hoping to see? …

I guess I need to roll up the value, what would be the best way to do it. It depends what you want to see. You're going to take a collection of values and distill them into a single value, what value makes sense in your use case is kind of variable, but if I had to guess, average or max would pro…

Hi @Joe_Fleming , Sorry for not being clear enough. Each name has few layers and each layer has it's bw, I don't want to display a metric of the bw value, I just want to display each layer with it's bw, Please see my example doc attached in the original post. Name 1:N Layer 1:1 BW Thank you.

You want to show some "bw" value for each unique "layer" value, right? If I'm getting that right, the instructions I gave you before were right. Basically, do everything you originally did except for the bandwidth aggregation/bucket, and add one or more "Metric" values for the bandwidth field. Basic…

I tried adding "bw" as a metric instead of a bucket, but then I get the same value (the metric - in the attached image used avg for example) for all layers in oppose to the fact that I wanted each layer to display it original "bw" value. every layer name has a unique layer bw. [image]

Can you expand all the options in the visualization sidebar in Kibana and post some screenshots here? I'd like to see how you're building this... I wonder if it's an order issue. Those values should be different, unless their average value is actually the same (which seems unlikely).

Attached: Metrics [image] Buckets [image] It's an average wouldn't it be the same for all?...

Data Table adding certain field causes strange behavior

Elastic Stack Kibana

davidv (David) January 3, 2018, 4:18pm 5

Hi @Joe_Fleming ,

Attached. I guess I need to roll up the value, what would be the best way to do it.

Appreciate it.

Topic		Replies	Views
How to: display table with multiple aggregations? Kibana	7	2377	May 4, 2020
Aggregate multiple rows fields data in single data Kibana	7	4188	October 12, 2017
Why the order of split rows change the displayed values on Kibana table visualization Kibana	2	1382	January 1, 2021
Data table Visualisation not showing correct result for numeric data Kibana	7	350	February 25, 2021
Time Series metric aggregation Kibana	5	468	April 10, 2018

Data Table adding certain field causes strange behavior

Related topics