Dashboard Block

Plugin type: Block

Name: Dashboard

Versions: 1.9, 2.2 to 3.3

FUnctional family: Reporting

Distribution: Public

Availability: Release Candidate

Repository: https://github.com/vfremaux/moodle-block_dashboard

The Dashboard blocks is a block accessory useful to build complete data reporting reports within a course, using dashboard instances as report elements to process one single query in moodle database and display results.

Query results will be a starting dataset that can be cached, sorted, filtered, and finally plotted in raw data tables or in graphs, and exported to files.

Originally design for use in course format “page” (or “flexipage”), it provides the choice of plotting results in the block body or in a separate full screen page. From Moodle 3.1 and ahead, some themes provides possibility to layout blocks in a more flexible way, and thus assemble dashboard block instances in a meaningful organization.

Guides

Install Guide

Configuration guide

Technical guide

Features

Data sourcing

Main moodle database binding, and accessory external PostGreSQL binding.

SQL query input in full SQL text

Input fields selection

Dynamic Filters

Dynamic parameters

All data can be postformated (using sprintf syntax)

Result caching

Big results protection

Output modes

Data tables

Flat tables (records)

Tabular matrix

Data treeview for hierarchical data

Table data features

Cell Coloring on data value ruling

Summators / Aggregators

Sub totals, table split

Graphic output

Bars

Lines

Donuts and Pie charts

Time line

GoogleMap

Summators / Aggregators

File output

CSV files format

Immediate export

Batched or delayed exports

Other features

Dashboard instances filter coupling

Credits

2008 Valery Frémaux (valery.fremaux@gmail.com)

Road Map

Nettoyer/réagencer les panneaux de configuration

Permettre plusieurs colonnes de colorisation (jusqu'à 3)

Permettre un choix plus simple du séparateur de valeur dans les cellules de tables croisées

Retour au catalogue