Why does the query in the dataset take an extended time to process?
I have a query that typically takes around 2 minutes to process and returns the expected output. However, after adding a small condition to exclude a specific value, the report keeps processing without returning any data. Additionally, when I filter by a few specific values, the query does produce results, but it takes significantly more time than before. This issue is causing delays and inefficiencies in generating the report.
0