Moodle

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

Details

  • Type: Improvement Improvement
  • Status: Open Open
  • Priority: Minor Minor
  • Resolution: Unresolved
  • Affects Version/s: 1.6.4
  • Fix Version/s: None
  • Component/s: Database activity module
  • 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.

Issue Links

This issue will be resolved by:
MDL-9232 Want ability to have more views of the database - with grouping, summaries etc Major Open
This issue has been marked as being related by:
MDL-8407 Export records of a database activity as a CSV, XLS, or ODS file Major Closed

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Nenashev Ilya added a comment -

my enhancements for this issue - in MDL-9232

Show
Nenashev Ilya added a comment - my enhancements for this issue - in MDL-9232
Hide
Permalink
Anthony Borrow added a comment -

The ability to export to Excel has been requested several times and I have tried to pull these issues together into MDL-8407. While this request mentions that as a possibility it is really focused on being able to perform summary calculations on the data for the list view.

The tracker issues that mention exporting include:
http://tracker.moodle.org/browse/MDL-10530
http://tracker.moodle.org/browse/MDL-8407
http://tracker.moodle.org/browse/MDL-8488

Peace - Anthony

Show
Anthony Borrow added a comment - The ability to export to Excel has been requested several times and I have tried to pull these issues together into MDL-8407. While this request mentions that as a possibility it is really focused on being able to perform summary calculations on the data for the list view. The tracker issues that mention exporting include: http://tracker.moodle.org/browse/MDL-10530 http://tracker.moodle.org/browse/MDL-8407 http://tracker.moodle.org/browse/MDL-8488 Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

The ability to export the data from a database module has been requested as a separate issue.

Show
Anthony Borrow added a comment - The ability to export the data from a database module has been requested as a separate issue.
Hide
Permalink
jose added a comment -

I need sum the numeric data field, after I search width advanced search. Any suggestion?. Can I generate a graph width this data?

Thanks a lot.

Show
jose added a comment - I need sum the numeric data field, after I search width advanced search. Any suggestion?. Can I generate a graph width this data? Thanks a lot.
Hide
Permalink
Paul Fynn added a comment -

I'm having serious trouble navigating to the appropriate page for Database Export issues -Anthony's list helps, and I have already added to Nenashev's issue.

I have successfully exported from database, however any of the ""embedded"" fields (##user##, ##timeadded##, ##comment##) do not appear to be available for export.

If this is user error (me) could we improve the guidance, otherwise is there away of adding embedded fields into the export list?

Best, Paul

Show
Paul Fynn added a comment - I'm having serious trouble navigating to the appropriate page for Database Export issues -Anthony's list helps, and I have already added to Nenashev's issue. I have successfully exported from database, however any of the ""embedded"" fields (##user##, ##timeadded##, ##comment##) do not appear to be available for export. If this is user error (me) could we improve the guidance, otherwise is there away of adding embedded fields into the export list? Best, Paul
Hide
Permalink
Tim Pinnock added a comment -

It would also be good to be able to count the amount of records returned on an advanced search or in list view.

Show
Tim Pinnock added a comment - It would also be good to be able to count the amount of records returned on an advanced search or in list view.

People

Vote (6)
Watch (7)

Dates

  • Created:
    Updated:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.