Describe the feature:
Currently when doing a table visualisation with a terms buckets the result will look something like this
+-------+---------+-------+
| topic | success | count |
+-------+---------+-------+
| foo | true | 3 |
| foo | false | 6 |
| bar | true | 5 |
+-------+---------+-------+
It would be nice if this could optionally be displayed as:
+-------+--------------------+---------------------+
| topic | count.success.true | count.success.false |
+-------+--------------------+---------------------+
| foo | 3 | 6 |
| bar | 0 | 5 |
+-------+--------------------+---------------------+
This becomes even more pertinent when there are multiple buckets which can quickly explode the number of lines, as this simple example would normally create 6 lines:
+-------+---------+--------+-------+
| topic | success | colour | count |
+-------+---------+--------+-------+
| foo | true | red | 2 |
| foo | true | green | 1 |
| foo | false | red | 2 |
| foo | true | green | 4 |
| bar | true | red | 3 |
| bar | true | green | 2 |
+-------+---------+--------+-------+
but could also be displayed in just 2 lines:
+-------+--------------+---------------+------------+--------------+
| topic | success.true | success.false | colour.red | colour.green |
+-------+--------------+---------------+------------+--------------+
| foo | 3 | 6 | 4 | 5 |
| bar | 5 | 0 | 3 | 2 |
+-------+--------------+---------------+------------+--------------+
Obviously some granularity is being lost in this condensation of the data, and with high cardinality data it could lead to many many columns, but for many use cases this is not necessary, and it would be a major advantage to be able to reduce the number of rows being displayed.
Describe the feature:
Currently when doing a table visualisation with a terms buckets the result will look something like this
It would be nice if this could optionally be displayed as:
This becomes even more pertinent when there are multiple buckets which can quickly explode the number of lines, as this simple example would normally create 6 lines:
but could also be displayed in just 2 lines:
Obviously some granularity is being lost in this condensation of the data, and with high cardinality data it could lead to many many columns, but for many use cases this is not necessary, and it would be a major advantage to be able to reduce the number of rows being displayed.