Formula to pull previous day solved when date filter is broader range
SummaryPulling all open statuses while only pulling solved for the previous day or week, month, etc.
I am pulling all open status incidents based on date filter incidents.created for open incidents in the date range that are unresolved, updated, follow up, researching and waiting and showing totals for each. That works fine. The department receiving this asked for the same report to show all of the open statistics for the range, but then only show incidents solved for the previous day. Is there a formula to pull the previous day or Week, month-to-date or previous month stats for solved while pulling all of the open statuses above? I have attached an image of report definitions as well as