So every day I have to pull a report that gets data for yesterday’s metrics, forecasted Saturday’s metrics, and Week to date sums.
I want to write a Python code that automates the process.
I have most of the code done but I’m having issues with the week-to-date sums.
I want it to be versatile cause the sum will increase each day of the week. So if I run the code tomorrow, it will take into account all values from Sunday to Tuesday. If I run it on Friday, it will be Sunday to Thursday.