WoW Change not compared to the entire week?

Is there a way for computing week over week changes (%) without including the whole week or day?

For instance sum(Total GMV) - Mar 16th till 3 PM compared to sum(Total GMV) - Mar 9th till 3 PM.

For some reason, it is comparing March 16th (3 PM) to March 9th (entire day), thus giving an incorrect value.

Is there a way to solve this?

Hi @sahil.maisuria take a look at the suggestions on this post which covers getting data ‘to date’. You can then compare data for the same period. This is commonly done with Year to Date and Month to Date but you should be able to adapt the examples for Week and Day.