Data Table adding certain field causes strange behavior

Elastic Stack Kibana
14

maybe you haven't pressed on the image to see to full content

Indeed, I didn't realize the image was truncated. Thanks for pointing that out.

Here's an example of the same idea, albeit with different data. As you can see, each collection, grouped by user agent and then by file extension, shows an average byte value. This should be what you see as well.

25
251489×1212 134 KB

I missed earlier that you are dealing with a single document. That's actually not how you'll want to index your data in elasticsearch, as it doesn't break up the values on a single document. The easiest solution is to index each one of the items in layers.elem as a separate document, denormalizing the data to include the other information in the main document, like name and audio_profile, etc.

If you're trying to track these values over time, say as part of a compilation process, you'll also want to add a time field to the individual documents, so that it can group them up by time. If this isn't time-series data, you'll want to have some other unique value to group on. Maybe name is that field, maybe not, I don't know your data well enough to say.

Your data might end up looking like this when you index it, each item being a new document:

{
  "name": "HLS2",
  "audio_profile": {
    "bandwidth": "0",
    "name": "AUDIO_PASSTHROUGH",
  },
  "fragment_length": "2",
  "live_sliding_window": "3",
  "bandwidth": "1992294",
  "-id": "0",
  "enc_id": "131332",
  "el_name": "1.9"
}

{
  "name": "HLS2",
  "audio_profile": {
    "bandwidth": "0",
    "name": "AUDIO_PASSTHROUGH",
  },
  "fragment_length": "2",
  "live_sliding_window": "3",
  "bandwidth": "1677721",
  "-id": "1",
  "enc_id": "108209",
  "el_name": "1.6"  
}

...

This will allow you to group by name, then el_name, and then see the average bandwidth for each group.