Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-42483

Statistics Reports display Zero Data in a Duplicate Periods

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Critical Critical
    • None
    • 2.5.1, 2.6.2
    • Reports
    • MOODLE_25_STABLE, MOODLE_26_STABLE
    • MDL-42483-master
    • Hide
      1. Use an instance with more than 12 months worth of stats (or generate some, or use the attached script)
      2. Enable the statistics
      3. Change the statsruntimestarthour setting to run at 9am.
      4. Run the cron to generate the statistics (or use attached script).
      5. If the cron didn't generate any stats, change your system date to the next day.
      6. Go to Home ► Site pages ► Reports ► Statistics ► Reports ► Statistics.
      7. Make sure that there is no duplicate entry in either the graph or the table
      8. Now, change the timezone to something else, such (America/Bogota).
      9. Go to Home ► Site pages ► Reports ► Statistics ► Reports ► Statistics
        • View the last 2 weeks
        • View the last 3 months
        • View the last 7 months
        • View the last 2 years
        • Make sure that there is no duplicate entry in either the graph or the table
      10. Repeat the test 3 times with a different timezone

      Would be nice to generate stats data from the last year, but if you don't have, use the attached script to generate data (Don't forget to change the start date on the script)

      Show
      Use an instance with more than 12 months worth of stats (or generate some, or use the attached script) Enable the statistics Change the statsruntimestarthour setting to run at 9am. Run the cron to generate the statistics (or use attached script). If the cron didn't generate any stats, change your system date to the next day. Go to Home ► Site pages ► Reports ► Statistics ► Reports ► Statistics. Make sure that there is no duplicate entry in either the graph or the table Now, change the timezone to something else, such (America/Bogota). Go to Home ► Site pages ► Reports ► Statistics ► Reports ► Statistics View the last 2 weeks View the last 3 months View the last 7 months View the last 2 years Make sure that there is no duplicate entry in either the graph or the table Repeat the test 3 times with a different timezone Would be nice to generate stats data from the last year, but if you don't have, use the attached script to generate data (Don't forget to change the start date on the script)
    • Team '; drop tables Sprint 9, Team ';drop tables Sprint 10
    • Medium

      I've noticed that the graphs/data for statistics reports need some fine-tuning.

      At the site level, Statistics Report graphs show two data points for each day or week period. Same label for day increments, and for week increments it shows the first and last day of that week. The first is a value of zero for the "period ending" and the second has a accurate (I'm assuming) values. The table below the graph doesn't list this duplicate data point.

      At the course level however, the statistics report shows a graph as described above AND the data table lists a row of zero data for each week of good data - which seems to be indicating the start of the period not the end.

        1. after.png
          after.png
          103 kB
        2. before.png
          before.png
          68 kB
        3. Screen Shot 2013-10-22 at 12.30.36 PM.png
          Screen Shot 2013-10-22 at 12.30.36 PM.png
          105 kB
        4. Screen Shot 2013-10-22 at 12.59.21 PM.png
          Screen Shot 2013-10-22 at 12.59.21 PM.png
          139 kB
        5. Screen Shot 2015-09-02 at 14.33.46.png
          Screen Shot 2015-09-02 at 14.33.46.png
          27 kB
        6. statistics_report_fix.png
          statistics_report_fix.png
          244 kB
        7. statistics reports duplications.png
          statistics reports duplications.png
          93 kB

            Unassigned Unassigned
            strom@augsburg.edu Eric Strom
            Frédéric Massart Frédéric Massart
            Dan Poltawski Dan Poltawski
            Votes:
            6 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.