I am trying to create two new queries based on multiple criteria and I'm not sure how to go about it. Here is the criteria I need.
I have created a query of All Incidents (open and Closed) by Category but I also need the following;
Weekly view of all Incidents by Category for a specific set of Analysts. We aren't using Groups so I don't know how to pick up the correct people or specify the week variable. Essentially I need the Application/Team Manager to be able to run his own query for his group of Analysts based on the current week and another query for the Technical/Team Manager for his group based on the current week. They want to run these queries each week.