While creating datatable, one column value was taken and represented as sparkline. But I would like to filter that column using its value. Since the representation is that of sparkline, filtering is returning no value.

The sparkline representation using column value in datatable

"completion_percent" => array(
    
                 "label" => "نسبة الإنجاز",
                  
                 "cssStyle"=>"white-space:nowrap",
                 'formatValue' => function($val, $row) {
                    $data = $val;
                    return sparklines\Bullet::create(array(
                        "data" =>array($data,100),
                        "options"=>array(
                            "performanceColor"=>"#0f0",
                            "targetColor"=>"#f00",
                        )
                    ));
                    
                        
                    
                }

I have an input select box to choose the filter value. How to use the value in $data(from datatable column) to get the filtered results.

A snapshot of datatable

How to hide a column? tried this.but dint work

 "options"=>array(
    "columnDefs"=>array(
        array("targets"=> 10,"visible"=> false),
    )
)   

Thanks for the column hiding idea. It worked.