• PHP Version 5.6 or later
  • Apache 2 or later
  • Windows 7 or later /Linux 3 or later
  • Firefox 52, Chrome 57, IE 8


  • Download from
  • Place the files in a directory on the web server. e.g. “…/www/dashboardbuilder/”
  • Unzip the file using Extract Here option to the root folder of "dashboardbuilder"

Create your first Dashboard


Select Database as Data Source:

Click the Database icon

Now, select Database from Data Source Settings. Enter your host name, username, password and the database name as mentioned in the screen.


Click the Database icon

Now, select Upload from Data Source Settings. XLSX, XLS or CSV can also be selected as data source


Select the gear icon for your Chart preference. The following screen will appear

SQL statement format

Enter your SQL statement in SQL filed as following manner
SELECT sum(salary) as xaxis, DATE_FORMAT(from_date, '%Y/%m') as yaxis FROM salaries GROUP BY DATE_FORMAT(from_date, '%Y/%m') LIMIT 10
You must define your Trace data for X as 'xaxis' and data for Y as 'yaxis' as mentioned above.
Click on the SQL   sign if you want to add more SQL statement

Select the desired table and click  Run Query   button

Select your Chart Type, Trace and its Properties.
DashboardBuilder currently supports, Line, Bar, Stack, Histogram, Area, Pie, Donut and Bubble Chart

Click  Save Changes   when you finish



On the Chart Prefernece shcreen, click  Save Changes  , Charts will be appeared on the screen as shown below.


Adjust size and position:

To adjust the size and the position of the Chart Panel by dragging its corner


Save Data:

Click Save   button. The following screen will appear. Give a name to your file and click Save button.


New Dashboard

Click New  button. The following screen will appear. Now click Yes.


Open an Existing Dashboard

Click Open   button. The foloowing screen will appear. Select your file from the given list


Generate a PHP Code

Click Generate  button
The following screen will appear with PHP code

Click the Copy+Past button to copy the code and paste into your PHP application
You also need to copy the required API file/folder i.e 'inc/dashboard_dist.php' and 'assets/js/dashboard.min.js' to the folder where your application is running.