Hello Koolreport team my SP returns the following data set

My datasource code is as follows

 $this->src('db')
            ->query("EXEC rp_get_test @invtId = :invtId, @entryDateEnd = :EndDate")
            ->params(array(
                "invtId" => $invtId,
                "EndDate" => $endDate,
            ))
            ->pipe($this->dataStore("NAVNEW"));

Note: I am able to render a basic table to verify the data

My view code is as follows

use \koolreport\d3\Waterfall;

Waterfall::create([
                                    "dataSource" => $this->dataStore('NAVNEW'),
                                    "columns" => [
                                        "entryType",
                                        "amt" => [
                                            "format" => "function(d){
                                                return `\${Math.round(d / 1000000)}M`;
                                            }"
                                        ]
                                    ],
                                    "yAxis" => [
                                        "prefix" => "$",
                                    ]
                                ]);

Rendered waterfall graph

Am I missing something here? Please help

it works!!! Thank you so much...

On a separate note, I am using this chart for financial reports. usually, the first column represents the starting/carryover amounts, Is there a way to customize the color for the first column only?

Regards Sajid