8 Replies Latest reply on Apr 8, 2013 9:10 AM by Sarah Connors

    how do I count instances of items in a category?

    Sarah Connors

      Hope I can explain this properly.

       

      I'm creating a workbook tracking a "custom requests" queue for my company. Basically people go into our UI and make IT requests, and we want to show how many different types of requests people have made and how much time it takes to complete said requests.

       

      So basically I have a dimension called "category" and within this dimension are a number of different request types. I have another dimension called "user name". What I want to do is chart username vs. NUMBER OF DIFFERENT REQUEST TYPES rather than username vs. request count. Any ideas how I can get a count of request types rather than count of requests?