Contents

Answer

Requirements

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

Installation

  • Download from https://dashboardbuilder.net
  • 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"
Answer

Create your first Dashboard

Answer

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.

Answer

Click the Database icon

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


Answer

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

Answer

Preview:

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

Answer

Adjust size and position:

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

Answer

Save Data:

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

Answer

New Dashboard

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

Answer

Open an Existing Dashboard

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

Answer

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.