Configurable page size, number of pages, and field trim for doc table

elastic / kibana

Your window into the Elastic Stack

https://www.elastic.co/products/kibana

Other

19.78k stars 8.19k forks source link

Configurable page size, number of pages, and field trim for doc table #4060

Closed elvarb closed 1 year ago

elvarb commented 9 years ago

When creating a dashboard in Kibana4 and I want to have a list of events the only option I have it to include a search. The options on that search panel are none. It will display 50 events per page and if the panel is smaller than the 50 events it will show a scroll bar for that panel.

In Kibana3 you could set how many events are shown per page and how many pages. You could also configure the trim count, which is very handy when you have lots of different length of fields and want to have it short or have long fields and want to see all the data.

I have in Kibana3 many dashboards that only show maybe less than 10 events per page because the only relevant ones are the latest events.

On the other end of the spectrum I'm now creating a reporting dashboard that needs to show every event regardless if its 0 events or 1000 events. This will then be saved with PhantomJS and sent to people who do not have direct access to Kibana.

rashidkpc commented 9 years ago

I could see this being implemented on the doc_table directive by adding a spy panel with options in it. I suppose the options here could be persisted to the search source.

The concrete asks I see in this are:

Configurable page size
Configurable number of pages
Configurable field trim length.

elvarb commented 9 years ago

Maybe it could also be added as a visualization type. That way there is a clear segmentation between the search and what you can add to a dashboard.

stacey-gammon commented 6 years ago

I think this is more a @elastic/kibana-discovery feature than a dashboard feature. I think you would just need to add more customizations in the embedableConfig, like pie chart colors, and column order is stored.

ravitandur commented 5 years ago

which version of kibana having the requested feature? As I can see, it seems to be some short circuit, people are referring this issue in another and closed that issue.

rayafratkina commented 5 years ago

This is currently an enhancement request in our queue. There are no specific version plans or timeline for implementation at this point.

rickreesrr commented 5 years ago

I'd very much like to see the 3 features listed by @rashidkpc added too to enhance the dashboard capabilities. Now that saved searches can be exported from the dashboard to CSV, we're being enticed to use them but the performance hit is a turn-off.

Skoetting commented 4 years ago

Any news on this? I really need this feature!

fbaligand commented 4 years ago

Hi there,

Waiting that very helpful feature, you can use enhanced-table community plugin, that includes a "Document Table" visualization, to visualize simple documents as table, with custom column name, custom document count per page, custom total documents listed, and enhanced features like filter bar and computed columns.

https://github.com/fbaligand/kibana-enhanced-table

vivekkarne commented 4 years ago

mkoertgen commented 4 years ago

Would be very helpful indeed. +1

federicobertoldi commented 3 years ago

In addition to the lack of possibility to set a limit to the returned documents of a saved search inserted in a dashboard, as a web developer I find it absurd that pagination is performed client-side and not server-side. The request should provide the results of the first page and subsequent ajax requests should be executed on the request of subsequent pages.

michael-lh commented 3 years ago

upvoting

j-meyer94 commented 3 years ago

upvoting +1

could really use that for our use-cases

ramadasv commented 3 years ago

upvoting +1

paddy-bedraggled commented 2 years ago

Upvoting +1

formalist commented 2 years ago

Upvoting +1

jughosta commented 1 year ago

Hi @elvarb, Thanks for your suggestions! The requested functionality was implemented and we have plans on further improving UI/UX and performance in the following months.

What is available so far:

It's possible to set a default number of max loaded documents via discover:sampleSize setting on Advanced Settings page
With the new Document Explorer view you can configure Row height and this configuration will be persisted for that saved search (Added in v8.1 via https://github.com/elastic/kibana/pull/122087)
A saved search can also persist a custom configuration for Rows per page or the default Rows per page from discover:sampleRowsPerPage setting will be used (Added in v8.4 via https://github.com/elastic/kibana/pull/135726)

jughosta commented 11 months ago

From 8.12 it will be possible to configure sample size per saved search panel on dashboard https://github.com/elastic/kibana/pull/157269