Hello Kool Team, I am trying out the Progress card and will want to achieve the following from a query below

				->query("select 
						to_char(coalesce(max(date_approved),current_date), 'MON,YYYY') as cur_year,
						coalesce(sum(comp_amount),150000) as comp_value, 
						coalesce(sum(budget_value),1000000) as base_value
						FROM 
						a
						inner join b on a.la_project_id=b.la_project_id
						inner join c on b.la_project_id=c.la_project_id
						")->pipe($this->dataStore("crop_card"));

I want the query to supply the values for "title", "infoText" "value"=>7500 and "baseValue" as found in your sample below so that every thing is dynamic. How do I go about it from your sample below

\koolreport\amazing\ProgressCard::create(array(
    "title"=>"April 2018",
    "infoText"=>"The sale on April 2018 has completed {indicatorValue} of revenue target.",
    "value"=>7500,
    "preset"=>"primary",
    "baseValue"=>10000,
    "format"=>array(
        "value"=>array(
            "prefix"=>"$"
        ),
        "indicator"=>array(
            "decimals"=>0
        )
    ),
    "cssClass"=>array(
        "icon"=>"fa fa-euro"
    ),
));

Hello, Many thanks. It worked but getting the following error

Here is the code block used

 ProgressCard::create(array(
            "title"=>$this->dataStore("crop_card")->get(0,"cur_year"),
            "infoText"=>"Met {indicatorValue} of Land Access expenditure target.",
            "value"=>$this->dataStore("crop_card")->get(1,"comp_value"),
            "preset"=>"primary",
            "baseValue"=>$this->dataStore("crop_card")->get(2,"base_value"),
            "format"=>array(
                "value"=>array(
                    "prefix"=>"GH¢"
                ),
                "indicator"=>array(
                    "decimals"=>0
                )
            ),
         /*    "cssClass"=>array(
                "icon"=>"fa fa-usd"
            ), */
        ));

The values coming out of the script $this->dataStore("crop_card")->get(2,"base_value"), is 0. But actual data format is numeric, must it be varchar?

I do not get the value displaying but rather 0 displays. Please I need urgent help!.

Hello, Base value will not be zero giving the query values as shown. if it is null it will default to 1000000

coalesce(sum(comp_amount),150000) as comp_value, 
coalesce(sum(budget_value),1000000) as base_value

Hello Any help?