Exago Logo
Search
Generic filters
Exact matches only
Reporting

Pareto Charts

Pareto charts are a type of single-series chart generally used to highlight the most important element amongst a group. Pareto charts combine a Column chart, each column representing a data value sorted in descending order, with a Line chart, each point representing the cumulative percentage ...

Pie, Doughnut, Pyramid, and Funnel Charts

Pie Pie charts are used to show the relationship of individual data fields in a series as portions of the total data in the series. They are shaped like a circle divided into colored  "slices," each representing a data value. The area of each slice of the pie is proportional to the ...

Database and Data Type Functions

Used for determining the type of information contained in a cell. Helpful for error and sanity checks. DataRowCount Description Returns the number of rows retrieved from the data source when executing the report. Example Suppose report is run to retrieve basic information on ...

Date Functions

Date functions can be used to do calculations and formatting on date and time values.v2019.2.35 v2020.1.18 v2021.1.6 For all of the functions below except for DateCustomFormat() and Time(), passing Null(), DbNull() or any value that resolves to Null() or DbNull(), including null in a database ...

FilterValue and General Format Best Practices

The FilterValue function may take up to three arguments: Required: the filter’s index in the list of filters Optional: the sub-index, starting with 1 for filters that contain multiple values (e.g. filters with an Is Between, Is Not Between, Is One Of or Is Not One Of operator). If ...

Financial Functions

Common methods for monetary calculations such as interest and depreciation. Db Description Returns the depreciation of an asset for a specified period using the fixed-declining balance method. Cost is the initial cost of the asset. Salvage is the value at the end of the depreciation ...

Formatting Functions

Apply font styling changes (bold, italic, underline) to cell contents. Bold Description Applies bold font weight to the input. Example ="The second half of " & bold("this sentence is bold.") The second half of this sentence is bold. Italic Description Applies italic ...

Formula Editor

The Formula Editor's features guide users through creating formulas. Use the Search field to search through the functions by name. Or start typing in the Formula field to get a list of functions that match what's entered. TipSearch for data fields, report cells references, and parameters ...

Internal Parameters

The following parameters are built into the application and can be used on any report. Their names are reserved and cannot be overridden. Report Specific Parameters The following parameters are utilized within reports to gather specific report information. pageNumber Description Display the ...

List of Functions

All built-in functions are listed here.

Logical Functions

Logical functions can be used to handle conditional information. And Description Returns TRUE if all its arguments are TRUE; returns FALSE if any argument is FALSE. Remark The arguments must evaluate to TRUE or FALSE. NOTE. The And function can take more than two arguments as ...

Other Functions

CellValue Description Returns the value of the current cell. Remark Used in Conditional Formatting. Example Suppose a cell of a report displays the price of products. Ex. CellValue()> 150 returns True if the price of the product is greater than ...

Group Min/Max Filters

Group Min/Max Filters cause the report output to display detail containing either the highest/latest or lowest/earliest values in a field for either one group, multiple groups, or an entire data set.

Chart Advanced Features: Doughnut 2D

The following sections provide a list of available advanced attributes available for controlling and customizing 2D Doughnut chart elements. Note This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...

Chart Advanced Features: Doughnut 3D

The following sections provide a list of available advanced attributes available for controlling and customizing 3D Doughnut chart elements. Note This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...

Chart Advanced Features: Funnel

The following sections provide a list of available advanced attributes available for controlling and customizing Funnel chart elements. Note This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart wizard. ...

Chart Advanced Features: Heatmap

The following sections provide a list of available advanced attributes available for controlling and customizing Heatmap elements. Note This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart wizard. These ...

Chart Advanced Features: Line

The following sections provide a list of available advanced attributes available for controlling and customizing Line chart elements. Note This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart wizard. ...

Chart Advanced Features: Pareto 2D

The following sections provide a list of available advanced attributes available for controlling and customizing 2D Pareto chart elements. Note This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...

Chart Advanced Features: Pareto 3D

The following sections provide a list of available advanced attributes available for controlling and customizing 3D Pareto chart elements. Note This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...