Query Table does not update with new data in dashboard

Query Table does not update with new data in dashboard

Hello,

I'm using the On-Premises version of Zoho. I create two Query Tables that gets updated each week. Both of them are not refreshed automatically with the new data in the dashboard. When i select the query, the data shows the previous week, and when I go to "Edit Design" and "Execute Query" I see the updated data. 

Please see sample query below:
SELECT
"Week",
"Actual2019",
"Actual2020"
FROM  "SalesPerformance" 
WHERE "Week"  in
(
  SELECT MAX("Week")
FROM  "Calculations" 
)

Am I missing a step?

Any help would be appreciated.

Thanks.