The boss has asked me to write a query that provides him 3 different sets of criteria and he wants the Incident count for his Metrics spreadsheet;
1. He wants to know how many tickets were Open at the beginning of the month (count)
2. How many tickets were Opened throughout the month (count)
3. How many tickets closed within the month (count)
Is it possible to include all 3 criteria in the same query? If so how might I go about defining the criteria?
Any help would be greatly appreciated.