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. Bear in mind that this limit doesn't necessarily translate to 50,000 rows on the query itself, it also depends on the number of columns included, type of data calculated, etc.
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
Follow the steps in Editing dates and date ranges to add a new date filter with a specific date range.
If the Network error message persists, make the date range smaller.