4. Locate the custom metric in the Custom Metrics table that you would like to remove.
5. Select the delete icon in the Actions column.
6. Select **Delete** in the pop-up confirmation dialog. The custom metric is deleted if it is not in use.
The numbered regions are:
1. Custom Metric Label: Mandatory, fewer than 255 characters long.
2. Editing space: Build your expression in this space. Syntax highlighting improves the readability of your expression.
3. Expression Builder work area: Includes a Function Library, Row Level Functions, and Fields to help you build your custom metric.
4. Preview space: Shows a preview of the results of your expression.
5. Calculation Help: Provides more detailed information about the types of metrics Self-Service Analytics supports.
Create a custom metric by defining a formula composed of metrics and attributes that include row level functions and aggregation functions. You can include existing custom metrics in your new custom metric formula, and control the visibility of each metric.
Custom Metrics Editor Features:
* Syntax highlighting improves the readability of your expressions to provide visual clues about the items being used and their validity.
Parts of an expression are highlighted in different colors or with different text treatments:
* function names, both row level and aggregate
* fields and metrics
* keywords such as CASE and IN
* example parameters
* date period constants such as `year`
* values such as numbers and `true` or `false`
* strings
* arithmetic operators such as `+`
References to fields that do not exist in the data source or are otherwise not usable in an expression are interpreted as values. These are shown in black, alerting you to possible typos or other issues.
* Limit the number of records shown in **Preview** by adjusting the **Rows per Page**.
* The Function Library, Row Level Functions and Fields sections always appear in the Expression Builder.
* Autocomplete functionality is included: Type two letters and a list of possible auto-completions appears.
1. Function completions provide the type of function, the name of the function, the description of the function, and an example of how the function is used, including parameters.
2. Field completions are available by typing either the field ID or the field label. The field ID appears in square brackets next to the field label when the two are different. Field completions provide the type of the field, the field label and ID.
3. Metric completions provide the metric label and the expression that will be inserted into the editor when the metric is selected.
* Syntax and validation errors are shown in the Preview area.
* When you're creating or editing an expression, select **Cancel** to return your expression to the initial state.
* Self-Service Analytics disables the **Save** button, preventing you from saving a custom metric unless it has a successfully run expression.
* When you close the editor with unsaved changes, Self-Service Analytics displays a confirmation message.
* Select **Cancel** to continue editing or changing the text of the label for your custom metric.
* Select **Discard** to discard your changes. If you are editing an existing item, your last saved version remains in Self-Service Analytics.
* If you select **Discard** while creating a new expression, Self-Service Analytics returns you to the source work area.
Access the Custom Metrics Editor in the following ways:
* [Access the Custom Metrics Editor from a Data Source Configuration](#access-the-custom-metrics-editor-from-a-data-source)
* [Access the Custom Metrics Editor from the Metric Selection Dialog](#access-the-custom-metrics-editor-from-the-metric-selection)
* [Access the Custom Metrics Editor from the Group Selection Dialog](#access-the-custom-metrics-editor-from-the-group-selection-dialog)
* [Access the Custom Metrics Editor from the Color Sidebar](#access-the-custom-metrics-editor-from-the-color-sidebar)
* [Access the Custom Metrics Editor from the Filters Sidebar](#access-the-custom-metrics-editor-from-the-filters-sidebar)
and then **Color** from the [visual drop-down menu](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/visuals/visual-setup#use-the-visual-drop-down-menu) to access the Color sidebar.
2. Select the **Color Attribute** box on the Color sidebar. A list of attribute, number, and time fields you can select for the color attribute appears in the Color sidebar.
3. Select the add button in the Attribute, Number, or Time fields section of the sidebar. A menu opens with two options: **Add Derived Field** and **Add Custom Metric**.
4. Select **Add Custom Metric** to access the [Custom Metrics Editor](#custom-metrics-editor) and create a custom metric.
) on the visual or select 
on the [sidebar menu](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/visuals/visual-setup#use-the-visual-sidebar-menu). If the visual is in a dashboard, select **Settings** from the [visual menu](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/visuals/visual-setup#use-the-visual-drop-down-menu) (), then select the filter icon on the [sidebar menu](/simba-embedded-analytics/docs/self-service-analytics/26.3/analyze-data/visuals/visual-setup#use-the-visual-sidebar-menu).
* To access the dashboard filter sidebar, select the dashboard filter icon (
) next to the dashboard title. The dashboard-level filter icon is available only when all the visuals are from the same data source.
The Filters sidebar appears. Add or edit a filter.
2. Select the add icon 
at the top of the Attribute, Number, or Time sections on the Row or Group tab. A menu opens with two options: **Add Derived Field** and **Add Custom Metric**.
3. Select **Add Custom Metric** to access the [Custom Metrics Editor](#custom-metrics-editor) and create a custom metric.
2. Select the add button in the Attributes, Number or Time section of the dialog. A menu opens with two options: **Add Derived Field** and **Add Custom Metric**.
3. Select **Add Custom Metric** to access the [Custom Metrics Editor](#custom-metrics-editor) and create a custom metric.
2. Select the add icon in the Number or Custom Metric section of the dialog. A menu opens with two options: **Add Derived Field** and **Add Custom Metric**.
3. Select **Add Custom Metric** to access the [Custom Metrics Editor](#custom-metrics-editor) and create a custom metric.
You can also access the [Custom Metrics Editor](#custom-metrics-editor) when you edit any custom metric listed on the Metric selection dialog. See the following steps.
**Edit a custom metric**
1. On a visual, select the metric label (y-axis label) to view the Metric selection dialog.
2. Locate a custom metric listed on the Metric selection dialog and select the ellipsis () next to it. The following menu appears:
3. Select **Edit** on the menu to edit the custom metric. The [Custom Metrics Editor](#custom-metrics-editor) appears.
4. Select **Add Custom Metric** to add a custom metric.
5. Optionally, select an existing custom metric to modify the metric.
| Filters | ||
|---|---|---|
| Capability | Operators | Notes |
| Filtering on attribute options |
NULL check: IS NULL, IS NOT NULL
Single value: =, !=, STARTS WITH, ENDS WITH, CONTAINS Multiple values: IN(), NOT IN() |
* Non-numeric fields such as Name, Address and State can be used as a filter.
* References to an attribute in a field must be enclosed in single quotation marks. For example: ``` SUM(Sales) WHERE State = ‘Florida’ ``` * Values specified for STARTS WITH, ENDS WITH, and CONTAINS are case-sensitive. The following example would show sales for states that include the lowercase letters `ia`, such as California and Louisiana (and others): ``` SUM(Sales) WHERE State CONTAINS 'ia' ``` |
| Filtering on date field options | Date range operator: BETWEEN | * Standard date formats (see [Convert Attributes to Time Fields in Data Source Field Specifications](/simba-embedded-analytics/docs/self-service-analytics/26.3/connect-to-data/data/data-number-formatting#convert-attributes-to-time-fields-in-data-source-field)) are supported (such as 'yyyy-mm-dd', 'dd/mm/yyyy' including 'hh-mm-ss') . * Date (‘01-01-2015’) must be enclosed in single quotation marks. * Supported time periods are YEAR, MONTH, WEEK, or DAY |
| Filtering on numeric fields and custom metric options | >, \<, =, != | * References to a numeric field must be enclosed in single quotation marks * References can be made to other custom metrics (using the custom metric label) |
| Filtered Custom Metric Examples | |
|---|---|
| Capability | Example |
| Filtering on Attribute options | ``` SUM(Sales) WHERE State = ‘California’ SUM(Profit)/SUM(Sales) WHERE zipcode IN (90210,94107,92101) ``` |
| Filtering on Date field options | ``` MIN(Margin) WHERE Sale_Date BETWEEN ‘2013-01-01’ AND DateADD(MONTH, 6, ‘01-01-2014’)) ``` |
| Filtering on numeric fields and custom metric options |
```
SUM(Sales)/(SUM(Sales) WHERE User_Income = ‘0 to $25000’)
```
To calculate year over year growth: ``` ((SUM(price) WHERE sale_date BETWEEN '2014-01-01' AND '2015-01-01') - (SUM(price) WHERE sale_date BETWEEN '2013-01-01' AND '2014-01-01')) / (SUM(price) WHERE sale_date BETWEEN '2012-01-01' AND '2013-01-01') * 100 ``` |
| Comparing the difference between the current period to last period |
Compare this period's deliveries to last period's deliveries:
``` SUM(deliveries) TRANSFORM delivery_date = PreviousPeriod() ``` |
| Using a row-level expression or function in a filter | ``` SUM(plannedsales) WHERE maxage - age > 30 SUM(plannedsales) WHERE UPPER(gender) = 'MALE' ``` |