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.
Reporting
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 ...
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.
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!") ...
Chart Advanced Features: Stacked Bar 3D
The following sections provide a list of available advanced attributes available for controlling and customizing Stacked Bar 3D chart elements.
Note: This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...
ExpressView: Sorting (v2021.1+)
Data can be ordered by applying sorts to the columns of the ExpressView.
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. ...
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, ...
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.
Chart Advanced Features: Stacked Column 2D
The following sections provide a list of available advanced attributes available for controlling and customizing 2D Stacked Column chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the ...
Report Wizard: Categories
The Report Wizard can be used to create a new Advanced Report in versions released before v2021.1. Use the Categories tab to select which data to use on the report.
ExpressView: Visualizations (v2021.1+)
Visualizations, also known as charts or graphs allow data to be showcased in a visual format. They allow data to be scanned quickly for patterns and trends. Charts can be easily made and customized in ExpressViews, in as little as one click.
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.
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 ...
Chart Advanced Features: Stacked Column 3D
The following sections provide a list of available advanced attributes available for controlling and customizing 3D Stacked Column chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the ...
Report Wizard: Filters
The Report Wizard can be used to create a new Advanced Report in versions released before v2021.1. Use Filters to restrict the amount of data displayed in the report based on a chosen criteria.
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.
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 ...
Chart Advanced Features: Zoom Line
The following sections provide a list of available advanced attributes available for controlling and customizing Zoom Line chart elements.
Note
This article contains documentation for advanced attributes which are third-party customizations that must be manually entered into the chart ...
Report Wizard: Layout
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.
