Versions Compared

Old Version 6

changes.mady.by.user Hugo

Saved on

compared with

New Version 7

changes.mady.by.user Hugo

Saved on

Key

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

...

NameDescription
SQL Query 

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

Info

The first column in the dataset will be assumed for X-axis/label.

Example 1:

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

Example 2:

Code Block
titleSQL
select c.c_claimant, sum( cast( replace(c.c_total,'$', '') as decimal(10,2)) ) as 'total', avg( cast( replace(c.c_total,'$', '') as decimal(10,2)) ) as 'avg' from app_fd_hr_expense_claim c group by c.c_claimant

Image Added

Image Added

Figure 4: SQL Chart Properties - UI

...