Area Chart

This widget function displays an area chart whenever you call it. You can pass in multiple data sets if you wish to have multiple data sets displayed on chart.

Structure

showAreaChart($chartTitle = "Title Of The Area Chart", $chartData, $datasetLabel, $chartSize = "col-md-12")

Parameters

The function accepts 4 parameters that are illustrated below

• Chart Title- This is the title of the chart

• Chart Data- An array with multiple sql queries as values, each query needs to have 2 fields to be used that is: label and value

• Dataset Label- An array with all the labels for your datasets provided

• Chart Size= This is a bootstrap class for chart size, default is col-md-12

Example Usage

echo showAreaChart("ORDERS SUMMARY", [sql("SELECT COUNT(*) AS value,YEAR(OrderDate) AS label FROM orders GROUP BY YEAR(OrderDate) ORDER BY YEAR(OrderDate) DESC", $eo), sql("SELECT COUNT(DISTINCT CustomerID) AS value, YEAR(OrderDate) AS label FROM orders GROUP BY YEAR(OrderDate) ORDER BY YEAR(OrderDate) DESC", $eo)], ['Total Orders', 'Total Customers'], "col-md-6");

In the above chart I have passed in only 2 queries as array values for my chart data and 2 labels as array values for my dataset label. If you wish to have a single dataset, you just provide 1 query and 1 dataset label.

Output

Area Chart Output