1 Reply Latest reply on Feb 8, 2012 10:34 AM by sroering

    Help with custom reports

      I am needing help creating a custome report.  HR would like to have a report of the top 50 users of the internet. Both time and volume and I have no idea where to start.  Is there a good tutorial out there on custom reports?

       

      Thanks in advance for the assistance.

        • 1. Re: Help with custom reports
          sroering

          Go to Reports

          Click Add > Advanced

           

          [Add Advanced Report dialog]

               Name the report

               Click Add > New Table

              

               [Query dialg]

                    Name the query, "Top users by browse time (summary)"

                    From the available columns, add "User Name", and "Browse Time"

                    Click Layout at the top of the dialog, then set number of results to 50

                    Click Column Properties at the top of the dialog.

                    Select Browse Time from the column list, then set the sort order descending

                    Click "OK" to save changes

           

               (back on add advanced report dialog) Click Add > New Table

           

               [Query dialg]

                    Name the query, "Top users by bytes (summary)"

                    From the available columns, add "User Name", and "Bytes"

                    Click Layout at the top of the dialog, then set number of results to 50

                    Click Column Properties at the top of the dialog.

                    Select Bytes from the column list, then set the sort order descending

                    Click "OK" to save changes

           

          Back on the Add Advanced Reporter dialog, go to the filters tab and set a default date range, such as past week.

          Click OK to save the report.