List reports
Using Query Studio, you can create simple reports in column format. You can insert and format columns, move them around, add a report title, and change fonts.
Calculated columns
In Query Studio, you can create calculated columns from other columns in the report. For example, you can create a revenue column from the price and quantity columns. You can also delete the columns used in a calculation without affecting the calculated column.
Grouped list report
In Query Studio, you can group on a column to remove duplicate values. A grouped column automatically sorts the column values and generates summary information for the numeric data to which it refers. You can create sections to group on a column, filter on a column, and ungroup a column.
Crosstab report
In Query Studio, you can organize your report in a crosstab format. Crosstab reports summarize data so that you can analyze it in relation to both rows and columns. You can create a crosstab report to rotate rows and columns to insert a column into a crosstab, create sections, and apply templates.
Chart
In Query Studio, you create a chart from an existing report. Query Studio includes a selection of chart types that work with one or more columns of numeric data. You can view charts with or without the report information. You can create a column chart, hide the menu, create a pie chart, and move column around.
Custom groups
In Query Studio, you can assign a range of values from one column to a single group value defined in another column. For example, you can create two views of product margins in which margins are either 40% or more, or less than 40%. You can customize groups to group a column.