0Max Group Limit Error
Hi Team,
We are getting below issue when running a dashboard with an aggregated visualization. We tried changing the Max group size value till max of 7.5 mil but it is throwing us the same error. Do you have any server side engine.properties parameter setup to overcome this issue.
Thanks,
Srinivas
-
Srinivas -- are you sure that your aggregated visualization doesn't actually have more than 7.5M "buckets" based on your grouping dimension(s)? You can create a simple metric insight to count the number of distinct buckets to see what this number really is.
-
Hi Dan,
Thanks for your response. Yes, we do have the distinct values which are than 7.5 M. My developer is trying to create a dashboard with distinct values on grouping dimensions. What if we have more than 7.5M buckets is there a way we can produce the output even if it is more than that.
-
Srinivas 7.5M rows on any insight is too much for a human to consider anyway, so consider adding a filter for your insight to only show the most relevant records (last 30 days, top 200 customers, etc., or whatever makes sense for your use case). This will also drive better performance because asking the analytics service to compute 7.5M buckets is a CPU intensive task.
-
-
Hi Dan, Thank You !
We had tested the distinct values with all the grouping dimensions and we see only 265526 recs. We applied the required filters and the count is coming as said. Why are we getting the error even we have less records. Also we tried changing the value of the max groups, but it is giving us the same error.
error: "The result is too large and exceeds the max group limit. Note: The calculation of the max group includes also all the grouping cells that are needed for building the insight as well."
-
Srinivas What type of insight is it? Is it a pivot table?
-
Srinivas what type of filter are you using? Aggregate filter or record filter? It would need to be a record filter.
-
Dan Brock Record Filter
-
-
Hi Dan,
Its an aggregated Visualization.
Thanks,
Srinivas
-
Dan,
Thank You for looking into it. We updated the filters and updated the max group parameter value and page size value, which had fixed our issue and now we are able to see the data coming.
Thanks Again !
Srinivas
