Admiro Dashboard Theme For Appgini
  • Introduction
  • Installation Guide
  • General Settings
  • Table Menu Settings
  • Dashboard Builder
  • Custom Page Builder
  • Reports Builder
  • Translation Tool For Admiro
  • File Manager
  • Widget Functions
    • Data Card
  • Sweet Alert
  • Alert
  • Welcome Banner
  • Statistics Counter Card
  • Basic Table
  • Data Table
  • Modal
  • Full Calendar
  • Drop Zone
  • Line Chart
  • Area Chart
  • Bar Chart
  • Column Chart
  • Pie Chart
  • Donut Chart
  • Timeline Chart
  • Options
Powered by GitBook
On this page
  • Structure
  • Parameters
  • Example Usage
  • Output

Column Chart

PreviousBar ChartNextPie Chart

Last updated 8 months ago

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

Structure

showColumnChart($chartTitle = "Title Of The Bar 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 showColumnChart("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

Column Chart Output