Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formula to pull previous day solved when date filter is broader range

edited Jan 31, 2019 8:29PM in Reporting & Analytics for B2C Service 7 comments

Summary

Pulling all open statuses while only pulling solved for the previous day or week, month, etc.

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!