Userview Tutorial 1 - SQL Chart Tutorial

 Hello there,

Today i will show you on how JOGET handle Charts and Graphs as below:

1. Open your userview tab
2. Select and drop the 'SQL Chart' element in the 'category' area
3. Click 'edit'
4. Fill in the information as you desired (see below)

5. Put your database URL link (you can fine the default JOGET's Database connection URL at System Setting)

6. Click 'Show Advance Option' button and paste the following MySQL query

SELECT <column name1>, COUNT(*) FROM <table name> GROUP BY <column name1>;

7. Done! and the result