Is it possible to show # of submissions only for previous day?

Summary:

Looking to display number of submissions submitted on previous day for each requisition

Content (required):

Hi all--we've been asked to try and provide a report that shows the total number of submissions on a requisition submitted the previous calendar day (the team want to see the amount of change on a report they receive daily via an agent). The existing report is attached.

Is this something that's possible with SQL and the existing Candidate Facts (e.g. "Candidate Counts"."# Submissions Complete"), or is anyone aware of a better approach to this? We had thought it might be possible via a CASE statement but couldn't make this work.