Why do I get a message of Network error upon running an Explore query?
There is a data threshold of 50,000 rows on the underlying SQL in Explore. Explore is only able to query 50,000 rows of data at a time and displays the Network Error if that limit is exceeded. This limit doesn't necessarily translate to 50,000 rows on the query itself because it also depends on the number of columns included and the type of data calculated.
To resolve this issue, narrow the query scope to prevent the exceeding of the data threshold. You can narrow the query scope by adjusting existing date and data filters or adding new ones. Below are the general steps for date filters, but the same methodology can be applied to data filters as well.
Adjusting an existing date filter
- Select an existing date filter on your query, for example, Ticket created - Date.
- Make the defined date range smaller, for example, Yesterday, to reduce the data computation required.
Adding a new date filter
To add a new date filter with a specific date range, follow the steps in the article: Editing dates and date ranges. If the Network error message persists, make the date range smaller.