We have a production issue impacting our customers. A chart query is timing out. Could someone tell me what the query is that is timing out on this request so I can try to improve it? The traceId is "f0028655af102a2dd32ff07303abb69b". Any advice on how to improve the MAQL would be appreciated as well. The chart has two metrics it runs for a daily chart over 30 days. This one counts unique event IDs each day

SELECT COUNT(event_id)

This one counts unique event IDs that have attendance at the event

SELECT COUNT(event_id) WHERE total_attendance > 0

I'm not sure how we can improve these

Hi Rob, The simple count shouldn't necessarily be causing a timeout, and if the table is too large to display it should be displaying the error about limitations. We don't fully see the query in the database that is causing this though. Could you please confirm if you are seeing this error directly in the UI or in your embedded enviornment?

The customers see the error in the UI

are any other attributes being used in the reporting?

The dashboard reports for the last 30 days, excluding today. The two metrics are filtered by date. And the chart is viewed by date.

Could you please DM me the direct link to the dashboard or visualization? I will use impersonation on the admin account to check the behavior.

Sure