I need a script to get the % difference comparing the data week over week. I have already a script that works well for weeks > 1, the problem is for the first week that needs to compare to week 52 of previous year.
The other problem I have is that for the current week I want to compare only the completed days, for example if today is Wednesday I want to compare Monday + Tuesday this week over Monday + Tuesday last week. My script is comparing Monday+Tuesday this week over the whole last week.