- Release notes
- Getting started
- Installation
- Configuration
- Integrations
- Authentication
- Working with Apps and Discovery Accelerators
- AppOne menus and dashboards
- AppOne setup
- TemplateOne 1.0.0 menus and dashboards
- TemplateOne 1.0.0 setup
- TemplateOne menus and fashboards
- TemplateOne 2021.4.0 setup
- Purchase to Pay Discovery Accelerator menus and dashboards
- Purchase to Pay Discovery Accelerator Setup
- Order to Cash Discovery Accelerator menus and dashboards
- Order to Cash Discovery Accelerator Setup
- Basic Connector for AppOne
- SAP Connectors
- Introduction to SAP Connector
- SAP input
- Checking the data in the SAP Connector
- Adding process specific tags to the SAP Connector for AppOne
- Adding process specific Due dates to the SAP Connector for AppOne
- Adding automation estimates to the SAP Connector for AppOne
- Adding attributes to the SAP Connector for AppOne
- Adding activities to the SAP Connector for AppOne
- Adding entities to the SAP Connector for AppOne
- SAP Order to Cash Connector for AppOne
- SAP Purchase to Pay Connector for AppOne
- SAP Connector for Purchase to Pay Discovery Accelerator
- SAP Connector for Order-to-Cash Discovery Accelerator
- Superadmin
- Dashboards and charts
- Tables and table items
- Application integrity
- How to ....
- Working with SQL connectors
- Introduction to SQL connectors
- Setting up a SQL connector
- CData Sync extractions
- Running a SQL connector
- Editing transformations
- Releasing a SQL Connector
- Scheduling data extraction
- Structure of transformations
- Using SQL connectors for released apps
- Generating a cache with scripts
- Setting up a local test environment
- Separate development and production environments
- Useful resources
Metrics
Metrics are used to define a calculation once and reuse it in the entire app. For example, you can make a metric to calculate the number of invoices , or a metric to calculate the average amount. These metric can then be reused in different places, such as in charts, or in aggregate expressions.
Expressions and metrics both have a specific purpose and work differently. Expressions create a value per record. Metrics do not have a value of their own. A metric must be used in a place where the records are accessible, e.g. aggregate expressions, charts, and HTML panels.
The same metric can be used in many places while expressions are tailored to one specific purpose.
Metrics can also be used in the calculations of other metrics.
metric
. The use of this function is necessary to evaluate the metric.
Follow these steps to create a metric.
Step |
Action |
---|---|
1 |
Open the app in your development environment, and go to the Data tab. |
2 |
In the table item list, right-click on the table for which you want to create a metric and select New metric.... |
3 |
Enter the expression to define the metric in the Expression editor. |
4 |
Validate the outcome in the results panel at the right. |
5 |
Click on OK. |
The new metric is created in the table item list and identified by the icon.
Follow these steps to use the metric in a chart.
Step |
Action |
---|---|
1 |
Go to the Dashboards tab and create a new dashboard based on the table in which the metric control is present. |
2 |
Go to the Chart tab. |
3 |
Select the attribute you want to display in the chart from the Rows drop down list. |
4 |
Select the metric from the Metric drop down list. |
See illustration below for an example.
In the example the Invoice type attribute is used for the chart and the metric Metric Average amount that calculates the total income an invoice generates on average. The bar size equals the number of average amount per category.
Follow these steps to use the metric in a legacy chart.
Step |
Action |
---|---|
1 |
Go to the Dashboards tab and create a new dashboard based on the table in which the metric control is present. |
2 |
Go to the Chart tab. |
3 |
Drag the attribute you want to display in the chart to the Rows level. |
4 |
Change the Size to Expression. |
5 |
Click on
expression and enter an expression to use the metric you created. For example metric(Metric_Average_Amount) .
|
6 |
Click on OK. |
See Metric Selectors.