ExpressView

The ExpressView designer is data discovery and reporting tool that simplifies grouping, sorting, filtering, and aggregating data with a drag-and-drop interface. A chart can be added with a single click, and ExpressViews can be styled and saved as PDF, RTF, CSV, or Excel files.

Making an ExpressView

ExpressViews allow you to quickly see data and make reports without concern for the minutiae of old-fashioned report building.

To make an ExpressView:

  1. Click the New Report icon and select ExpressView.

    Info. The ExpressView designer is divided into the Data pane on the left, and the Design pane in the middle. The Data pane comprises all of your accessible data categories, containing groups of related data fields. For more information, see Data categories and fields.

  2. Expand a category by clicking the arrow icon. This shows the fields in that category.

  3. Drag a field onto the Design pane to add it to the ExpressView. This expands the field into a data column. It will only show placeholder data initially.

  4. Continue to add fields as desired. Fields can be added or removed at any time.

    Note. As you add fields, unrelated fields will become unavailable. To learn about how fields relate to each other, see Joins.

  5. When you are satisfied with your data selection, click Live Data to populate the ExpressView with data. You can now page through your data using the navigation icons     in the toolbar.

  6. Click the Save icon to save the ExpressView. In the Settings window, enter a Name and select a folder where it should live. Then click Save Report Info.

These steps illustrate how quick it is to make a tabular report from scratch using ExpressView. But ExpressViews can be more than just basic reports. You can make groups, charts, calculations, and customize the look of the report. And it is all designed to be easy to use. The following sections will describe how to use these powerful features.

About the radial menu

Throughout this topic you will see references to a menu called the radial menu. The radial menu is a menu of options for each data column and group, which is accessed by clicking the colored Radial  icon on the top left of the column or group.

 ...  ...

Using the radial menu

Each radial menu has four options, arranged in a circle around the center. When you are prompted to select a radial menu option, you will be asked to "use  radial>direction". Direction is one of the four cardinal directions corresponding with one of the four options: left, right, up, down.

For example, "use  radial>left" means to open the radial menu and select the left option. To do this, you have two options:

  1. Click the radial icon, move your cursor left, then click again.
  2. Click-and-hold the radial icon, drag your cursor left, then release.

To close the radial menu without selecting an option, click in the center.

Grouping and summarizing data

Grouping a column of data breaks up the rows into sections which share a common trait. Each iteration of a group is a unique row in a data column. Grouping data allows you to easily identify rows with common factors. You can perform calculations on groups, such as counting the rows, or adding up the data in each iteration.

 

Grouping data in an ExpressView

Making a group

To create a group from a column, use  radial>up. This turns the data column into a group column, and organizes the other columns by each unique row in the group. Each row in the data column becomes a group section, or iteration, and the rows in other columns are grouped by the section which they are related. The group is also given a new color to distinguish it from the data rows. Remember to turn Live Data on to see your actual data and verify that this is the grouping you want.

To ungroup a column, use  radial>left. This turns the group column back into a data column.

Groups can be created inside other groups. These are called nested groups. To make a nested group, simply add another group to an ExpressView which already has one. This creates another grouping inside the existing group. Additional levels of nesting can be made as needed.

Changing group level

If you have two or more levels of grouping, you may decide that they are nested improperly. For example, if you had Products grouped by Orders, then you add another grouping on Employees, you may end up with Products grouped by Employees grouped by Orders.

Improper grouping of data fields

However, it makes more sense to have Orders grouped by Employees instead, since Employees have multiple Orders, but Orders does not have multiple Employees. To move the Employees group up one level, use  radial>up on the group column.

Proper grouping of data fields

Summarizing group data

Each iteration has a footer, which contains summary calculations, also known as aggregates, for each column. The ExpressView also has a report footer, which calculates the aggregate across all the groups. You can choose between several options for which calculation you want to appear in the footer for each column.

To change the calculation for a column, click a footer and select one of the following options:

Sum

Totals the data values in the iteration. Only available for numeric fields.

Min

Shows the smallest data value, or first value alphabetically, or earliest date in the iteration.

Max

Shows the largest data value, or last value alphabetically, or latest date in the iteration.

Count

Counts the number of values in the iteration.

Distinct Count

Counts the number of distinct values in the iteration.

Avg

Takes the average, or arithmetic mean, of the values in the iteration. Only available for numeric fields.

Hiding data rows

If you only want to see the summary calculations, you can hide the data rows, either per-iteration, or for every group in the ExpressView. This does not remove the data or alter the summaries. It only hides the rows from view.

To hide the rows for one iteration or several iterations, click the group header for each iteration to toggle whether its rows are shown or hidden.

To hide or show all the rows in the ExpressView:

  1. Click the Expand/Collapse  icon.
  2. Click  Hide All Group Content to hide all the rows, or  Show All Group Content to show all the rows.

If you have nested groups, this hides all but the top level groups.

Managing data

You can exercise some fine grained control over the actual data that appears in the ExpressView. You can choose how the data appears, you can filter down the rows to appear, and you can change the order of rows in their respective sections.

Formatting data

Formatting allows you to specify a data type for specific data fields, and choose how that data displays.

To change the data type for a field:

  1. Click the Formatting  icon to open the Formatting page.

  2. Click the data rows to format. They will highlight in blue.

  3. Click the Data Format tab.

  4. From the Format Type list, select a data type from the following options:

    General

    Format the data using the default settings for your environment. The application will assume the data type.

    Number

    Format the data as a number. Continue to step 5.

    Date

    Format the data as a date, time, or date and time. Skip to step 6.

    Text

    Do not apply any formatting to the data, and show it exactly as it appears in the database.

  5. Optional: If you selected Number you can choose how the number displays. You can customize the following options:
    1. In the Decimal Places field, enter a number for how many decimal places to display. In the field to the right, enter a symbol to use as the decimal mark.
    2. To show a delimiter every three digits, select Use 1000 Separator. Then, in the field to the right, enter a symbol to use as the delimiter.
    3. To show a symbol before the number, indicating that this is currency, select Use Currency Symbol. Then, in the field to the right, enter the symbol to show.
    4. To show a percent sign after the number, indicating that this is a percentage, select Append Percent Sign.
    5. To show no value if the number is 0, select Blank When Zero.
    6. To show the negative symbol in front of negative numbers, select Show Negative Symbol.
    7. To show parentheses around negative numbers, select Show Parenthesis.
    8. To show negative numbers in a different color, select Color, then enter a hex value or use the color picker to choose a color.
  6. Optional: If you selected Date, you can choose which date and time components to display, and how to show them.

If the data field cannot be formatted as a number or date, then selecting one of those options will have no effect on the appearance of the data.

Reordering data rows

Sorting allows you to set the order that the data rows appear in each section. Click the Sorts  icon to open the list of sorts. Every data column in the ExpressView that is not a group column is automatically sorted.

You can choose which columns take precedence for sorting. The order of fields on the Sorts page is their order of precedence, from highest to lowest. Their order is also indicated by a number on the right of the column headers: The lower the number, the higher the precedence.

To set the sort precedence of data fields, either:

You can choose which direction to sort the data for each data field: ascending or descending. A field's sort direction is indicated by an arrow on the right of the column header: Up  for ascending, down  for descending.

To change a field's sort direction, either:

For more information on sorting data, see Sorts.

Narrowing your data

Filtering allows you to narrow the scope of your ExpressViews by restricting the amount of data shown. You can filter data by only showing rows whose values satisfy certain conditions. These are Standard filters. You can also filter data to only the rows with the top or bottom values, for either data fields or data summaries, per group iteration. These are Top N filters. For more information, see Filters.

Click the Filters  icon to open the list of filters. The filters page has two tabs: Standard and Top/Bottom.

To show only the data that satisfies several conditions:

  1. On the Filters page, click the Standard tab.

  2. To add a data field to filter, either:

  3. Choose a filter operator from the list. See Filters for details.

  4. Enter a filter value or values, or select them from the list.

  5. Repeat steps 2-4 for every filter condition that the data must satisfy in order to show.

To show only the data that satisfies at least one of several conditions:

  1. On the Filters page, click the Standard tab.

  2. To add a data field to filter, either:

  3. Choose a filter operator from the list. See Filters for details.

  4. Enter a filter value or values, or select them from the list.

  5. Repeat steps 2-4 for every filter condition, of which the data must satisfy at least one in order to show.

To show only the top or bottom values, for either data fields or data summaries:

  1. On the Filters page, click the Top/Bottom tab.

  2. Select the Limit the report to the top/bottom values check box.

  3. Select either Top or Bottom, for whether you want to show the top or bottom values.

  4. Enter a number for how many values you want to show.

  5. Choose how you want to limit your data:

  6. Select the data field or group field to filter from the Of list.

  7. Optional: To show the top or bottom values for each iteration of a group:

    1. Click  Add Group.

    2. Select a group field from the For Each list.

Making visualizations

Charts allow you to showcase your data in a visual format. They allow you to quickly scan your data for patterns and trends. Charts can be easily made and customized in ExpressViews, in as little as one click.

To add a chart to an ExpressView:

  1. Click the Show Visualization  icon. A bar chart is added and populated with the data from your ExpressView.

  2. In the Visualizations pane, select the type of chart you want to use. The chart immediately swaps to that type.

Click on a chart series to drill down into the data for that series. This filters the data columns to only the series you select.

You can add many more personal touches, small or large, to the visualizations you create. See the following sections for details on how to customize your visualizations.

Choosing chart data

When a visualization is first added, the application presets the chart fields to try to match the ExpressView data as closely as possible. This may not always match the data that you want the chart to use.

To see the chart data fields, click the Visualizations  icon, then click the Data tab. There are two fields: Labels and Values.

Labels

The Labels field is a group of data values, each iteration of the group represented as a series on the chart. For example, using an Employees group field as the label field represents each employee as a series.

Several charts allow an additional labels field. This is useful if you have a nested group, which represents common series to be measured across several groupings. For example, to compare the number of sales per product per employee, you could add a nested Product field as a second label to the aforementioned employees chart.

To add a chart label, either:

Values

The Values field is the data values to plot on the chart for each iteration of each labels group. For example, the number of sales per employee.

Several charts allow for multiple values fields. This is useful if you have common series to be measured across several groupings, and the values fields are in the same data row. For example, the number of sales and number of lost sales per employee.

To add a chart value, either:

Customizing appearance

ExpressViews can be styled in a variety of ways. Click the Formatting  icon to see your available options.

Using a premade theme

If there are any available, you can select a premade theme to use for the ExpressView, or to use as a baseline for further customizations. On the Formatting page, click the Theme tab. Then select a theme from the Theme Selector list:

Legacy

This is the default theme.

Custom

This option indicates that you are not currently using a premade theme.

Selecting a premade theme overrides any custom styling you have. Be sure to save the ExpressView first, so that you can retrieve your styling if you accidentally override it.

Styling data cells

Data columns and group columns can be styled independently, using the Style tab on the Formatting page. You can style the data cells, as well as group headers and footers.

To style a data cell:

  1. With the Formatting page open, click the section, header, or footer you want to style. It will highlight in blue.
  2. Click the Style tab.
  3. Choose a look for the cell text and background.

You can also use the Formatting page to edit the header names of the data columns. To do so:

  1. With the Formatting page open, click the header which you want to edit. It will highlight in blue.
  2. Click the Edit  icon on the header.
  3. Type a name for the header.
  4. Press Enter.

Changing data row colors

The background colors for the data rows can be customized, and you can set the pattern by which the colors alternate. This affects every data section in the ExpressView.

To set the background colors:

  1. On the Formatting page, click the Row Shading tab. By default there are two colors which alternate every other row.
  2. Choose the number of colors that you want to alternate between:
  3. Enter a hex value or use the color picker to set each color.

Changing group colors

The headers and footers for group columns are prefixed by a different color depending on the level of grouping. These colors can be customized, and you can set the pattern by which the colors alternate. This affects every group header and footer in the ExpressView.

To set the group level colors:

  1. On the Formatting page, click the Group Colors tab. By default, nested groups alternate between four colors.
  2. Choose the number of colors that you want to alternate between:
  3. Enter a hex value or use the color picker to set each color.

Data categories and fields

The data pane is organized into data categories, which you can expand to see their fields. To learn about data categories, see Categories.

To locate a specific data field, type the name of the field into the Search field and press Enter. To see all the data fields, click  to clear the search field.

You can show only data fields of a certain type by clicking one of the type icons under the Search field:

All available data categories are usable on an ExpressView. You do not have to worry about adding categories manually or thinking about join structure. Adding a data field is as simple as dragging it onto the Design pane. This turns it into a data column. Use  radial>left to remove a data column.

Exporting an ExpressView

ExpressViews can be used as a starting point to quickly add fields to a report, before delving into some of the more advanced reporting capabilities. The ExpressView format is not compatible with the report designer, but you can export it to an Advanced Report and edit the copy.

To export an ExpressView to an Advanced Report:

  1. Click the Settings  icon.
  2. Click the Create Advanced Report tab.
  3. Enter a name for the report and select a folder where it should live.
  4. Click Create Advanced Report.

If you to save an ExpressView as a file, it be exported as PDF, RTF, CSV, or Excel. Each format has some advantages and disadvantages.

Export settings

You can make some customizations to the appearance that the exported files will take. With the Settings page open, click the Export Settings tab to see the available options: