Report exceeds query size limit.
I have created a custom chat report using tables Chats / Chat Events / Accounts. The reason the Accounts table is being used is so I can filter by group. I am also filtering on a date range. The approx. number of Chats per day is 4000.
The report will only run for a 3 or 4 day range and any date range above that the report will not run due to the query size limitation.
I have tried the following to no avail...
- Restructured the table links switching accounts and chat_events parent child relationship.
- Removed the chat table using the creation date of the chat_event as a filter.