Instead of doing this create a tabcmd script at the end of Reporting table (In ETL) , once all the tables loaded then only your script should run you can schedule this script as well
Check the below link
Hope this helps
Plz mark this answer as correct/helpful to close the thread
The issue turned out to be that the dashboard calculated a 7-day window. When a new days starts, by default it will sum the prior 7 days, but 1 day has no data yet, so the data shows a dip. So, this is not data leakage but the result of a calculation which depended on TODAY() rather than a database date (max date of table).