[#MDL-8386] Database Module - Add Ability to Perform Summary Analysis of Fields or Export data to Excel

Issue Details (XML | Word | Printable)

Key:	MDL-8386
Type:	Improvement
Status:	Open
Priority:	Minor
Assignee:	Martin Dougiamas
Reporter:	Anthony Borrow
Votes:	6
Watchers:	7

Operations

Add/Edit UI Mockup to this issue

If you were logged in you would be able to see more operations.

Moodle

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

Created: 02/Feb/07 09:34 AM Updated: 20/Nov/09 09:31 AM

Component/s:

Database activity module

Affects Version/s:

1.6.4

Fix Version/s:

None

Issue Links:

Dependency

This issue will be resolved by:

MDL-9232 Want ability to have more views of the database - with grouping, summaries etc

Relates

This issue has been marked as being related by:

~~MDL-8407~~ Export records of a database activity as a CSV, XLS, or ODS file

Participants:	Anthony Borrow, jose, Martin Dougiamas, Nenashev Ilya, Paul Fynn and Tim Pinnock
Security Level:	None
Affected Branches:	MOODLE_16_STABLE

Description

« Hide

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.

All

Comments

Change History

Version Control

Sort Order:

[ Permalink | « Hide ]

Nenashev Ilya added a comment - 06/Apr/07 04:22 AM

my enhancements for this issue - in MDL-9232

[ Permalink | « Hide ]

Anthony Borrow added a comment - 06/Sep/07 11:33 AM

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

[ Permalink | « Hide ]

Anthony Borrow added a comment - 06/Sep/07 11:35 AM

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

[ Permalink | « Hide ]

jose added a comment - 01/Feb/09 10:31 AM

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.

[ Permalink | « Hide ]

Paul Fynn added a comment - 25/Feb/09 09:05 PM

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

[ Permalink | « Hide ]

Tim Pinnock added a comment - 20/Nov/09 09:31 AM

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

All content on this web site is made available under the GNU General Public License, unless otherwise stated.