Exago Logo
Search
Generic filters
Exact matches only
Reporting

JSONExtract Function

Pick out one or more portions of a JSON input string as a single value, an array of values, a JSON object, or list of items, via a standard JSONPath expression.

Report Types

There are five different report types available in the reporting application. Four are standalone types, and two are composite types which combine reports together.

Report Viewer

This document covers several versions of the application. Use the Viewing content for dropdown to see only the content relevant to a specific application version. Executing an Advanced Report or CrossTab Report presents the data output in a paged, interactive format called the Report Viewer. ...

Sorting by Aggregates

To sort groups by the summary, or aggregate, calculation of each group of an Advanced Report, use Top/Bottom filters. Top/Bottom filters look for the highest or lowest values in a set, and then put those values in order. Any arbitrary cell in the report can be the Top/Bottom filter.

Advanced Reports: Templates

An Advanced Report can be used to dynamically fill out fields in forms and other documents, called templates.. Placeholders in the template are dynamically linked to fields in the report. When executed, the form or document is merged with the report data.

User Preferences and Context Sensitive Help

User Preferences Note The User Preferences are an optional feature. Check with the system administrator for more information. Click the User Preferences icon to open the User Preferences dialog. The dialog consists of tabs: Tutorials v2018.2–v2020.1 Startup Reports User ...

Scatter and Bubble Charts

Scatter Scatter charts use pairs of data values as coordinates for points on a grid. They are often used to find relationships between two variables in a set of data. Scatter charts can be single-series (one set of points) or multi-series (multiple sets of points). On a multi-series chart, ...

Spark Charts

Spark Line Spark line charts are a variation of a single-series Line chart. They are used to display continuous trends in data, usually with regard to time. Spark line charts have no grid or axes and instead rely on point labels and benchmark lines to provide reference. Spark line charts are ...

Tabular Visualizations

Tabular Visualizations are only available to Dashboards in v2019.2+ of the application. Tabular Visualizations A Tabular Visualization as its name entails, displays content in a table like format. Unlike the other visualization types, tabular visualizations can display any number of ...

String Functions

String functions are commonly used for interpreting and manipulating text fields. Concatenate Description Joins several text strings into one text string. Remark The "&" operator can be used instead of Concatenate() to join strings Example Concatenate("This ","is ","one ","string!") ...

What are formulas?

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.

Top/Bottom Filters

Top/Bottom filters, also known as Top N filters can be added to a report. Top N filters allow you to filter data to only the rows with the top or bottom values, for either data fields or data summaries, per group iteration. Top/Bottom filters work after all other filters have been applied. ...

Chart Advanced Features: Samples

The Advanced Features in the Chart Wizard allow for fine grain control over the chart and its components. Use the examples in this article as inspiration when designing reports and charts. Area Charts Add a Bordering Line An area chart displays its data by shading in the area below the curve. ...

Chart Advanced Features: Scatter

The following sections provide a list of available advanced attributes available for controlling and customizing Scatter 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: Spark Column

The following sections provide a list of available advanced attributes available for controlling and customizing Spark Column 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: Spark Line

The following sections provide a list of available advanced attributes available for controlling and customizing Spark Line 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: Spline Area

The following sections provide a list of available advanced attributes available for controlling and customizing 2D Bar 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: Spline

The following sections provide a list of available advanced attributes available for controlling and customizing Spline 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: Stacked Area

The following sections provide a list of available advanced attributes available for controlling and customizing 2D Stacked Area 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: Stacked Bar 2D

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