Formulas allow you to do calculations, parse strings, insert images, and much more. Formulas are the composition of functions, parameters, Data Fields, and references to other cells.

Formulas can be used to create custom data columns in ExpressView. Formulas are calculated once per each row, based on the other data values in that row. For each row calculation, a formula value is returned for that row, which populate a new column of data. This article applies to versions of the application released prior to v2021.1.

In this video we’ll explore formulas, which allow us to modify a given cell’s contents.

The Report Wizard can be used to create a new Advanced Report in versions released before v2021.1. Use the Layout tab to initially place columns of data on the report.

Roles are created to specify how a user or group of users interfaces with Exago. Roles can restrict access to folders or data objects. Roles can also override the General Settings.

The Report Designer is the main editor for Advanced and CrossTab Reports. A full suite of reporting and design tools with a spreadsheet-like interface is available.

Sorting is the process of ordering data in a certain sequence.

The toolbar contains the buttons and menus used to modify the report. Modifications can include aesthetic formatting, inserting formulas and images, linking reports, and much more. This article applies to versions released before v2021.1.

The Filters menu in the Dashboard Designer toolbar is where filters are created, modified or removed, and imported prompting report filters can be modified. Use the Filters menu to add interactive filter tiles to the Dashboard Canvas.

The Design Grid is main interaction point of the Advanced Report Designer. Use the Design Grid to define the layout of the report by adding, altering and deleting rows, columns, and sections to it; and to define the content of the report by entering data fields, text, labels, formulas, images, charts, CrossTabs and maps to it.

Use the Design Grid to build the layout of the report. This article applies to versions of the application released before v2021.1.

Data Objects are the tables, views, methods, stored procedures, functions and custom SQL made accessible from the Data Sources for reports. This article applies to the Admin Console > Data > Objects settings.

Use a CrossTab, or cross tabulation, for grouping and summarizing data fields that expands vertically and horizontally depending on the number of data groupings. CrossTabs are also known as two-way tables, contingency tables, or pivot tables.

This article lists all the available keyboard shortcuts in the Web Application User Interface and describes their behavior in their applicable contexts.

A visualization is a graphical representation of data that can be designed directly on the Dashboard canvas without first creating a report.