PI Vision - Calculation Tool Not Working

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).


image.png
Here is how my calculation is set up:
image_1.png