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

Custom report option to display unique row values

    XMLWordPrintable

Details

    • MOODLE_400_STABLE
    • MOODLE_400_STABLE
    • Hide

      Setup

      1. Log in as admin
      2. Create two new users (user01, user02)
      3. Create two new cohorts (cohort01, cohort02)
      4. Add both users to both cohorts

      Create report

      1. Navigate to Reports > Report builder > Custom reports in site administration
      2. Press New report
        • Enter a name
        • Select the Cohorts report source
        • Untick Show unique rows
        • Untick Include default setup
        • Press Save
      3. Add the following columns:
        • Cohort > Category
        • User > Fullname
      4. Confirm your report looks like the following:
        Category Full name
        System User One
        System User One
        System User Two
        System User Two

      Show unique rows

      1. Navigate back to list of reports
      2. Press Edit report details for your report
      3. Enable Show unique rows and save
      4. Press Edit report content for your report
      5. Confirm your report looks like the following:
        Category Full name
        System User One
        System User Two
      6. Change aggregation for Full name column to Comma separated distinct values
      7. Confirm your report looks like the following:
        Category Full name
        System User One, User Two
      Show
      Setup Log in as admin Create two new users (user01, user02) Create two new cohorts (cohort01, cohort02) Add both users to both cohorts Create report Navigate to Reports > Report builder > Custom reports in site administration Press New report Enter a name Select the Cohorts report source Untick Show unique rows Untick Include default setup Press Save Add the following columns: Cohort > Category User > Fullname Confirm your report looks like the following: Category Full name System User One System User One System User Two System User Two Show unique rows Navigate back to list of reports Press Edit report details for your report Enable Show unique rows and save Press Edit report content for your report Confirm your report looks like the following: Category Full name System User One System User Two Change aggregation for Full name column to Comma separated distinct values Confirm your report looks like the following: Category Full name System User One, User Two

    Description

      This is in reference to point 1. from MDL-72663:

      "Unique" aggregation, define what it should do

      It was decided within the team that this is not an appropriate column aggregation type because it doesn't perform aggregation on a given column, it performs aggregation on an entire row

      To implement:

      1. A new option per report: "Show unique rows" (current wording TBC)
        • If no columns are being aggregated, show unique rows
        • If columns are being aggregated, has no effect

      Setting as blocked by MDL-72565, because mikelmartíncorrales is adding a generic report settings API there that we can use here

      Attachments

        Issue Links

          Activity

            People

              pholden Paul Holden
              pholden Paul Holden
              Carlos Castillo Carlos Castillo
              Jun Pataleta Jun Pataleta
              Angelia Dela Cruz Angelia Dela Cruz
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours, 45 minutes
                  3h 45m

                  Clockify

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