• Overview
• Installation
  • By downloading .zip file
  • By composer
• Quick start
• Properties

Statistics

Overview #

Talking about data, we also talk about statistics because we learn about data through statistics. The Statistics package allows you to compute basic and advanced statistical measures for columns of your data. The basic measures could be min, max, mean, median, etc. The advanced measures are, for example, lowerQuartile, popStdDeviation and others.

Installation #

By downloading .zip file #

1. Download
2. Unzip the zip file
3. Copy the folder statistics into koolreport folder so that look like below

koolreport
├── core
├── statistics

By composer #

composer require koolreport/statistics

Quick start #

In your report's setup page, use the process \koolreport\statistics\Statistics with an array parameter in the type of '{{statistical measure}}' => '{{array of column names}}'

<?php
//MyReport.php
use \koolreport\statistics\Statistics;

class MyReport extends \koolreport\KoolReport
{
    ...
    function setup()
    {
        $this->src('sales')
        ->pipe(new Statistics(array(
            'min' => array('2003'),
            'max' => array('2003'),
            'mean' => array('2003', '2004'),
            'median' => array('2003', '2004', '{{all}}'),
            'lowerQuartile' => array('2005'),
            'upperQuartile' => array('2005'),
            'meanDeviation' => array('{{all}}'),
            'stdDeviation' => array('{{all}}'),
            'percentile_10' => array('{{all}}'),
            'percentile_90' => array('{{all}}'),
        )))
        ->pipe($this->dataStore('salesYearMonthStatistics'));
    }
}

Then in your view, you could use the utility StatisticsReader to extract the measures:

<?php
    //MyReport.view.php:
    use \koolreport\statistics\StatisticsReader;
    
    $stats = StatisticsReader::read($this->dataStore('salesYearMonthStatistics'));

    echo $stats['min']['2003'];
    echo $stats['median']['2004'];
    echo $stats['percentile_90']['{{all}}'];
?>

Properties #

The package supports the following statistical measures: