Create a custom report based on weekly tickets status

Create a custom report based on weekly tickets status

Hi all,

I would like to create a report with below criteria.
  1. Display number of tickets received on last week
  2. Display number of tickets CLOSED on last week (tickets were received on last week as well)
  3. Display number of tickets received on last week, but not yet CLOSE
  4. Display number of tickets CLOSED on last week and that ticket was received before last week
  5. Group by Category
  6. Display the total of the above
I think the point 1 and 2 could be use the "close on same week" fields, but for point 3 and point 4, I'm not sure how I can do it.


Thanks for everyone in advance

Warmly regards,
Carmel Lee

      New to M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
              See all integrations
              New to ADManager Plus?
              See all integrations
              New to ADManager Plus?

                New to ADSelfService Plus?

                Start your free trial
                Start your free trial



                          Related Products