wiki:S3/S3Report

Version 18 (modified by James O'Neill, 12 years ago) ( diff )

Add info about search option in report_options

S3Report

S3Report is a REST method handler for data analysis.

Functionality

S3Report can generate contingency tables (a.k.a. pivot tables) from S3Resources.

Dependencies

S3Report uses pyvttbl to generate contingency tables. A modified version of pyvttbl is integrated into the S3 framework.

Pyvttbl requires the following Python modules:

  • numpy
  • matplotlib

URL Methods

S3Report responds to the report URL method, for all resources (generic method).

The following parameters are accepted:

ParameterExplanationrequired?
rowsthe name of the field to be used for the table rowsyes
colsthe name of the field to be used for the table columnsno (if no cols are specified, all instance values appear in 1 column)
factthe name of the field to be used for the instance valuesno (falls back to "name" if present, otherwise to "id")
aggregatethe aggregation functionno (default: list)

rows, cols and fact support the same options as list_fields:

  • fields in the table
  • virtual fields in the table
  • fields/virtual fields in tables linked by foreign keys ($-notation)

S3Report supports a number of aggregation functions. The following functions have been tested so far:

FunctionExplanation
lista comma-separated list of all instance values
countthe number of instance values
sumthe sum of all instance values
avgthe average (mean) of all instance values

Examples

$-notation for references:

reduced parameter list:

Report Options

Table configurations can contain a report_options item, which is a Storage object. This object is used to configure reports and report options form.

The rows, cols, facts and aggregate items are lists of available values for the user to select from.

The defaults property is a Storage object that contains the default values for the report. It can contain a value for rows, cols, fact, aggregate and totals (as described in URL Methods).

The search property is a list of S3Search widgets that will allow the report to be filtered. If no search property is specified, no filter form will be available.

Here is an example of a report_options item:

report_options=Storage(
        rows=report_fields,
        cols=report_fields,
        facts=report_fields,
        defaults=Storage(
                rows="project_id",
                cols="name",
                fact="time_actual",
                aggregate="sum",
                totals=True
        ),
        search=[
                S3SearchOptionsWidget(
                        name="project_id",
                        label = T("Project"),
                        field = "project_id",
                ),
        ],
)

All items in report_options and defaults are optional.

Further Development

The following enhancements are currently under development:

  • Support for JSON, CSV and XLS exports
  • Support for client-side graphs representation (via JSON)
Note: See TracWiki for help on using the wiki.