4 Replies Latest reply on Mar 7, 2016 2:00 AM by JulianWigman

    Query for Averages

    Vicky1985 Apprentice

      Hi

       

      We are looking to build a query which gives the average of calls closed per team per month againt the calls an individual has closed per month.

       

      We are using version 2016 please could you advise how we would go about this?

       

      Thanks

      Vicky

        • 1. Re: Query for Averages
          John Stuart-Robson Employee

          Hi Vicky,

           

          Query Designer won't be able to give you an average.  You will be better off using Crystal Reports to get the report you need. We have a subset of reports which might be what you are after here:

           

          Service Desk Reporting Content Pack

           

          If you were interested in this reporting pack, you may require some Professional Services to enable these reports.

           

          Hope that helps.

           

          John

          • 2. Re: Query for Averages
            JulianWigman Expert

            If you are licensed for it then the MI module can also do averages.

            • 3. Re: Query for Averages
              Vicky1985 Apprentice

              Hi Julian

               

              I have just found out that we are licenced for the MI module please could you tell me how I would go about doing these queries?

               

              Thanks

              Vicky

              • 4. Re: Query for Averages
                JulianWigman Expert

                Hi Vicky

                 

                First you need to add the MI admin module to one of your shortcut groups in console (MI server-side setup needs to be done here) and then you can setup the data gathering side.  The output side is via WebDesk or Self Service dashboards and the "Trend" gadget.

                 

                Best bet rather than trying to "reinvent the wheel" is you read the short MI manual first.  Find this at https://community.landesk.com/support/docs/DOC-39841.

                 

                The functions that are available depend on the output types of the metric’s query:

                • Sum – adds all of the numeric values returned by the selected attributes in the query
                • Avg – calculates the arithmetic mean of the numeric values returned by the selected query attributes
                • Count – counts the total number of rows returned by the query
                • Min – returns the smallest value returned by the selected query attribute
                • Max – returns the largest value returned by the selected query attribute
                1 of 1 people found this helpful