dynamic last 30 days orders count

we have status column containg completed and pending and we want to show count of pending and completed separately and it want to show it in table which will show last the count for last 30 days dynamically -for example selected date is 15 march this 15days will be counted in 30 days and remaing 15 days count from Feb