How to Rebuild Derived Tables and Re-Run
Sometimes to get a refreshed dataset, simply clearing the cache and refreshing will not do enough. You need to rebuild the derived tables and rerun the query.
You can only do this from the EXPLORE screen if you have Developer rights.
Step 1: Explore from here
Step 2: Rebuild Derived Tables & Run