Calculating daily count of open and closed requests