Before identifying where the advanced features of the product can be leveraged in the document, it is important to review the different sections of the software. The following list provides an overview of each section of the Interactive Reporting software:
The Data Model and Query sections are used to model database objects and build queries from a data source.
Each Query section is accompanied by a Results section where data returned from a query is displayed, filtered, and computed. There is only one Results section per Query section, and each Results section displays data in a row by column format.
Table sections are similar to Results sections and are used to manipulate and split a set of results into different subsets for analysis. Each table section is specific to a set of results and multiple table sections can be created.
A Pivot section is a common presentation section in Interactive Reporting that aggregates data in a row by column format and the pivot functionality is similar to Microsoft Excel pivots. The Pivot section can use any column of data from the parent Results or Table section.
A Chart section is another presentation section of the document. The Chart section is commonly used to display data in a graphical format. Different chart formats exist, ranging from bar and pie charts to scatter and bubble charts.
The Report section provides the ability to present charts and tables of data in a printable report format. The Report section is the only section of the document that allows for the addition of data from multiple queries in the document into a single reporting object, and reports provide an additional method of splitting out data by Report Groups.
Dashboards are used to create custom interfaces or interactive displays of key metrics. The dashboard section provides the flexibility to leverage custom scripting and interactivity to automate manual features of the product.