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

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.6.4, 3.7, 3.8
    • Fix Version/s: 3.6.5, 3.7.1
    • Component/s: Reports
    • Labels:
    • Testing Instructions:
      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
    • Affected Branches:
      MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE
    • Fixed Branches:
      MOODLE_36_STABLE, MOODLE_37_STABLE
    • Pull 3.7 Branch:
    • Pull Master Branch:
      MDL-65910-master

      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

          Issue Links

            Activity

              People

              Assignee:
              jpataleta Jun Pataleta
              Reporter:
              jpataleta Jun Pataleta
              Peer reviewer:
              Peter Dias
              Integrator:
              Eloy Lafuente (stronk7)
              Tester:
              Janelle Barcega
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                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