2 Replies Latest reply on Feb 24, 2009 8:16 AM by neilmborilla

    Report writer  with Time Interval

    neilmborilla

      Does anyone knows how to create report that has time interval? like for example the requirements are;

      Bandwidth utilization for the last 2 months with 6 hours intervals per day?

      I am having difficulty with the 6 hours interval portion...Don't know how to generate it or should it be through SQL? (No Idea with SQL codes)

       

      Any Help will highly appreciated

        • Re: Report writer  with Time Interval
          Yann

          Hi,

          You will have to edit the SQL query of a report as the summarization options are either hour or day, there is no option between

          I Believe changing Convert(DateTime,Floor(Cast(DateTime as Float)*24)/24,0) in both places in queries will help you out.


          Edit - *24)/24
          To *12)/12,0 For 120 Minutes
          To *24)/24,0 For 60 Minutes
          To *48)/48,0 For 30 Minutes
          To *96)/96,0 For 15 Minutes

          these are examples I frequently need to use, so for 6 hours you will have to edit to:

          *4)/4,0

           

          To show the SQL query of report, Click on Report > Show SQL. Copy the SQL Query and create an advanced SQL report to edit the query as per the above suggestions.

          HTH,

          Yann