blocks_retained:dashboard

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,
    • Accessory external PostGreSQL binding. (PRO Edition only)
    • 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
    • Query result axis rotation (PRO Edition only)
  • Output modes
    • Data tables
      • Flat tables (records)
      • Tabular matrix
      • Data treeview for hierarchical data (PRO Edition only)
      • Table data features
        • Cell Coloring on data value ruling (PRO Edition only)
        • Summators / Aggregators
        • Sub totals, table split
      • Graphic output
        • Bars
        • Lines
        • Donuts and Pie charts
        • Time line (PRO Edition only)
        • GoogleMap (PRO Edition only)
        • Summators / Aggregators
      • File output
        • CSV files format
        • Immediate export
        • Batched or delayed exports (PRO Edition only)
      • Other features
        • Dashboard instances filter coupling

Builds

:M27: :M28: :M29: :M30: :M31: :M32: :M33: :M34: M35

Travis-ci Intégration continue

Note : “Failing” status does not necessarily mean the plugin is not working, but it has not been fully reworked and review to complay all the moodle coding rules.

Credits

  • 2008 Valery Frémaux (valery.fremaux@gmail.com) - Design and coding
  • 2017 Florence Labord (florence@activeprolearn.com) - QA and Documentation

Road Map

  • Allow multiple colorization rules on table cells
  • Simplify cross table configuration

Back to plugins index - Back to catalogue index

blocks_retained/dashboard.txt · Last modified: 2024/05/14 15:37 (external edit)