Help with creating reports based on fields
Currently we are using Service Desk to manage request and need to create some requests based on data we've collected in our tickets, something like the below:
1- We have created a location drop down
2- We need reports that:
a. Mean Time of time ticket opened – minus time ticket received per month per LOCATION (custom field as per your suggestion)
b. Mean Time time ticket closed – time ticket opened per month per level per location (custom
c. Mean time time ticket closed – time ticket opened per month per priority per location (custom
d. Number tickets per month per location
e. Number of tickets per month per location per subgroup type
f. Number of tickets per month per location per item type
g. Number of tickets per month per location per group type
h. ALL OF THE ABOVE per month per 3 month (quarter) per 6 month per 9 month per year.
Any ideas?