Exec Dashboard - Failing request for summary endpoint

Summary

The summary endpoint request is failing for the current month to date.

On page load we make multiple requests to both the time_summary and summary endpoints for the previous 3 months of data, these seem to be successfully completing, but the final request for data for the month to date (start of current month until today) is failing.

The request fails with the json response message “There is too much data to calculate. Please change your selection.”

Steps to reproduce

1. Navigate to the executive dashboard
2. The request may or may not fail
3. Refresh the page until the request fails

Example Project

• https://gitlab.com/groups/gitlab-org/-/analytics/dashboards

What is the current bug behavior?

The API request fails and data is not loaded

Relevant logs and/or screenshots

Screenshot	Video
	Screen_Recording_2022-12-02_at_11.53.57_am

Solution

Force the execution of the query to be ordered in a way which is more performant. Isolate this to VSA.

1. load the group hierarchy
2. load all projects in the hierarchy
3. load issues by the previously loaded projects + apply the given filters (date range)