Thanks @robaxelsen I confirm I'm experiencing the same issue randomly in the "old" Dynatrace version when displaying in dashboard metric done via DQL (even if I specify a very limited amount of time).
Let us know as soon as this issue will be addressed on the overall platform,
On this occasion, I recommend using the Platform Dashboards for this use case. They will offer more visualizations and a better experience than using Dashboards Classic.
If you are returning too many rows, you can set your timeframe as shown below:
fetch bizevents, from: now()-1d
To get the best experience from BizEvents and Logs, i suggest doing some processing on the values you want and then returning them - see here
Happy to look over your BizEvent query and make recommendations 🙂