We are experiencing a production issue where one of our charts reports "Too many data points to display" for one of our larger customers. This customer has approximately 82500 rows in the table the chart reads from. This does not seem like an excessive amount of data. The table only has 657404 rows across all customers. I am unable to find any errors when I review the network responses in the the browser. I have not been able to find the specific network request that generates this error. Can anyone tell me what might be going wrong? The query that is run counts the number of each event type for events occurring over the last 30 days in order to make a pie chart. The table only has data from the last 30 days. The event IDs can appear one or more times and we don't want to double count them so we need to count distinct event IDs. The query looks something like this:

SELECT COUNT({label/event_table.event_id}) BY {label/event_table.type}

The chart for customers with a lot of events shows this message:

Hi Rob, you can find the limits on tables HERE, as the error suggests, you are exceeding these. If you just need to retrieve all the rows, I would suggest retrieving the data using the API. Let us know if this fits your use case.

Thank you! I will review the docs and get it sorted out