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

Trendlines

The above example shows you how to create LineChart 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" => 'exponential', "color" => '#333', "opacity" => 1],
        1 => ["type" => 'linear', "color" => '#111', "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\LineChart;

$data = [
    ['X', 'Dogs', 'Cats'],
    [0, 0, 0],
    [1, 10, 5],
    [2, 23, 15],
    [3, 17, 9],
    [4, 18, 10],
    [5, 9, 5],
    [6, 11, 3],
    [7, 27, 19],
    [8, 33, 25],
    [9, 40, 32],
    [10, 32, 24],
    [11, 35, 27],
    [12, 30, 22],
    [13, 40, 32],
    [14, 42, 34],
    [15, 47, 39],
    [16, 44, 36],
    [17, 48, 40],
    [18, 52, 44],
    [19, 54, 46],
    [20, 42, 34],
    [21, 55, 47],
    [22, 56, 48],
    [23, 57, 49],
    [24, 60, 52],
    [25, 50, 42],
    [26, 52, 44],
    [27, 51, 43],
    [28, 49, 41],
    [29, 53, 45],
    [30, 55, 47],
    [31, 60, 52],
    [32, 61, 53],
    [33, 59, 51],
    [34, 62, 54],
    [35, 65, 57],
    [36, 62, 54],
    [37, 58, 50],
    [38, 55, 47],
    [39, 61, 53],
    [40, 64, 56],
    [41, 65, 57],
    [42, 63, 55],
    [43, 66, 58],
    [44, 67, 59],
    [45, 69, 61],
    [46, 69, 61],
    [47, 70, 62],
    [48, 72, 64],
    [49, 68, 60],
    [50, 66, 58],
    [51, 65, 57],
    [52, 67, 59],
    [53, 70, 62],
    [54, 71, 63],
    [55, 72, 64],
    [56, 73, 65],
    [57, 75, 67],
    [58, 70, 62],
    [59, 68, 60],
    [60, 64, 56],
    [61, 60, 52],
    [62, 65, 57],
    [63, 67, 59],
    [64, 68, 60],
    [65, 69, 61],
    [66, 70, 62],
    [67, 72, 64],
    [68, 75, 67],
    [69, 80, 72]
];

?>
<div class="report-content">
    <div class="text-center">
        <h1>Trendlines</h1>
    </div>
    <div style="margin-bottom:50px;">
        <?php
        LineChart::create(array(
            "dataSource" => $data,
            "columns" => array(
                'X',
                'Dogs',
                'Cats'
            ),
            "options" => array(
                "hAxis" => [
                    "title" => 'Time'
                ],
                "vAxis" => [
                    "title" => 'Popularity'
                ],
                "colors" => ['#AB0D06', '#007329'],
                "trendlines" => [
                    0 => ["type" => 'exponential', "color" => '#333', "opacity" => 1],
                    1 => ["type" => 'linear', "color" => '#111', "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