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

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.6.4, 3.7, 3.8
    • 3.6.5, 3.7.1
    • 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

    Description

      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.

      Attachments

        1. generate_stats.php
          5 kB
          Jun Pataleta
        2. image-2019-06-20-14-07-51-001.png
          435 kB
          Janelle Barcega
        3. image-2019-06-20-14-08-40-231.png
          92 kB
          Janelle Barcega

        Issue Links

          Activity

            People

              jpataleta Jun Pataleta
              jpataleta Jun Pataleta
              Peter Dias Peter Dias
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Janelle Barcega Janelle Barcega
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                8/Jul/19

                Time Tracking

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