Assign chart data

[Timo]

How display a Chart Type "Bar Graph - Horizontal) using a query?

Code: Select all

SELECT cust_reason, count(cust_reason) as total 
FROM customers _data
WHERE DATE(cus_created) = CURDATE() 
GROUP BY cust_reason

Can I use nuRunQuery and assign its output to a Javascript Array?

[admin]

Timo,

You can do this on Before Edit.

Code: Select all

$a[] = ['State', 'Jan', 'Feb', 'Mar'];
$s   = "SELECT  state, SUM(jan_sales), SUM(feb_sales), SUM(march_sales) FROM dataset GROUP BY state";
$t   = nuRunQuery($s);

while($r = db_fetch_row($t)){
    $a[] = [$r[0], floatval($r[1]), floatval($r[2]), floatval($r[3])];
}

$j   = "window.gdata = " . json_encode($a) . ";";

nuAddJavascript($j);

Then you can use window.gdata in your Chart...

hchart.PNG

Steven

[Timo]

Thank you so much. One more question: If I use more than one chart, how do I assign data to window.gdata? Is there a window.gdata2 etc?

[admin]

Timo,

I think I understand your question, so let me say,

window.gdata is just a random variable I made up.

It is essentially a global variable that can be used anywhere.

I called it gdata, but you can call it whatever you want.


Steven

[Timo]

I see, thank you Steven.

[admin]

.