OverviewThe data retrieved by Apsona reports can be displayed in a variety different of "visualizations", such as grouped lists, pivot tables and charts. Such visualizations make it easier to understand data and gain insight into relationships between data. Visualizations are available for both single-step reports and multi-step reports.
Below is a screenshot of a simple Opportunity report showing a few significant fields from the Opportunity record and the Account to which it belongs. We will use this report as the running example to show a few different visualizations.
Creating a visualizationThe selected visualization is available under the Visualization tab in the report display. To create a visualization, click the Visualize button at the top, and select the appropriate parameters in the panel that appears, as described below.
Single-column grouping and chartsTo create a grouping on a report column, select the "Single-level grouping" option. In the parameters area below, select the grouping field and the data to show in each group.
Groups with data recordsIn the first example (below), we group by the Account State column and show all the records in each group. This results in the grouped display shown below. Notice, in the above screenshot, that the value of the grouped column (in this example, the Account State) appears on the first row of each group. If you check the "Show subtotals" box, then the grouped column value appears in its own row, along with subtotals for each numeric or currency column, as in the screenshot below.
Grouping with aggregationInstead of showing the raw data in each group, we can choose "aggregate" functions such as count, smallest, largest, sum or average. In the example below, we show the sum of the Amount column and the newest Close Date. This results in the report shown below. Keep in mind that these calculations are carried out after the raw report data has been retrieved and displayed in the "Tabular data" tab, and then shown in the "Visualization" tab. The availability of aggregate functions is as follows.
- The count function is available for all fields.
- The smallest and largest functions are available for numeric, currency and date fields (they are called "oldest" and "newest" for date fields).
- The sum and average functions are available only for numeric and currency fields.