Hello,
maybe someone can help me with an automatic calculation.
I have 30 items with the values date and speed. Of the 30 items, the 20 most recent (sorted by date) should always be considered for the calculation, of which the average should be calculated from the top 8.
If a new item is created, the entire calculation should be restarted.
Any ideas?