In order to display and sort an attribute by Description and in alphabetical order, an example based on the attribute 'Month of the Year' from the MicroStrategy Tutorial project has been shown. This condition may be. Create a document using the above report. . Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. 17K KB16868: How to use an attribute with more than one word in the name in an apply statement in MicroStrategy Developer 10. 3. Attributes appear with an attribute icon on the Datasets and Editor panels. Add the new derived metric to the grid as shown below:1. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Create a new column alias for the date attribute ID form with the data type 'date'. Viewed 13k times. Glossary. Right-click a derived metric and choose Edit. Depending on your MicroStrategy product and licensing. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. MicroStrategy can help you with that, with the creation of derived attributes and metrics. x There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form value in MicroStrategy Developer 9. This tutorial shows you how and is just one example of. To accomplish this, use the following methods: WebReportManipulation. Two new derived elements are created, a blank Group. From the 'Edit' menu, choose 'Group'. Examples of facts include sales dollars, units sold, profit, and cost. MicroStrategy AI is here. Visit the data visualization and data dashboard galleries for inspiration. Create a derived metric in the report whose definition is Max(@DESC){~} 3. 04K KB484006: "Web Create Derived Metric and Derived Attribute" privilege is required to edit derived metrics in reports and d…To display derived elements as consolidated or individual attribute elements. The steps below use objects from the MicroStrategy Tutorial project as an example. 4. KB5221: How to create metrics based only on constant values in MicroStrategy Desktop 9. Click Add Condition in the View Filter section to add your filter. SUBCAT_ID SUBCAT_ID,Step 4) Click on data foundation node. 10, when the "Defect fixes may impact Data, SQL, MDX, CSI" is turned to "On" under Web preferences > Project Default, thresholds for derived metric cannot be properly applied if the condition is based on a cube base attribute. This is a single-value function. This can help the end user more easily distinguish between elements when browsing or. Create a report that uses an object prompt, such as Category or Subcategory. KB237469. Creating derived facts and fact expressions. Click New Data > Databases. In MicroStrategy Web 10. Put the attributes Business line, Category in the grid along with the metric sales. a. You can create them in a report,. 4. tv. Select the attributes, then click to return to the Prompt Generation Wizard. Here is the issue: We have an attribute qualification filter that uses . In the context of MicroStrategy functions,. Add a filter visualization, and drag Brand to it. e. In this video, I show how to create a derived attribute in MicroStrategy. Modify the attribute from which the metric is based or base it on a numeric field. Once in the report editor, select an attribute and right-click on the attribute header. With Architect, you can create and modify multiple attributes in your project quickly from an integrated interface. Steps to Reproduce 1. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year) MicroStrategy Workstation automatically creates attributes when you import data. Finally, just create the report with the attribute (Category) and the third. It might not be the solution that you are looking for, I just want to show other things that you can do with derived attributes. Begin to create the derived metric: Using Developer, from the Insert menu in the Report Editor, select New Metric. The derived metric's value is 12. The ID form should be based on multiple attributes, some of which come from different hierarchies. This article notes a workaround to dealing with percent to total derived metrics with custom groups. This description can be added through MicroStrategy Developer 9. This attribute is referred to as a derived attribute. 2. Define the advance sort on the derived. When the same expression “Week(CurrentDate()-x)” is used into definition of attribute and derived metric, for some particular date, the values are different. MicroStrategy can help you with that, with the creation of derived attributes and metrics. There's a reason we're at the top of the list. The Duplicate as Metric option is not available for a derived attribute. Right-click the attribute to create or modify derived elements for, and click Derived Elements. 11+, derived attributes are evaluated at the source when all the required columns come from the same table- which is the case for most users. They relate numeric data values from the data warehouse to the MicroStrategy reporting environment. Attribute lookup tables are joined to other tables only on the basis of the attribute ID. 3. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. Notice that the above expression for the ID to calculate the customer's age does so by taking the current year found by Year() and then subtracts it by the year that is extracted from the CUST_BIRTHDATE by Year(CUST_BIRTHDATE). Schema objects are building block objects; they are. Support for custom shapes in Mapbox visualizations. To Create a Derived Metric Using the Metric Function Editor. Create a dossier and add DS1 and DS2 as datasets. from ITEM_MNTH_SLS a11. Users might observe that when an attribute with a compound form is added to a report in MicroStrategy Developer 9. Note that for the first row, the data from the previous row is 0 since the analysis is limited to the data retrieved by the report. Open the dossier you want to modify. If M1 does not equal any of the values in the list, then it returns a default value. Depending on the type of object you are filtering on, a different set of choices appears. Create an Intelligent Cube with the following tables and relationships: Create a new dossier. Create a derived attribute with following expression: 4. To my report, I need to compare M vs M-1 vs M-12. Time-derived columns such as "Month of timestamp" or "Day of timestamp" and. The main focus of a dossier is the visualizations, which are visual representations of your data. The derived attribute can be developed based on an object. Now this setting is applied to derived metrics in MicroStrategy Web despite the checkbox not being available in the GUI. Matching objects appear in a drop-down as you type. When creating a count metric within the Metric Editor, users are able to highlight Count, right-click, and select "Count Parameters". 1, and it is currently being evaluated for a potential fix in a future version. You can add it to a visualization, drag it into a text field to display it as a label, or use it as a filter. STEPS TO REPRODUCE: 1. The report displays derived elements defined using. KB439632: Derived element calculations cause metrics based on day data to display as null. Create a new document with the sample file, "Airline Sample Data," in MicroStrategy Web. Create a derived attribute and reserve it for future use in a visualization. The following steps can be used to concatenate two attribute forms. Click Advanced. Click an object to add it to the definition. These groups provide a new view of report data for analysis and formatting purposes. Related TopicsUnable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. Create a second Intelligent Cube C02: Add the Year, Quarter, and Category attributes. This change is being made as the property is to help move the product towards future deprecation of this setting. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. How to Create a Derived Attribute or Metric. Create a derived element on Quarter (this option is only available in MicroStrategy Web, after executing the report). Save the cube, and run it to publish. ‘year’ cannot be linked to ‘month’ because they have parent-child relation) The object to be linked should not be a Consolidation, Custom Group, New Derived Element, or DESC form of old Derived Element; Data types of linked form should be compatible. Additionally, this can slow performance due to the nature of cross joins. The filter within the report is created by selecting from an element list as follows: With the report created to filter on a specific Month of Date element selected from a list of elements, the following SQL is generated: select DATEPART (MONTH, a12. This feature supports more Big Data scenarios where moving large amounts of data to memory is not practical. Select the Attribute Forms option. Create a Base Report in MicroStrategy Tutorial project. If you opened the Quick Thresholds Editor, select the Advanced Thresholds Editor link to open the Advanced Thresholds Editor. Create a standard report like the following: 3. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. 9/10. This is a single-value function. Type a new name and press Enter to apply your changes. The Insert Function dialog box opens. A Calculation derived element uses operators and functions to combine attribute elements and derived elements into calculations that define a single derived element. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Matching objects appear in a drop-down as you type. Before MicroStrategy 2019, users cannot specify the Derived Attribute type in the Attribute Editor. Select the checkbox that corresponds with each attribute you want to generate. For example, if sales data is stored in the data warehouse at the day level, a month attribute allows users to. In the example above note that:Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe following rules apply to percent-to-total shortcut metrics: Row and column percent-to-totals refer to the topmost and extreme-left positions, respectively. Constituent, Gift, Action) you want to create. MicroStrategy will sort the attribute/metric in the visualization based on the query. Prerequisite. Choose 'Month' as the attribute. Click OK. Learn how to create and use a derived attribute with MicroStrategy Workstation 2019, MicroStrategy’s powerful tool that lets you administer and control. ACTION: See below for steps to create a derived metric that can calculate lag on the whole dataset of the report. Matching objects appear in a drop-down as you type. The Derived Elements Editor opens. 24. Execute the report services document. x with any number of attributes. 4. Attribute element display locking can be performed at the attribute level and hierarchy level in MicroStrategy Developer 10. x and add a derived attribute, right clicking an attribute and. x and 10. In MicroStrategy, how to create a report that will dynamically show the distinct count of an attribute at different levels. You can use this method in MicroStrategy Developer and Web. Create a derived attribute based on existing objects; Combine data from multiple attribute values into a single item. Add a dataset to a VI that contains a metric that is a string (“Metric Number” in this. If the selected metric is a transformation shortcut metric, the Metric Editor opens. * Make sure that the derived metric has to be on the view template to make sorting work. After running a report with an object prompt, selecting an attribute and then creating a derived element based on said attribute, the next time the report is run, the derived element will not show in MicroStrategy Web. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. The metric, 'Prompt answer' will display the prompt answer on the report, as shown below: NOTE: If the metric 'Prompt answer' returns as blank, remove and re-add the metric, 'Prompt answer' onto the report in design mode. x, the Report Objects window shows the same attribute form multiple times, as shown: In the above example, the 'Store ID' form shows up twice. Add the dynamic text {Year} to the Detail section. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. )To display more attribute forms on report template, login MicroStrategy Web with Web Analyst privilege "Web choose attribute form display", right click the attribute on report, click Attribute Forms -> More. Depending on your MicroStrategy product and licensing. Now Edit the "Revenue for Books metric and Replace Category@ID with this new Books metric formula would looks like this Case ( (Books = 1), Revenue, 0. In some business scenarios, it is required to use derived metrics to concatenate two attribute forms of the report. Create a new dossier. Open the dossier you want to modify. The syntax of the ApplySimple expression is as follows: ApplySimple ("expression using #0",ATTRIBUTE_NAME)Open a metric editor and create the metric with the following structure: AggregationFunction(case((attribute@AttributeForm="attribute element"), ReturnValue, DefaultValue)) {dimensionality} Users should be sure to specify the attribute form of the attribute that should be used in the calculation. This Knowledge Base article describes how to create a derived metric that can use the whole dataset of the report, rather than the default functionality of using the grid dataset using the Lag function as an example. Open the dossier you want to modify. Click OK to apply your changes. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. Examples include "Region = Northeast" or "Revenue > $1 million". Enter a Form name and Description. Add, rearrange, or remove data from a visualization in a dossier. Consider upgrading to take advantage of the fix. STEPS TO REPRODUCE: Follow the steps below to reproduce the issue in. You can easily create a derived attribute that: Changes the data type of an existing attribute. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. Enter the definition of the derived attribute. Enter a description of your derived metric in the Description field. You have the following options: Break by None: No break by is used and the rank is calculated accounting for each separate item on a report. x - 10. Attribute level locking constrains the element display in system hierarchy, as shown below:. Add "Products" user hierarchy to the metric level and set the grouping option to "None", as shown below: Create a new report, add item attribute in the row and the metric in step 1 in the column, as shown below:In MicroStrategy Web 10. Qualify on 'ID'. Create a Derived Attribute Open an existing document. Search. Continue creating this derived metric by following the steps to create a summary metric in Using a function to create a subtotal: Creating summary metrics. Under 'Source tables', select a table and click 'Set as Lookup'. Creating derived facts and fact expressions. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. 6. Creating Derived Metrics. x does not provide ability to add row numbers in grid reports. The. Action If the CASE expression has only one branch -- i. Derived expressions: Derived form expressions perform some type of mathematical calculation on columns in the data warehouse to create an attribute form. com Format: A MicroStrategy Online Training Video blog. In the Format Definition section, click on Cell Formatting. Click Advanced, then New to create a custom subtotal. To manually enter the definition of the derived attribute. 10869. In SQL View look at where the cross join appears, and between which tables the cross join appears. Distinct is a TRUE / FALSE parameter that allows you to count all elements in a list or only the unique elements. 1. Navigate to the desired attribute. The condition is based on either an attribute or metric. Yes, you can have multiple attributes forms in the title of the card header. Derived Attribute; CSI; Steps to Reproduce. Even if you unmap the linked attributes later, you cannot recover information for the source attribute. In this video, I show how to create a derived attribute in MicroStrategy. g. If M1 does not equal any of the values in the list, then it returns a default value. We use MicroStrategy Tutorial objects in the following steps. For information on how to download th. Resources; Log In; Join; ×. To create a round-down function that produces the following sample results, use the following formula in Metric Editor in MicroStrategy Developer 9. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. Calculation should be done only on metrics based from a numeric source. Source: MicroStrategy. While knowing your company’s total sales is useful, knowing when and where the sales took place provides the kind of analytical depth that users require on a daily basis. x? Knowledge Base: How to concatenate two. Create a report named Year Revenue Report with Year attribute on the row and Revenue, Last Year's Revenue & Percentage Change in Revenue metrics on the column and run it as shown below: Notice that the percentage sign (%) is displayed with the values under the Percentage Change in Revenue metric. You can create a derived attribute by changing an existing attribute's data type. Let’s get started. Count[Employee ID]) are calculated at the grand total level, and not the correct level. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so. Click the name of the dashboard to run it. This tutorial will guide MSTR users to share dossiers through Web and Library. This procedure is using the MicroStrategy Tutorial warehouse that is shipped with MicroStrategy. Open MicroStrategy Web. Expand the document section that contains the Grid/Graph. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. , one condition, a true expression and a false expression -- the MicroStrategy IF function may be used instead. This Knowledge Base article describes how to create a derived metric that can use the whole dataset of the report, rather than the default functionality of using the grid dataset using the Lag function as an example. The derived attribute can be a string, number, or date. 1 derived Metric shows NULL values when the Metric definition contains a reference to an Attribute form which is not shown on the corresponding grid on a report services document. customize analyses and attribute groups Prompting users Stand-alone and derived metrics Sharing reports Improving performance with and dossiers Developing enterprise metrics Customizing data by grouping attributes Creating attributes on dossiers Filtering dossiers Getting started with MicroStrategy SDKs Leveraging the REST API forBy default, when an attribute is added to the 'Grouping' section of a Report Services document containing a grid in the document body, the display of a Grand Total will not be shown for the metric over the entire document. The following procedure describes how to create a constant date metric (i. 8K views 1 year ago Data in the Wild Short Videos In this Data in the Wild episode, you'll learn how to create derived metrics and. The Metric Options dialog opens. In the Operator list, select a comparison operator (Greater Than, Less Than. An attribute may have attribute elements with descriptions that are identical but the ID forms are unique. Steps to reproduce This case is built with the Microstrategy Tutorial project and using the latest version of the Microstrategy Web. Click New Threshold. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. When creating reports in MicroStrategy Web 9. The derived attribute can be a string, number, or date. ApplySimple (" 'Text goes. Click OK to apply your changes. Create a new bar chart. Right click on the attribute, and click edit. Create derived elements for the Region attribute; Create a New Dossier using the base report as a dataset. From the Functions list on the left, browse to and select the function to use to. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Create a derived attribute DA2: With the Data Engine version set to 11 in MicroStrategy 2019, you may notice that metrics defined by attributes (e. There are two methods with to create a stand-alone derived element: Create a derived element from within a report or Grid/Graph and then save it as a stand-alone object. To create a MicroStrategy Derived Attribute, click the option button (ellipsis. You can get to exactly the same result using "regular" MicroStrategy Objects _and_ this is a lot easier to tune (and sometimes, the MicroStrategy SQL engine will do. Type a name for the derived element, and click OK. Filter definition prompts qualify on attribute elements and metrics in qualifications. In the metric editor, go to Tools > Formatting > Values and change the number format to “Date”. KB483243: Derived Attribute data type cannot be specified by the user. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type. In this case, only one form exists for each, as shown below: All the metrics on the report are listed. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. Create a new derived attribute by right mouse clicking an object in the dashboard and selecting the option to Create Attribute In the derived attribute editor,. This article describes how to create a metric with an attribute as a filter using a Case statement in a Visual Insight dashboard in MicroStrategy Web. ACTION: See below for steps to create a derived metric that can calculate lag on the whole dataset of the report. . 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. 3. The Derived Elements Editor opens. Derived Attribute called "Today" is defined as: CurrentDate() Case 1: Derived attribute "Today" is used in the template DescriptionSelect the geographic type from the drop-down list. Search and add “Category”. Click Save and Close to save the metric and close. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. Then it creates a third metric, a compound metric. Delete the grid. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. x and 10. To change the order of the transformations, select a transformation and use the directional arrows to re-position it. Derived Attribute; CSI; Steps to Reproduce. Tutorial project is used here. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. To select specific attribute elements: Choose Use a pre-defined list of elements, then click Add. 11, a new feature is available for performance optimization when dealing with derived attributes. Each attribute form must have at least one expression. In this Data in the Wild episode, you'll learn how to create derived metrics and attributes in MicroStrategy. Note that for the first row, the data from the previous row is 0 since the analysis is limited to the data retrieved by the report. 2, users have the option of removing attributes or metrics from the grid of a Report Services Document executed in Interactive or Editable display mode without losing the. You can add multiple datasets. NOTE: Modifying the key form will trigger required updates when saving. STEPS TO REPRODUCE: 1. When selecting some geographic types, such as zip codes, checkboxes appear for new attributes you can create (for example, County, State, Zip, etc. 2. You create derived metrics based on objects already present in the report. ' Create a report with Region, Profit in the template. Fill out the required fields in the dialog and click Add. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. Enter a name for the metric in the Metric Name field. Format the text field to show “All” when the value of the derived metric created in step 2 is greater than 1. Add External Data. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. Users may want to create a report with a metric that has the current date of execution as a column on a report in MicroStrategy Developer 9. Since attributes provide context for fact values, both fact columns and attribute ID columns are included in fact tables. Follow the steps below to reproduce this issue in the MicroStrategy Tutorial project: Edit the attribute Call Center and modify the form DESC to define a default sort ascending. Below is a comparison of the behaviors supported in MicroStrategy prior to MicroStrategy 2019 Update 5 and in MicroStrategy 2019 Update 5. If you have any questions or suggestions for a f. Report will display result as below. x-10. e. Simple Implicit Derived Heterogeneous For more information on these types of attribute forms, see the Advanced Reporting Guide. The derived metric is created, and you can skip the remaining steps of this procedure. Open MicroStrategy Web. In this tutorial, you learn about derived elements and how to create them on the fly. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Add DM. Description: How to create MicroStrategy OLAP Derived Elements and util. Open the dossier you want to modify. x, derived attribute returns only filtered row from one of the blended dataset, or in some cases returns NULL rows when it's defined with two linked attributes which exists in multiple datasets in the dossier/VI dashboard with different filtering conditions. Go to the MicroStrategy Web and create a new dossier using this cube 7. Symptom MicroStrategy 10. Add Region to the Color By. 0:50. Open the Input Metric Formula dialog box to create a new metric by performing one of the following steps: In Developer: Choose Insert > New Metric. 2. . 4. Exclude the filter. g. The following two business cases, which use the Today derived attribute fails when the VLDB Property “Cartesian Join Governing" is set to Cancel Execution. x-10. x-10. When Distinct is set to True, the Count function counts only distinct values. When creating new derived metric in a Report, Document or Dashboard in MicroStrategy Web, it is not displayed in a list of available metrics when creating another derived metric as in the screenshot below: STEPS TO REPRODUCE: 1. You need the Create Derived Metrics (Developer) and/or the Web Create Derived Metrics and Derived Attributes (Web) privileges. Choose Operator as 'Exactly'. July 27, 2022 | In Business Intelligence, Analytics, MicroStrategy | By Data Meaning How To Create Derived Metrics and Attributes in MicroStrategy Watch on View. On the Custom Subtotal Properties window, write a name for the new subtotal. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. x. The option for Thresholds on attribute elements is not currently available. 10, when the "Defect fixes may impact Data, SQL, MDX, CSI" is turned to "On" under Web preferences > Project Default, thresholds for derived metric cannot be properly applied if the condition is based on a cube base attribute. Note that if the selected attribute is on the grid, the attribute will be moved. These are the steps to reproduce the issue in MicroStrategy Tutorial: Max(){Category} -1 . In this example, we convert years to decades. Create a new Derived Element Category (Group) : Right-click Category on the Grid > Create Groups > Select "Books" and "Electronics" to form "Group 1". This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. To rename the attribute form, double-click its name on the tab. The following procedure illustrates how to retrieve the previous months from a month attribute in MicroStrategy 9. Source: MicroStrategy. In the Based On list, select the object to base the threshold on. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Make: Projects. Attribute form expressions must be rendered into SQL and cannot use any MicroStrategy functions specific to the Analytical Engine. Unrelated and nonshared attributes will be cartesian joined. Click Switch to Function Editor. Next, add Revenue to the Vertical Axis. Choose File > New Derived Element. When you run this report, null values are displayed for the metric because the metric's. The Metric Formula Editor opens. The attribute acts like a column header and the. KB6458: How to create an outer join between two different attributes in MicroStrategy Developer? Number of Views 13. Object descriptions display as tooltips in grid visualizations. Make sure the Category attribute has the Image form as a Display form. Create a derived metric (“New Metric”) with the following syntax: Sum([Metric String]){~+, [Attribute 2]+} Add that metric in a grid visualization, you will notice the cells are blank: Setting a threshold on a derived metric using the max function. To locate a function, enter its name in Search . Create an Intelligent Cube with the following tables and relationships: Create a new dossier. Define Attribute Forms “Day@ID+1”. Create a new. If a dialog appears, click OK Hover. This article narrates "Unspecified error" received when try to define derived attribute based on the smart level metric in Dossier in MicroStrategy 2021 Update 5. For example, if attribute Region is 'Central' then derived metric value should be 'Profit + Cost'. Add new data -> Clipboard and create a "Time Filter" table by typing in: 8. The attribute ID columns included in a fact table represent the level at which the facts in that. The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. There are two work arounds available to create similar functionality. The location of each property in the CREATE TABLE statement is given below. 3/7 videos | 14M 39S total runtime. To create a Group derived element. In the example above, create an attribute. The attributes and metrics appear as filters.