blocks:dashboard

This is an old revision of the document!


Dashboard Block

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

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) - Design and coding
  • 2017 Florence Labord (florence@activeprolearn.com) - QA and Documentation

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

blocks/dashboard.1502446233.txt.gz · Last modified: 2024/04/04 15:50 (external edit)