Customer Unable to load Security Dashboard at Group Level

When my customer views the Security Report they receive the following error:

Error fetching the vulnerabilities over time. Please check your network connection and try again.

This is likely due to the large number of groups, subgroups and associated projects. Customer has stated that this error happens for most groups and subgroups and will only load for smaller groups.

Relevant ZenDesk Ticket

Customer Colab Issue

Proposed implementation plan

• database Create a new table to store the statistics for each group(this will store the statistics for direct projects and not accumulate)
• backend Adjuste the existing cronjob to write into this new table
• database Run a background migration to backfill the data for this new table
• database Change the GraphQL API to use this new table for group-level queries