Queries allow you to run free form SQL queries on your database.
You can either build a query using the Scope Conditions method or enter an arbitrary raw SQL query that you might have previously built.
By default the results of a query are presented as a table but you can also choose to create a graph with the results.
When displaying query results as a table, the cells corresponding to a column which has Reference data associated to it will display the labels corresponding to the values.
Also, cells which content resembles an email address or an URL will be automatically linked.
If you select only one value per row, a frequency distribution graph will be drawn. This means that similar values will be grouped and the resulting graph will show you the count for each distinct values.
If you select multiple values per row, the first value you select will be used as the x-axis of the graph, the following values will be used as datasets. This implies that the first value you select can be a string or a number while the subsequent values must be numbers in order to be graphed properly.
If you want to graph the results as a scatter chart, you need to select two values per row and they have to be numbers.