Hello Elizabeth!
I'm sorry for your experience and rest assured it's on our roadmap to improve this functionality. Genesys Cloud runs off a true big data architecture model which carries the huge benefit of being able to centralize the infrastructure in a way that allows rapid deployment, cost effective solutions, and centralized management. High level, big data infrastructure achieves this by spreading data across many server nodes and gathering data in strategic chunks.
One immediate drawback to this is gathering wide spans of data at one time like a YTD report increases the amount of "chunks" it has to pull together. When you had a dedicated database on your old solution, even if it was process intensive for the database to pull that data together, it was less impactful in the moment to run that report. It also came with server costs, maintenance costs, internal security teams (or lack of security), lack of cloud access, difficulty to upgrade, etc. There's a reason why the industry is moving on from this model.
All that to say that it's not an excuse. You are correct that the platform should support this and we have a plan in the works. On a shared big data solution, long running jobs that leverage wide spans of data need special consideration to ensure it doesn't affect the platform as a whole. We have two projects in development that will release at the same time to support larger report runs in our exports.
On the backend, we're adding a new API endpoint that will take in a large interval and run those queries in batch.
https://genesyscloud.ideas.aha.io/ideas/ANLS-I-974
Within the export service, we're restructuring that service to work with the new API endpoint and increase our abilities to run more simultaneous exports.
https://genesyscloud.aha.io/ideas/ideas/DARAR-I-1776
We expect to be able to deliver much improved abilities to export wider date ranges in the back half of this year.
------------------------------
Ryan Legner
Staff Product Manager, Genesys Cloud CX
------------------------------