Trendlines with ColumnChart doesn't work.

[DeeSouza]

What Version?

3.1

Issue

Trendlines with ColumnChart doens't work.

Controller Code (chart creation code)

$lavaChart = Lava::ColumnChart($idChart, $datatable, [
    'title' => $title,
    'height' => 500,
    'chartArea' => [
    	'top' => 35,
    	'bottom' => 100,
    	'height' => '100%',
    ],
    'vAxis' => [
    	'format' => '0'
    ],
    'titlePosition' => 'none',
    'legend' => [
        'position' => 'bottom'
    ],
    'trendlines' => [ 
    	0 => [
	    'type' => 'exponential',
            'color' => 'green',
            'pointsVisible' => true,
            'pointSize' => 3,
            'lineWidth' => 10
        ] 
    ]
]);

View Code

$datatable = Lava::DataTable();
$datatable->addStringColumn('Total');
$datatable->addNumberColumn('Label');

foreach($records as $key => $item){
     $datatable->addRow([$key, $item]);
}

[kevinkhill]

did you mean?

$datatable = Lava::DataTable();
$datatable->addStringColumn('Label'); // this
$datatable->addNumberColumn('Total'); // and this

foreach($records as $key => $item){
     $datatable->addRow([$key, $item]);
}

[kevinkhill]

actually.... I hacked together your example and it seems that maybe the serialization of the options is losing the 0 index...

In:

[
    'title' => $title,
    'height' => 500,
    'chartArea' => [
    	'top' => 35,
    	'bottom' => 100,
    	'height' => '100%',
    ],
    'vAxis' => [
    	'format' => '0'
    ],
    'titlePosition' => 'none',
    'legend' => [
        'position' => 'bottom'
    ],
    'trendlines' => [ 
    	0 => [
	    'type' => 'exponential',
            'color' => 'green',
            'pointsVisible' => true,
            'pointSize' => 3,
            'lineWidth' => 10
        ] 
    ]
]

Out:

{
    "title": "Title!",
    "height": 500,
    "chartArea": {
        "top": 35,
        "bottom": 100,
        "height": "100%"
    },
    "vAxis": {
        "format": "0"
    },
    "titlePosition": "none",
    "legend": {
        "position": "bottom"
    },
    "trendlines": [
        {
            "type": "exponential",
            "color": "green",
            "pointsVisible": true,
            "pointSize": 3,
            "lineWidth": 10
        }
    ]
}

[kevinkhill]

I think you need to have the X axis as a date/datetime column and use the second for the data. I was able to create a trendline loosely based on what you gave me...