KoolReport
  1. Home
  2. Google Charts
  3. Google Charts: Column Chart

Trendlines

The above example shows you how to create ColumnChart using built-in Google Charts. In this example, for purpose of chart demonstration only, we do use mock-up data from array. As you can see, the KoolReport's widget in general support dataSource could be DataStore, Process, DataSource or even simple array.

For example:

...
"options" => array(
    ...
    "trendlines" => [
        0 => ["type" => 'linear', "lineWidth" => 5, "opacity" => .3],
        1 => ["type" => 'exponential', "lineWidth" => 10, "opacity" => .3]
    ]
)

<?php

require_once "../../../../load.koolreport.php";
require_once "MyReport.php";

$report = new MyReport;
$report->run()->render();

<?php
require_once "../../../../load.koolreport.php";
class MyReport extends \koolreport\KoolReport
{

}
<?php

use \koolreport\widgets\google\ColumnChart;

$data = [
    ['Time of Day', 'Motivation Level', 'Energy Level'],
    [[8, 0, 0], 1, .25],
    [[9, 0, 0], 2, .5],
    [[10, 0, 0],  3, 1],
    [[11, 0, 0], 4, 2.25],
    [[12, 0, 0], 5, 2.25],
    [[13, 0, 0], 6, 3],
    [[14, 0, 0], 7, 4],
    [[15, 0, 0], 8, 5.25],
    [[16, 0, 0], 9, 7.5],
    [[17, 0, 0], 10, 10],
];
?>
<div class="report-content">
    <div class="text-center">
        <h1>Trendlines</h1>
    </div>
    <div style="margin-bottom:50px;">
        <?php
        ColumnChart::create(array(
            "dataSource" => $data,
            "columns" => array(
                'Time of Day' => array(
                    "type" => 'timeofday',
                ),
                'Motivation Level',
                'Energy Level'
            ),
            "options" => array(
                "title" => 'Motivation and Energy Level Throughout the Day',
                "hAxis" => [
                    "title" => 'Time of Day',
                    "format" => 'h:mm a',
                    "viewWindow" => [
                        "min" => [7, 30, 0],
                        "max" => [17, 30, 0]
                    ]
                ],
                "vAxis" => [
                    "title" => 'Rating (scale of 1-10)'
                ],
                "trendlines" => [
                    0 => ["type" => 'linear', "lineWidth" => 5, "opacity" => .3],
                    1 => ["type" => 'exponential', "lineWidth" => 10, "opacity" => .3]
                ]
            )
        ));
        ?>
    </div>

</div>

What People Are Saying

"KoolReport helps me very much in creating data report for my corporate! Keep up your good work!"
-- Alain Melsens

"The first use of your product. I was impressed by its easiness and powerfulness. This product is a great and amazing."
-- Dr. Lew Choy Onn

"Fantastic framework for reporting!"
-- Greg Schneider

Download KoolReport Get KoolReport Pro