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

Last updated