3 Replies Latest reply on Nov 20, 2013 1:11 AM by bayswater

    Web Reporter Custom Report

    bayswater

      Just hoping to get some assistance on a custom report that I am trying to make.

       

      I'm trying to get the top ten sites by Bytes each day for a specified user over a specified date range. Basically below is what I'm hoping for.

       

      John Smith

                  01/01/2013

                              www.google.com        50mb

                              www.microsoft.com    40mb

                              …

                              …

                  02/01/2013

                              www.google.com        30mb

                              www.yahoo.com         20mb

                              …

                              …

       

      Has anyone done anything like this?

       

      Cheers,

      Lindsay

        • 1. Re: Web Reporter Custom Report
          sroering

          You want to use advanced reports with the "run report multiple times" checkbox enabled.  Basically you use that feature anytime you want to iterate over a list of items.  In your case, you are trying to iterate over a list of dates.

           

          So you need to create a list of dates sorted the way you want.  So when you create an advanced report, on the advanced tab, either use a static list of dates, or select the date column from an existing query. Then use the filters button to set the date range.  You don't need any other filters, and any summary data query should work if it has the date column.  That will return a list of dates.

           

          Then you configure the query for the main report as you want (site and bytes).

          • 2. Re: Web Reporter Custom Report
            bayswater

            Thanks sroering, I'll give this a shot and report back.

            • 3. Re: Web Reporter Custom Report
              bayswater

              Thanks for your help sroering.

               

              I have got what I was after by creating two queries, one for Bytes and Site Name (used for the main query) and one just with the Date field (used for the running the report multiple times).

               

              It is pretty basic, but does what we need.