Kibana Data Table to group by fields

[Joseph_Mak]

If I have something super simple like this, a bunch of records with a few fields and a timestamp.
Is there a way to build a Data Table (or some other visualization), grouping by each of the fields?

For example, in the following simple data,
I like to see what are my average for each field, "a","b","c" given a period of time range.
The "bucket" seems to be working for a specific field only as far as I can see.

{
"a":1,
"b":2,
"c":3,
"d":4,
"e":5,
"f":6,
"@timeStamp":"2020-02-03"
}

Formatted JSON Data
{
"a":7,
"b":8,
"c":9,
"d":10,
"e":11,
"f":12,
"@timeStamp":"2020-02-04"
}

[flash1293 (Joe Reuter)]

Not sure whether this is what you mean, but when you are creating the data table, you can define multiple metrics. Simply add one average aggregation for each of the fields you want to show.

The "bucket" aggregation is splitting the rows into 3hour intervals, but you can also omit that if you just want the metric over the whole time.

If you want another visualization could you show how the desired result would look like for your sample data?

[Joseph_Mak]

Ok thank you!