如何在highcharts中显示所有数据？ [关闭]

Question

I have input all of my data in controller and view. I took data from database anyway. When I try to run my code, not all of the data appeared in chart display. For example, I want to display 11 data in xAxis. But, only 10 data that can be displayed in xAxis.

I have table like this:

I have controller like this: https://pastebin.com/M2QFF73V

I have view like this: https://pastebin.com/cZ2B4hXM

my codes result:

there is year 2015 in table but why 2015 didn't display in chart? why the chart just displayed 10 data?

How to display all of data?

Thanks in advance

Answer 1

Your query has limit set to 10

 durasistudi = (new \yii\db\Query())
        ->select(['TahunMasuk'])
        ->from('temp_jmlhdurasisstudimagister')
        ->limit(10)
        ->column();

    $durasistudi1 = (new \yii\db\Query())
        ->select(['lessthan2'])
        ->from('temp_jmlhdurasisstudimagister')
        ->limit(10)
        ->column();

    $durasistudi2 = (new \yii\db\Query())
        ->select(['btween2,0to2,4'])
        ->from('temp_jmlhdurasisstudimagister')
        ->limit(10)
        ->column();
    $durasistudi3 = (new \yii\db\Query())
        ->select(['btween2,5to2,9'])
        ->from('temp_jmlhdurasisstudimagister')
        ->limit(10)
        ->column();
    $durasistudi4 = (new \yii\db\Query())
        ->select(['btween3,0to3,4'])
        ->from('temp_jmlhdurasisstudimagister')
        ->limit(10)
        ->column();
    $durasistudi5 = (new \yii\db\Query())
        ->select(['btween3,5to3,9'])
        ->from('temp_jmlhdurasisstudimagister')
        ->limit(10)
        ->column();
    $durasistudi6 = (new \yii\db\Query())
        ->select(['morethaneqs4,0'])
        ->from('temp_jmlhdurasisstudimagister')
        ->limit(10)
        ->column();
    $durasistudi7 = (new \yii\db\Query())
        ->select(['TidakDiketahui'])
        ->from('temp_jmlhdurasisstudimagister')
        ->limit(10)
        ->column();