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

Implement time series support for report builder

XMLWordPrintable

    • MOODLE_405_STABLE
    • MOODLE_500_STABLE
    • Hide
      1. Testing will be better on a moderately sized site, or one where files have been uploaded to various places over a period of days
      2. Log in as admin
      3. Navigate to Reports from user menu
      4. Create a new report from Files report source
        • Include default setup: No
      5. In report editor, add the following columns:
        • File > Time created
        • File > Filename
        • File > Size
      6. Open Sorting and sort by Time created
      7. Open Conditions and add the following:
        • File > Directory = No
      8. Set the following aggregation for each of your columns:
        • Time created: Date
        • Filename: Count
        • Size: Sum
      9. Confirm you have a report that lists date along with the count/sum of files for that date
        • Note the actual dates/values will differ according to how many files you uploaded on each day - just make sure it looks OK
      Show
      Testing will be better on a moderately sized site, or one where files have been uploaded to various places over a period of days Log in as admin Navigate to Reports from user menu Create a new report from Files report source Include default setup: No In report editor, add the following columns: File > Time created File > Filename File > Size Open Sorting and sort by Time created Open Conditions and add the following: File > Directory = No Set the following aggregation for each of your columns: Time created: Date Filename: Count Size: Sum Confirm you have a report that lists date along with the count/sum of files for that date Note the actual dates/values will differ according to how many files you uploaded on each day - just make sure it looks OK
    • Hide

      Code verified against automated checks.

      Checked MDL-83361 using repository: https://github.com/paulholden/moodle.git

      More information about this report

      Built on: Fri Dec 13 12:46:30 PM UTC 2024

      Show
      Code verified against automated checks. Checked MDL-83361 using repository: https://github.com/paulholden/moodle.git main (0 errors / 0 warnings) [branch: MDL-83361 | CI Job ] More information about this report Built on: Fri Dec 13 12:46:30 PM UTC 2024
    • Hide

      Launching automatic jobs for branch MDL-83361

      Built on: Fri Nov 15 10:34:16 UTC 2024

      Show
      Launching automatic jobs for branch MDL-83361 https://ci.moodle.org/view/Testing/job/DEV.02%20-%20Developer-requested%20PHPUnit/17365/ PHPUnit (sqlsrv / --testsuite core_reportbuilder_testsuite) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/59258/ Behat (NonJS - boost and classic / --tags @core_reportbuilder) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/59259/ Behat (Firefox - boost / --tags @core_reportbuilder) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/59260/ Behat (Firefox - classic / --tags @core_reportbuilder) https://ci.moodle.org/view/Testing/job/DEV.01%20-%20Developer-requested%20Behat/59261/ App tests (stable app version) / --tags @core_reportbuilder) Built on: Fri Nov 15 10:34:16 UTC 2024

      A very usefull type of reports would be time series.

      Examples: Users created by day; user enrolments by course by month, week or day; total file size by year; total courses created by semester; online users count by 5 or 10 minutes interval; etc.

      We should add different aggregation for timestamp columns to allow this kind of report to be created.

        1. Screenshot from 2024-10-03 08-58-56.png
          109 kB
          Daniel Neis Araujo
        2. image-2024-10-03-09-14-34-943.png
          34 kB
          Daniel Neis Araujo
        3. Screenshot 2024-10-17 at 08-53-25 Date aggregation Moodle Master.png
          39 kB
          Paul Holden
        4. image-2024-10-23-17-56-36-530.png
          30 kB
          Daniel Neis Araujo
        5. image-2024-10-23-17-57-03-693.png
          45 kB
          Daniel Neis Araujo
        6. image-2024-10-31-09-59-53-431.png
          53 kB
          Daniel Neis Araujo
        7. image-2024-10-31-10-20-07-276.png
          87 kB
          Daniel Neis Araujo
        8. image-2024-10-31-10-21-14-514.png
          30 kB
          Daniel Neis Araujo
        9. MDL-83361.png
          285 kB
          Ron Carl Alfon Yu

            pholden Paul Holden
            danielneis Daniel Neis Araujo
            David Carrillo David Carrillo
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Ron Carl Alfon Yu Ron Carl Alfon Yu
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 51 minutes
                1h 51m

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