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

Database Module - Add Ability to Perform Summary Analysis of Fields or Export data to Excel

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Inactive
    • Affects Version/s: 1.6.4
    • Fix Version/s: None
    • Labels:
      None
    • Affected Branches:
      MOODLE_16_STABLE

      Description

      I think it would be good to be able to summarize the numerical fields of displayed entries. As I imagine using this feature a user could create in the footer (at least that is where it would make the most sense) ##Fieldname_Count##, ##Fieldname_Sum##, ##Fieldname_Max##, ##Fieldname_Min##, ##FieldName_Average##, etc. and have the calculation displayed.

      The count functionality could be useful for check box, radio, menu and menu (multi select) list where ##FieldName_Option1_Count## would return the total number of entries that have that value checked.

      I realize some of this may be a little complicated to implement. Another alternative would be to allow an export of the data to CSV or Excel so that further analysis of the data can be done.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              aborrow Anthony Borrow
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              6 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: