View Types
View Name | Description |
---|---|
Title | Displays a title, a subtitle, a logo, a link to a custom online help page, and timestamps to the results. |
Table | Displays results in a visual representation of data organized by rows and columns. A table provides a summary view of data and enables users to see different views of data by dragging and dropping rows and columns. |
Pivot Table | Displays results in a pivot table, which provides a summary view of data in cross-tab format and enables users to see different views of data by dragging and dropping rows and columns. Pivot tables structure data similarly to standard tables that contain column groups, but can display multiple levels of both row and column headings. Unlike regular tables, each data cell in a pivot table contains a unique value. By organizing data in this way, a pivot table is more efficient than a row-based table. Pivot tables are ideal for displaying a large quantity of data, for browsing data hierarchically, and for trend analysis. |
Graph | Displays numeric information visually, which makes it easier to understand large quantities of data. Graphs often reveal patterns and trends that text-based displays cannot. However, when precise values are needed, graphs should be supplemented with other data displays, such as tables. A graph is displayed on a background, called the graph canvas. For the types and subtypes of graphs that are available, seeGraph Types . |
Funnel | Displays results as a three-dimensional graph that represents target and actual values using volume, level, and color. Typically, funnel graphs are used to graphically represent data that changes over different periods or stages. For example, funnel graphs are often used to represent the volume of sales over a quarter. Funnel graphs are well suited for showing actual compared to targets for data where the target is known to decrease (or increase) significantly per stage, such as a sales pipeline. In funnel graphs, the thresholds indicate a percentage of the target value, and colors provide visual information for each stage. You can click one of the colored areas to drill down to more detailed information. For the types of funnel graphs that are available, see Funnel Graph Types. |
Gauge | Shows a single data value. Due to its compact size, a gauge is often more effective than a graph for displaying a single data value Gauges identify problems in data. A gauge usually plots one data point with an indication of whether that point falls in an acceptable or unacceptable range. Thus, gauges are useful for showing performance against goals. Depending on the data in the analysis, a gauge view might consist of multiple gauges in a gauge set. For example, if you create a gauge view to show the sales data for the last twelve months, the gauge view consists of twelve gauges, one for each month. If you create one to show the total sales in the US, then the gauge view consists of one gauge. A gauge or gauge set is displayed on a background, called the gauge canvas. For the types of gauges that are available, see Gauge Types. |
Trellis | Displays multidimensional data shown as a set of cells in a grid, where each cell represents a subset of data using a particular graph type. Data can be represented with graphs, microcharts, and numbers. The trellis view has two subtypes: Simple Trellis and Advanced Trellis. Simple trellis views are ideal for displaying multiple graphs that enable comparison of like to like. Advanced trellis views are ideal for displaying spark graphs that show a trend. A simple trellis displays a single inner graph type, for example a grid of multiple Bar graphs. The inner graphs always use a common axis; that is to say, the graphs have a synchronized scale. An advanced trellis displays a different inner graph type for each measure. For example, a mixture of Spark Line graphs and Spark Bar graphs, alongside numbers. In this example, the Spark Line graph might show Revenue over time, and the Spark Bar graph might show Units Sold. A measure column displaying numbers might be placed adjacent to the Spark Line graphs, showing the Revenue measure as a total value for a year. In an advanced trellis, each measure column operates independently for drilling, axis scaling, and so on. For definitions of microchart, and spark graph, see Trellis View Terms. |
Filters | Displays the filters in effect for an analysis. Filters, like selection steps, allow you to constrain an analysis to obtain results that answer a particular question. Filters are applied before the query is aggregated. |
Selection Steps | Displays the selection steps in effect for an analysis. Selection steps, like filters, allow you to obtain results that answer particular questions. Selection steps are applied after the query is aggregated. |
Column Selector | Adds a column selector in the results. A column selector is a set of drop-down lists that contain pre-selected columns. Users can dynamically select columns and change the data that is displayed in the views of the analysis. |
View Selector | Adds a view selector in the results. A view selector is a drop-down list from which users can select a specific view of the results from among the saved views. |
Legend | Adds a legend to the results, which enables you to document the meaning of special formatting used in results, such as the meaning of custom colors applied to gauges. |
Narrative | Displays the results as one or more paragraphs of text. You can type in a sentence with placeholders for each column in the results, and specify how rows should be separated. |
Ticker | Displays the results as a ticker or marquee, similar in style to the stock tickers that run across many financial and news sites on the Internet. You can control what information is presented and how it scrolls across the page. |
Static Text | A dds static text in the results. You can use HTML to add banners, tickers, ActiveX objects, Java applets, links, instructions, descriptions, graphics, and so on, in the results. |
Logical SQL | Displays the SQL statement that is generated for an analysis. This view is useful for trainers and administrators, and is usually not included in results for typical users. You cannot modify this view, except to format its container or to delete it. |