function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
MC-DragnierMC-Dragnier 

Report building question on Cases

Hello again,

 

We're trying to build a report that will work as follows:

 

We want the report to be summarized by account and show us two things

1) Cases opened within a set period of time (like Last 7 Days)

2) Cases closed within the same timeframe

 

The report should not be the same cases that have opened and closed in the last 7 days.  it should look like this

 

Cases opened last 7 days

Andy America

Case #1123

            1124

            1125

 

Cases Closed Last 7 Days

Andy America

Case #1108

            1112

             1123

 

We'd have more of the standard colums in place, case owner, comments, stuff like that.

 

Can anybody help with how we can pull this into one report?  We can do two different reports easily, cases opened on this account, cases closed on this account but we'd like to get this information onto one report.  Any assistance would be awesome.

 

Thanks!

jackeejackee

If , you play around the display you can show both the report's.

 Attaching the screen short.

 Instead of Open , I have used Assigned  .....

 

Please check your mail for the screenshot

 

 

 



jackeejackee

sorry  the image is too big to send vai private message too  and to attach to the post sucks ....  sorry ....