The calculations feature in PI Vision isn't calculating weekly average. The only calculation type in 'Columns' that works is 'Value', none of the other work (e.g. 'Average', 'Maximum', 'Minimum', etc.). Here is what my trends are displaying ('Value' on left, 'Average' on right).
Here is how my calculation is set up: