Query Wizard - Select Type

The Query Wizard - Type form lets you select the Type of Query that you want to create

clip5847

Standard Query	A standard query will return a row of data for every database record retrieved by the query. Use this type of query when when you want to create a dashboard where user can drill down to the lowest level of detail (for instance right down to the order line). The disadvantage of these queries is they return significant amounts of data, which may impact performance if the quantity of data is very high. Click on the 'Next >' button to move on to the Query Wizard - Select System screen
Summary Query	A summary query will summarise the data on the server before it is returned to the dashboard. Use this type of query when you want to create a responsive dashboard based on large data sets. The disadvantage of these queries is the user will only be able to drill down to the level you have summarised at. Click on the 'Next >' button to move on to the Query Wizard - Select System screen.
Trending Query	A summary query will summarise the data on the server before it is returned to the dashboard. Use this type of query when you want to create a responsive dashboard based on large data sets. The disadvantage of these queries is the user will only be able to drill down to the level you have summarised at. Click on the 'Next >' button to move on to the Query Wizard - Select System screen
Freeform SQL Query	A freeform SQL query allows you to manually enter an SQL query to retrieve data Click on the 'Next >' button to move on to the Query Wizard - Select System screen
Import data from a file	This query type allows you to import data from common file types such as Excel and csv files Click on the 'Next >' button to move on to the Query Wizard - Import from a File screen
Blending Query	A blending query allows you to blend data from two or more seperate sources into a single data table Click on the 'Next >' button to move on to the Query Wizard - Select Blend Sources screen
Google Analytics Query	A Google Analytics query allows you to create queries that extract data from the web analytics service offered by Google that tracks and reports website traffic.
Open API Query	An OpenAPI query allows you to create queries that call a method in a bespoke assembly to generate data. They allow developers to build their own data sources. For more details on using this type of query, see How do I create an open API query?

If you are creating a query on an ODBC based system then the Query is always a Standard Query but you do have the option of not selecting a Subject. If you do this then you will be taken to a step in the Query Wizard where you can enter an SQL select statement that will be used to retrieve data.

Click on '< Back' to return to the Query Wizard - Introduction form.

You can click on Cancel (at any time) to leave the Query Wizard without saving your changes.