Hi, I’m trying to download data for a dashboard and am getting an empty file containing:
Error: Could not sort by calculated field ‘total_bla’. Limit reached
The docs here:
If the number of rows in your query exceed the row limit that you’ve set, you will not be able to sort table calculations. This is because table calculations are only based on the rows that are displayed. Therefore, if you hit a row limit, the table calculation might be missing some rows that it should be sorting into your results. If you run into this issue, you can try increasing your row limit (up to 5,000 rows).
suggest to increase the row limit, but even when I increase it to the maximum of 5000, I am still getting the same error.
Any help is much appreciated, thanks!