Kibana: Allow multiple column Data Table without metrics

[sjivan]

Kibana version:
4.x, 5.x

Elasticsearch version:
2.x, 5.x

Describe the feature:
A common requirement is to have the ability for a visualization to display a list of unique field values on a dashboard so that one can click on a given value to have quick filters applied. Currently the Data Table supports quick filters but also required a metric and as a result of this the table ends up with a second metric column (like Count) which is undesirable for this usecase.

See forum thread : https://discuss.elastic.co/t/is-it-possible-to-filter-in-kibana-based-on-fields-not-rendered-in-a-visualisation/50256/7

It would be great to be able to model a Data Table with a single column only without requiring a metric field selection.

[sjivan]

I would like to expand this to support the ability of a Data Table even with multiple columns without a metric. Currently one have have a query Search visualization to display various fields but such a table does not support 1) Custom labels for headers and 2) Export to CSV. Data Tables support both so even in a more general usecase of having more than one column, the ability of Data Table to be designed without a metric field would be very useful.

Please let me know if you'd like this request to be logged as a separate feature request.

[jimmyjones2]

Same as #1944?

[thomasneirynck]

this seems identical to https://github.com/elastic/kibana/issues/9621

[thomasneirynck]

@sjivan this is indeed a dupe of #1944 (thanks @jimmyjones2).

As for opening a new issue for your 2nd request (multiple columns), we can continue to use this ticket. I'll adapt the description.

[sjivan]

Thanks @jimmyjones2 @thomasneirynck

I see that #1944 has filed in 2014 and is still open. I'm hoping this feature makes it soon as it's a required use case for several of our dashboards.

Using the workaround of selecting Min Metric on a "bogus" numeric field that has all null values and selecting all the required columns has a serious drawback that it makes the memory usage extremely high. Trying to display such a table with over 10k - 20k rows grows the elastic search memory by several GB and I frequently get OOM errors.

[ghost]

+1

[r3d83ard]

+1

[rabrahamOpti]

Not sure if this is a new option since @sjivan Jan 2017 comment, but the "Unique Count" aggregation is what I'm currently using to achieve this without having to use bogus numerical fields. See this screenshot:

[saramaliazhar]

+1

[Marium-Hassan]

+1

[fbaligand]

Hi all,

You can achieve this feature using enhanced-table plugin :
https://github.com/fbaligand/kibana-enhanced-table

With this plugin, you can hide the "metric" column, and so, have only the bucket columns.