This section discusses basic functionality of the Ad Hoc Editor. Read to learn about:
Selecting report content
Formatting table appearance
Viewing and running a report in the editor
The Ad Hoc Editor also is helpful for exploring and analyzing data; for more information, see the section titled "Exploring and Analyzing Data in the Ad Hoc Editor."
To design a table in the Ad Hoc Editor:
From the Analytics Getting Started page, click Create a Report.
The Topics and Domains window appears.
On the Domains tab, expand Organizations in the hierarchy, and then select a Domain.
Select Table, and then click Choose Data.
The Ad Hoc Editor appears, showing available fields (in the left panel).
At the top of the table (Click to Add a Title), click in the area and enter a title for the report, and then press Enter.
Data for each field appear as you add columns to the table.
To change the list of fields available to the report, click (select...). From the Change field selection dialog, you can select additional fields from the Available list.
To view report data in chart form, click the Chart tab.
In the Report Name field, enter a report name.
Accept the default value for Location Folder, or click Browse to select a new location.
In the Description field, optionally enter a description for the report.
A range of options are available to change the appearance of a table. You can change:
Report style (colors)
Group and column labels
Spacing (add "spacers")
To format a table in the Ad Hoc Editor:
To change report style:
In the Search field, enter the saved report name, and then click Search.
The Search page appears, displaying objects matching the entered text.
In the Repository pane, right-click the report, and then select Open in Designer from the options menu.
The report appears.
Select a style, and then click Close.
To change the label for a group or column:
To resize a column:
Click a column header.
Borders appear on the column.
Move the cursor to the column edge until the resize arrows appear, and then drag the border left or right.
The column resizes to the selected size.
To change the format of data in a column:
When you have created a table, chart, or crosstab, you can save it in the repository for future use. In the Ad Hoc Editor, you can: