search

fbaligand / kibana-enhanced-table

Kibana visualization like a Data Table, but with enhanced features like computed columns, filter bar, and “Split Cols” bucket
Apache License 2.0
305 stars 65 forks source link

Auto interval change in date histogram #324

Closed PunamNaik closed 7 months ago

PunamNaik commented 1 year ago

In below day level date histogram is showing up daywise when a particular month is selected from dropdown. (global time filter is kept last 1 year)

image

But when I change the global time filter to more than 1 year window. It automatically changes the histogram interval from daily to monthly aggregation.

image

Is there any limitation with regards to time on such visuals? Also sometimes I ran into this error "too_many_buckets_exception". My 1st bucket size is 20000. Total buckets are 13. The table takes too long to load. Any points I can reconsider here.

fbaligand commented 1 year ago

Hi,

well, both problems are not tied directly to enhanced table plugin, but more to kibana itself. Kibana (or Elasticsearch itself) limits to 10000 buckets in a aggregation query. And the correction you see in date histogram is not done by enhanced table but by kibana. you can try to set « day » in date histogram configuration. Maybe it could fix or not. if you look at Inspect link, you can view Elasticsearch request and response.