I would like to be able to retrieve the value of a field a week ago in order to help monitor as the values change over time. In an ideal world I would like this to work on a rolling basis (i.e., on Monday I am seeing the values from last Monday) but I expect it might be easier to do something set against a specific day of the week (i.e., at any point in the week I can see what the value was on the previous Sunday).
If anyone has any advice on insight on how we might go about doing this, that would be much appreciated!
