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

Data displayed on the graph in user statistics report don't match the data on the results table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.6.5, 3.7.1
    • 3.6.4, 3.7, 3.8
    • Reports
    • MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE
    • MOODLE_36_STABLE, MOODLE_37_STABLE
    • MDL-65910-master
    • Hide
      1. Log in as admin user
      2. Create some courses and users enrolled in those courses
      3. Make sure site statistics are enabled (here is the docs page)
      4. Download and run the attached script "generate_stats.php" which will create some duplicate log entries to ensure that timeend matches (which is what causes this issue)
      5. Run cron to generate the stats, or execute the "\core\task\stats_cron_task" task:

        php admin/tool/task/cli/schedule_task.php --execute="\\core\\task\\stats_cron_task"

      6. Go to a user's profile (or your own profile)
      7. Under "Reports", click "Statistics"
      8. Check the numbers on the table and compare them to the corresponding data point on the graph (you can hover on the data points to see the values)
      9. Confirm that the numbers on the table match the data points on the table
      Show
      Log in as admin user Create some courses and users enrolled in those courses Make sure site statistics are enabled (here is the docs page ) Download and run the attached script " generate_stats.php " which will create some duplicate log entries to ensure that timeend matches (which is what causes this issue) Run cron to generate the stats, or execute the " \core\task\stats_cron_task " task: php admin/tool/task/cli/schedule_task.php --execute="\\core\\task\\stats_cron_task" Go to a user's profile (or your own profile) Under " Reports ", click " Statistics " Check the numbers on the table and compare them to the corresponding data point on the graph (you can hover on the data points to see the values) Confirm that the numbers on the table match the data points on the table

      To reproduce:

      1. Log in as admin user
      2. Create some courses and users enrolled in those courses
      3. Make sure site statistics are enabled (here is the docs page)
      4. Download and run the attached script "generate_stats.php" which will create some duplicate log entries to ensure that timeend matches (which is what causes this issue)
      5. Run cron to generate the stats, or execute the "\core\task\stats_cron_task" task:

        php admin/tool/task/cli/schedule_task.php --execute="\\core\\task\\stats_cron_task"

      6. Go to a user's profile (or your own profile)
      7. Under "Reports", click "Statistics"
      8. If you compare the data on the graph and the table, you will see that some data on the table don't match the ones displayed on the graph.

            jpataleta Jun Pataleta
            jpataleta Jun Pataleta
            Peter Dias Peter Dias
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Janelle Barcega Janelle Barcega
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 15 minutes
                2h 15m

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