|
 Note: this page is available if you
selected a table from the database as chart data source.
On this page you can add additional search conditions using
WHERE clause. To do this select a field in the first column and
type search criteria in the Filter and OR... text boxes on the right. Search
criterion should be added as <operator><value>. E.g.
='USA' or =2009 or <>'red' or >10.
Also you can define sort fields to sort the records in the
chart. To do this select a field in the first column and choose
sort type and sort order.
In addition, you can add group fields to group the results by
one or more columns and apply aggregate functions like MIN, MAX,
SUM, AVERAGE and COUNT. To do this select a field in the first
column, select the Group By
check box and choose one of values in the dropdown list box under
this check box. You can filter the records that a GROUP BY clause
returns using HAVING clause. To do this select a field in the first
column, select one of the aggregate functions and type the
condition as <operator><value> in the
textbox under Having. E.g.
>10 or = 500.
Example.
Number of employees per city
Let's build a chart showing the number of employees per city
except 'London'. We need to use WHERE clause to select employees
that are not working in London, GROUP BY clause to group records by
city and COUNT function to calculate the number of employees in
each city.
Use SQL Query button to
view resulting SQL query and query results.
|
