- 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
Metric selectors
Selectors can be used to switch between metrics. In that case they are called metric selectors.
Follow these steps to create a metric selector.
Step |
Action |
---|---|
1 |
In the table item list, right-click on the table for which you want to create a metric selector and select New control - Selector.... A selector New selector is added in the table item list. |
2 |
Double click on New selector to open the Edit Control dialog. |
3 |
Right click in the Selector items pane an click on Add.... |
4 |
Select the metrics you want to add to the selector and click on OK. |
5 |
If desired, you can set a Default value for the selector by adding the expression
uid([default metric]) .
|
6 |
Disable the checkbox Allow empty selection to enforce that either one of the available metrics from the selector is selected, and click on OK. |
Follow these steps to add the metric selector on a chart
Step |
Action |
---|---|
1 |
Go to the Dashboards tab and create a new dashboard based on the table in which the metric selector 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 selector control from the Metric drop down list. |
5 |
Drag the metric selector control to the Header controls of the chart. |
See illustration below for an example.
In the example the metric selector contains three metrics. By selecting a different metric in the selector, the size of the bars of the chart also change.
To use the metric selector on a legacy chart you must create an expression that contains the following functions.
Function |
Description |
---|---|
|
Returns the list of UIDs (unique identifiers) of the current selection of the metric selector. |
|
Selects one item from that list. Note: the metric selector used can only select one value at a time.
|
|
Evaluate the selected metric. The metric function accepts either a metric or the UID of a metric. |
metric(any(selecteduids(FilterMetric_selector)))
.
Follow these steps to add the metric selector on 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 |
Drag the Metric selector control to the Header controls panel. |
5 |
Change the Size to Expression. |
6 |
Click on
expression and enter the expression containing the elements described above.
|
7 |
Click on OK. |