The server crashes when we request data. The time-range is very less. Not more than 7 days.
But when checked, the bucket size was set like 29 or more and there are aggregations. And there are multiple visualizations like this in the dashboard.
What do you think an ideal bucket size should be and why? What all should you consider while defining bucket size at time of designing the dashboards?