Don't think this gives the data as needed. As you can see the first column has the same value across all dates. It is not counting the numbers in a rolling fashion. Instead it is just taking the total number of people in last 30 days from today. Does anyone have any suggestion on how to solve this?