Are you still needing assistance with this? I've attached a workbook that I think meets your needs. I did the following:
- Created a calculated field to return the Day of Date, this gets around Tableau's overly-optimistic padding.
- Created a calculated field to return the Moving Average, this table calculation has the Compute Using to Day of Date so it will partition (restart) for each weekday & time period
- Created a calculated field for the % Change that uses the Moving Average, this also has the Compute Using set to Day of Date.
Note that the two latter calcs could be combined into one if you wanted, I just created separate ones because it makes the calculations easier to show.
Thanks very much Jonathan that works great!