Hi, I want to sum up values by 7 days in the attribute table using the field calculator. Does anyone have an idea how to solve this? The output in the same table should be a sum value for each cell in the new column.
One option is to use the Select Layer by Date and Time GP tool and for Selection Options check the Date box. Then for the Select by Date parameter, choose "By Recency" and for the "Time Slice" parameter type 7 Days. The "By Recency" is based upon your computer's date/time setting so this may or may not work you depending on the time data. If that's the case, then perhaps use the "By Date Range" parameter to get the results you desire. Then you should be able to do your field calculation on the new column.
