I have a table visualization, where I have total 15 columns, 13 buckets and 2 metric columns.
Table should display around 50k-1lac records/rows.
Pagination is used and table showing 20 rows per page.
For each bucket I need to set different bucket size in order to get all data. bucket size for these columns may range from 1 to >10000. While setting this bucket size for each column getting ‘Too many Buckets Exception’ after certain bucket limit is crossed(even bucket size=100 causes visualization error), due to which not able to show all the records in table.
How do we tackle this scenario. Any configuration related changes needed to show such high amount of data/records?