Versions Compared

Old Version 4

changes.mady.by.user Hugo

Saved on

compared with

New Version 5

changes.mady.by.user Hugo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL Chart equips you with another medium of reporting by using charts. You are given the flexibility of defining your own SQL query to determine the charts that you would like to generate, ranging from a number of graph types.

Figure 1: SQL Chart Properties

...

NameDescription
SQL Query 

SQL Query to produce the dataset required for the graph type. 

Code Block
titleExample
SELECT c_status as 'status', COUNT(c_status) as 'count' FROM app_fd_tix_tickets WHERE c_status IS NOT NULL GROUP BY c_status

Figure 4: SQL Chart Properties - UI

...