Click on 'New' to create a new subtotal. In the Based On list, select the object to base the threshold on. Create a document using the above report. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. Put the attributes Business line, Category in the grid along with the metric sales. 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. Value prompts are useful when the result desired on the report is a single value, such as a specific date, a number, or a specific word or phrase. 2. Note: ShipDate in the formula refers to the attribute. . GetNewTransformationMetric (WebMetric, WebObjectInfo) Use. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. 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:Unlike Value prompts with type of Numeric, in a Text prompt, it is not possible to drag and drop to the Metric Definition pane. STEPS TO REPRODUCE: Create an object prompt, using the pre-defined list of objects and adding the following attributes. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. Open the dossier you want to modify. 1. In MicroStrategy Developer, create a dummy metric with the following definition. In this example, we convert years to decades. Any operation on a column such as adding a constant, adding another column's values, or setting the expression to be an absolute value creates a derived fact. The Create New Attribute Form dialog box now appears. Add it to the grid. Sometimes you don’t have all the columns that are necessary for creating your visualizations. x-10. MicroStrategy can help you with that, with the creation of derived attributes and metrics. A workaround is available in the current document. Create an Intelligent Cube with the following tables and relationships: Create a new dossier. Learn how to create and use a derived attribute with MicroStrategy Workstation 2019, MicroStrategy’s powerful tool that lets you administer and control. In a dashboard, create a metric with this formula: Sum (Revenue){~+}<Favorite_Employees_Filter> Important noteThis report shows the sum of sales for each month, for the previous row and the % change between them. Set the qualification type to 'Custom'. The condition is based on either an attribute or metric. Double-click the Grid/Graph to edit it. To include database table for creating attribute view, click on data foundation node and follow the instruction step by step as below –. Open up the same document in MicroStrategy Web 10. For the example scenario, right-click the Region attribute, and click Derived Elements. Matching objects appear in a drop-down as you type. A nested derived attribute is an attribute made from another derived attribute. Create a derived metric in the report whose definition is Max(@DESC){~} 3. it looks like MicroStrategy doesn't support it, please advise. MONTH_DATE) MONTH_DATE, sum (a11. 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. Right click on any of the existing attributes and select Insert Row or scroll down to the bottom of the attributes and place the cursor in the first empty field under Description. It should work. Open up the same document in MicroStrategy Web 10. 2. Place the attribute, 'Month,' the filter, 'Revenue limit,' and metrics, 'Revenue' and 'Prompt answer' in the report. From the 'Edit' menu, choose 'Group'. Open a report in MicroStrategy Developer. The Duplicate as. Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. The following steps describes how to create such derived metric. This allows attribute element data to be displayed. To create a derived metric. Add the derived metric to the report and hide it by setting the column width to 0. If all conditions are false, a default value is returned. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. It is derived based on a count against the fact_object_component table. Open the dossier you want to modify. The new form should immediately be included in the attribute's column. Attribute element display locking can be performed at the attribute level and hierarchy level in MicroStrategy Developer 10. 1. Login to MicroStrategy Web, go to Add External Data -> Databases -> Pick Tables and pick the following table and columns;. Custom groups are not treated in the same way as attributes by the MicroStrategy SQL Generation Engine. 2. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. In the context of MicroStrategy functions,. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. 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. Execute the report either in MicroStrategy Desktop 9. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. Run the document. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. x. Attribute lookup tables are joined to other tables only on the basis of the attribute ID. Right-click the attribute to create or modify derived elements for, and click Derived Elements. Drag the filter and some of the data lost instead of being filtered. For example, using the MicroStrategy Tutorial project, users may want to calculate the number of. Tutorial project is used here. The following procedure describes how to create a constant date metric (i. Why is this happening?[-] When creating a visualization dashboard within MicroStrategy Web 10. View the report as a graph and notice that the. Article Reference Number: KB39231. the 'Unit Cost' metric. For instructions to create shortcut metrics, which are a type of derived metric, see the MicroStrategy Web Help. Using the MicroStrategy Java Web SDK 9. Symptom Null might be returned to an Aggregate From Base (AFB) metric in a data blended dossier/document which involves view filters applied on complicated Derived Attributes (DA). The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so. Add Category attribute to the grid template. Fact data and levels of aggregation. Create a new Derived Attribute “Day + 1” based on “Day” by right clicking “Day” Attribute and select “Create Attribute”. When building a derived metric with a condition in Web the formula will look like the below. a dossier with derived attributes based on multiple attributes fails with "Unspecified error". Attribute level locking constrains the element display in system hierarchy, as shown below:. 4 Hotfix 4, within the “MicroStrategy Tutorial”, create a new VI. With related attributes however the amount of. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. Create a derived attribute based on the metric. In terms of join behavior this means the setting applies to metric joins between datasets. In the metric editor, go to Tools > Formatting > Values and change the number format to “Date”. Double-click the Grid/Graph to edit it. Go to Menu -> Insert -> New Metric, and enter the formula as shown below: Max (Region@DESC) {~ } NOTE: Use Max () function to transfer an attribute form into a. Create or include a user defined under a security filter on the same attribute or a different attribute in the same hierarchy. 1, and it is currently being evaluated for a potential fix in a future version. Linked attributes appear with a Link icon in the top pane of the Preview dialog. In the Attribute Editor window, give your new attribute a name. Object descriptions display as tooltips in grid visualizations. 2. To my report, I need to compare M vs M-1 vs M-12. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. Follow the steps below to change the column alias to data type 'date':This technical note provides an example of how to calculate the number of days between the current date and a date attribute. 4. Click New Data > Databases. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. Symptom MicroStrategy 10. In the example above, create an attribute. To manually enter the definition of the derived attribute. In such situations, it may be beneficial to display all the same descriptions together and sort the ID in a particular manner, ascending or descending. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Open MicroStrategy Web. 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. I will first show how to build this derived attribute in sections, and in the end we will combine all the sections together. x by modifying the object's properties, as shown below: However, when creating a derived metric, no Description field exists, as shown below:. Define Attribute Forms “Day@ID+1”. 2. On the same right mouse click context menu under the attribute header, users will see an. SUBCAT_ID SUBCAT_ID,Step 4) Click on data foundation node. Create a derived attribute and reserve it for future use in a visualization. The Create New Attribute Form dialog box now appears. If you need to remove the geographic type later, you can select None. Go to the MicroStrategy Web and create a new dossier using this cube 7. Under 'Source tables', select a table and click 'Set as Lookup'. Add the dynamic text {Year} to the Detail section. x. You can create a Year derived attribute from a Date attribute in MMDDYYYY format. Select the attributes, then click to return to the Prompt Generation Wizard. Open a report in MicroStrategy Developer. The main focus of a dossier is the visualizations, which are visual representations of your data. x. 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. Check other tables and select/deselect correct tables. Expand the document section that contains the Grid/Graph. This article describes a situation where using a derived attribute based on an existing metric as a filter on a Visual Insight dashboard causes the Intelligence Server to crash. The user is able to see the. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. Type a name for the metric in the Metric Name field. Use. g. Right-click a derived metric and choose Edit. PDF. Click New Threshold. Open MicroStrategy Developer. This example uses MicroStrategy Tutorial to demonstrate the problem and the fix. The steps below use objects from the MicroStrategy Tutorial project as an example. Visit the data visualization and data dashboard galleries for inspiration. For example, the Customer attribute in the MicroStrategy Tutorial project has the five attribute forms shown below: Of these five attribute forms, only Last Name has a default report sort order defined. You can create a derived attribute based on Employee, using the Concatenation function to combine the first letter of the first name and the last name. Facts are one of the essential elements within the business data model and basis for almost all metrics. A derived attribute works the same as any other attribute. Exclude the filter. A code fix for this issue is not available in current releases but is being reviewed for a future MicroStrategy release. This is an identified defect in MicroStrategy where a derived metric that incorporates a duplicated attribute as a metric in the formula for the derived metric cause the Pie Chart visualization not to display. When editing the name of a derived metric (or any other such object), in a Visual Insight document, the name changes on the visualization itself, and the grid panel, but not in the "Dataset Objects" panel: STEPS TO REPRODUCE: 1. From MicroStrategy Education, this lesson teaches you how to. Check the checkbox 'Apply background color as a graph threshold,' as seen below: Click OK. You can create a derived attribute by changing an existing attribute's data type. Make: Projects. Depending on your database and SQL dialect, there will be variations, but the basic format is :. You can import business data from many different sources, including local files, databases, Google Drive, etc. 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. In this tutorial, you learn about derived elements and how to create them on the fly. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. 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. Select Display Attribute Forms. Simple Implicit Derived Heterogeneous For more information on these types of attribute forms, see the Advanced Reporting Guide. Create a derived attribute and reserve it for future use in a visualization. When creating reports in MicroStrategy Web 9. This video show how to share a filter with other Library users. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). KB442371: "Unspecified error" is displayed for a dossier with at least two dataset with attributes linked, derived attribute and conditional metric When using more than one datasets with attributes linking, derived attribute and conditional metric, Dossier fails with "In-Memory query execution failed against Intelligent Cube due to duplicate. Click on the "Validate" button to validate the formula. Go to Smart Attribute blade on the Attributes Editor. Open the Workstation window. In MicroStrategy, how to create a report that will dynamically show the distinct count of an attribute at different levels. Expand the document section that contains the Grid/Graph. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. x - 10. Create a new Derived Element Category (Group) : Right-click Category on the Grid > Create Groups > Select "Books" and "Electronics" to form "Group 1". Right-click the attribute to create or modify derived elements for, and click Derived Elements. MicroStrategy platform capabilities exposed in a RESTful web service. Create a new Derived Attribute “Day + 1” based on “Day” by right clicking “Day” Attribute and select “Create Attribute”. Modify the Address form so that it has a descending report sort order. Break byObject: A break by on Object is used to. A nested derived attribute is an attribute made from another derived attribute. The steps to create such an attribute: Make a dataset consisting of the necessary objects. x SYMPTOM: Derived attributes are attributes that are based on one or more derived form expressions. Insert one panel stack and add dynamic text with Profit Margin. Apply conditional formatting for the dynamic text. New feature indicates which derived objects are used in visualizations on dossiers. Source: MicroStrategy. KB6458: How to create an outer join between two different attributes in MicroStrategy Developer? Number of Views 13. This tutorial shows how to create derived attributes and metrics in a dossier. Creating derived facts and fact expressions. If M1 does not equal any of the values in the list, then it returns a default value. Create the previous Month Filter. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and. In the Datasets panel, right-click the metric to use to create a derived metric and choose Create Metric. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. x, Derived Attribute does not display values. You can import business data from many different sources, including local files, databases, Google Drive, etc. Add Region to the Color By. Cleaning up unused objects is still useful for easier troubleshooting, improving performance and better organization of the dossier content down the line. . Matching objects appear in a drop-down as you type. Select the Property tab. To add multiple attribute forms, create a multi-form attribute within the dataset and drag it to the header of the HyperIntelligence card. This article describes a situation where using a derived attribute based on an existing metric as a filter on a Visual Insight dashboard causes the Intelligence Server to crash. The pane on the left displays the Report Objects which shows the components (attributes, attribute forms, metrics, custom groups, consolidations, and so on. Attribute form expressions must be rendered into SQL and cannot use any MicroStrategy functions specific to the Analytical Engine. Run the report and select both attributes in the object prompt. 5. Calculation should be done only on metrics based from a numeric source. e. Press and hold the Ctrl key to select multiple attributes or metrics. Add Month to the horizontal axis. KB439632: Derived element calculations cause metrics based on day data to display as null. By default, a metric is calculated at the report level, meaning that the lowest attributes on the report dictate how the metric is aggregated. If you have any questions or suggestions for a f. 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. Another important observation is not to forget to enable "Smart Metric”. Create a Derived Attribute Open an existing document. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;The following scenario describes how to create a distinct count subtotal from base report: 1 Create a report A with only “year” in row and ”category” in column; add customer in report object window only. You can use this method in MicroStrategy Developer and Web. Create a new bar chart. Refer to the procedure below for steps to create a rank shortcut metric. In MicroStrategy 10. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. The attribute must have a date type of Date, Time, or DateTime and contain a date attribute form. Open MicroStrategy Developer. 3. An attribute may have attribute elements with descriptions that are identical but the ID forms are unique. These are the steps to reproduce the issue in MicroStrategy Tutorial: Max(){Category} -1 . This attribute is referred to as a derived attribute. You link directly related attributes to each other by defining parent-child relationships. Rename the metric in dataset object panel. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges. 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. You can create a Year derived attribute from a Date attribute in MMDDYYYY format. Create a derived attribute with following expression: 4. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. 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. Select the checkbox that corresponds with each attribute you want to generate. Once an attribute has been selected, the button is replaced by the. Create a metric based on the freight fact which is extended to Item attribute with fact extension. A dossier is an interactive display that you can create to showcase and explore business data. Add the derived attribute into filter. In MicroStrategy 10. Drag and drop the objects into the report grid. The Metric Options dialog opens. Click an object to add it to the definition. KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. This behavior has been logged as a Defect by MicroStrategy Technical Support for version 10. Datasets contain the data that appears on a dossier. This can be done by right mouse clicking on an object in the document and choosing the option "Insert New Attribute" In the derived attribute editor define the attribute using the metric whose values the user wishes to use in the grouping. You need to know the number of regions, so you create a derived metric from the Region attribute. Engineering. Create a standard report like the following: 3. Report filters based on attributes unrelated to the attribute in the metric condition are still kept and included in the WHERE clause. They relate numeric data values from the data warehouse to the MicroStrategy reporting environment. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. Attributes appear with an attribute icon on the Datasets and Editor panels. Select the check box for any smart attribute that needs to be created. In Web: Choose Data > Insert New Metric. All attribute element data is added together to form the metric values for the new group. Create a dossier and add DS1 and DS2 as datasets. To manually enter the definition of the derived attribute. The Metric Editor opens. use the function "Remove Duplicate Rows". Create the list using the buttons described below: Select Objects dialog box. Add the attribute Category Desc of DS1 to the grid and create new derived elements on Category Desc. Matching objects appear in a drop-down as you type. Derived Attribute; Derived Metric; CurrentDate – A function that returns the current date as provided by the database timer. STEPS TO IMPLEMENT. Create a new dossier and click “Existing Objects”. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type. The Derived Elements Editor opens. Create a standalone Derived metric DM : Create a new Intelligent Cube C01: Add the Quarter, Country, and Region attributes. Create a derived attribute based on Month and change the data type to String. Create a derived attribute and reserve it for future use in a visualization. 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. Formula:Manage Datasets. If a dialog appears, click OK Hover. In this case, only one form exists for each, as shown below: All the metrics on the report are listed. 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. Since attributes provide context for fact values, both fact columns and attribute ID columns are included in fact tables. Add a dataset to a VI that contains a metric that is a string (“Metric Number” in this. Create a Filter object and save it in an accessible location. You can easily create a derived attribute that: Changes the data type of an existing attribute. 3. , attribute, derived attribute, metric, or derived metric) with an existing object from the new dataset, select the object to use as a replacement. Create a new derived attribute by. Create two count distinct derived metrics and places them on the report template. • Joining dissimilar column names: Heterogeneous. MicroStrategy RESTOAS3. We use MicroStrategy Tutorial objects in the following steps. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. This change applies to metric creation in either Developer or Web. Create Derived Attributes and Derived Metrics in the first dataset as below: Derived Attribute Today: CurrentDate Derived Attribute Week: Week ([Today@ID])The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. Once in the report editor, select an attribute and right-click on the attribute header. The Level (Dimensionality) definition pane displays below the Metric component area. Follow the next steps to create this type of metric. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. 10869. Tutorial project is used here. A derived fact has its value determined by an expression that contains more than just a column in a table. 1 - 10. 2. Enter a name for the metric in the Metric Name field. KB34980: Removing an attribute or a metric from a grid in a Report Services Document preserves runtime information in MicroStrategy 9. Distinct is a TRUE / FALSE parameter that allows you to count all elements in a list or only the unique elements. The report displays derived elements defined using. The steps below use objects from the MicroStrategy Tutorial project as an example. In the Datasets panel, right-click the metric to use to create a derived metric and choose Create Metric. Make your changes, save the metric, and then save and re-execute the report to see the changes in the metric. a. Even if you unmap the linked attributes later, you cannot recover information for the source attribute. 6. Learn how to switch to a compound grid, add column sets in this new visualization. The Metric Editor opens. 45 -> 24. Example:. The Intelligence Server performs any additional operations requested like subtotals, formatting, derived elements, etc… The data is rendered in the end user browser. Create a derived attribute as shown below with multiple attributes. On the Custom Subtotal Properties window, write a name for the new subtotal. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. In the Datasets panel, right-click the attribute to use to create the derived attribute and choose Data Type. Create a dossier based on the cube. 3. Create a new Custom Group with the attribute Call Center as shown below:I'm newbie on Microstrategy. A dossier is an interactive display that you can create to showcase and explore business data. Check one of the available forms for the attribute. 2. 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. This pairs rows from each dataset together. the 'Country' attribute and a metric, e. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Format the text field to show “All” when the value of the derived metric created in step 2 is greater than 1. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. 2. Create a subset report named R based on Intelligent Cube Q1; drag attribute ‘Brand’, ‘Item’ and ‘Warranty’ to the grid. 5. Select the attribute you want to use to create your derived element. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. Action If the CASE expression has only one branch -- i. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. You can create derived elements with the following methods, which are all described in this section: Depending on the type of report you are creating a derived element on, you can use either MicroStrategy Developer or Web. Note the picture with the definition. 4. 1 and wants to use derived elements to display to display the attribute elements in a specific order. x and add a derived attribute, right clicking an. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. 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. Create a new Intelligent Cube. Prerequisites. Action Enable Data Blend VLDB property through Analytical Engine>Document Grids from Multiple Datasets as shown below:Synopsis: Figure 1 describes different scenarios that are described later in greater detail. Name the derived metric using the top most text field in the window. x-10. This behavior has been logged as a Defect by MicroStrategy Technical Support for version 10. 2. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. 4. The Derived Elements Editor opens. Drag attributes or metrics from the Datasets panel to the Filter panel. To create a new Group derived element, from the New drop-down list, select Group. ACTION: See below for steps to create a derived metric that can calculate lag on the whole dataset of the report. Define the advance sort on the derived metric and then sort on Gender DESC. Create a new dossier, add new data, use Clipboard and input the same data as below. In the Datasets panel, click More. 4. Create a new derived metric in a VI Dashboard with the formula below: Sum(IF((Year@ID=2014),Cost,0)){} 2. In this case, you would create a dummy derived attribute. 1. Add the new derived element Category Desc(Group) to the filter panel. Resources; Log In; Join; ×. x. g. On the Background tab in the Format Cells editor and select 'Solid' as background style and choose black as the color for the 'Fill' drop-down. 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. ) next to your dataset. Steps to Reproduce. Derived element groups are defined by a list, filter, or calculation.