按日计算。

I need to calculate the sum of counts of unique userids for calculating the monthly unique users and this needs to be done on a daily basis. That is for today it wil have to show the sum from 30 days before from today and for yesterday, it needs to calculate the sum beginign from 30 days before yesterday. I need to calculate the sum of counts of unique