Lets imagine that we have a field such as PoC (Percentage of Completion), this field is a formula that is receiving inputs form different records and fields.
My question is, how can I have the values of this field, PoC, be saved in a different table, with the respective value for each day or week?
If the PoC in October was evolution like the following:
1st week - 20%
2nd week - 30%
3rd week - 40%
4th week - 50%
5th week - 70%
How can I have way of storing this information automatically, without needing to do it week by week, by myself?