I hope you folks can help me out with this because it's driving me nuts.
The company I work for users a data collection program called Remedy which is used to collect trouble ticket information for IT related issues.
Although I can squeeze a lot of valuable data out of Remedy by dumping the data into Excel by way of .csv, one very basic task I'm struggling with is creating a pivot table to comparatively display quantity of tickets by data opened vs. quantity of tickets by date closed. The way I'm doing it now is by running two pivot tables (one for each value) and then copying/pasting the outputs of each into another worksheet.
I feel like this task should be among the easiest I can perform with a pivot table. There are lots of data fields available that should provide common reference for both data opened vs. date closed that would produce an accurate count for each but I can't get the mix of row labels, column labels, and values right to get the results I'm looking for.
Any thoughts or suggestions would be very welcome!
EDIT: Another question, if I may. I'd like to have different groupings by date for different pivot that may share the same data set. For instance, I want a pie chart to breakdown the top three problem types for the month of May. I also want a pie chart detailing the top 3 problem types but for the previous quarter. For whatever reason, when I change the date range or grouping of one pivot chart, it affects the other. This is driving me nuts! help!
The company I work for users a data collection program called Remedy which is used to collect trouble ticket information for IT related issues.
Although I can squeeze a lot of valuable data out of Remedy by dumping the data into Excel by way of .csv, one very basic task I'm struggling with is creating a pivot table to comparatively display quantity of tickets by data opened vs. quantity of tickets by date closed. The way I'm doing it now is by running two pivot tables (one for each value) and then copying/pasting the outputs of each into another worksheet.
I feel like this task should be among the easiest I can perform with a pivot table. There are lots of data fields available that should provide common reference for both data opened vs. date closed that would produce an accurate count for each but I can't get the mix of row labels, column labels, and values right to get the results I'm looking for.
Any thoughts or suggestions would be very welcome!
EDIT: Another question, if I may. I'd like to have different groupings by date for different pivot that may share the same data set. For instance, I want a pie chart to breakdown the top three problem types for the month of May. I also want a pie chart detailing the top 3 problem types but for the previous quarter. For whatever reason, when I change the date range or grouping of one pivot chart, it affects the other. This is driving me nuts! help!
Facebook
Twitter