Widget for Open Requests

I'm having trouble with creating a widget showing the total number of open requests as compared to yesterday. Any help with how to create it is appreciated. Thank you.