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

Custom report option to display unique row values

XMLWordPrintable

    • 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

      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

        1. MDL-72826_create report.png
          MDL-72826_create report.png
          104 kB
        2. MDL-72826_show unique rows_1.png
          MDL-72826_show unique rows_1.png
          102 kB
        3. MDL-72826_show unique rows_2.png
          MDL-72826_show unique rows_2.png
          100 kB

            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

              Created:
              Updated:
              Resolved:

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

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