By altering the design to a series of 4-panel dashboards and replacing the quick filters with filter actions, the load time for each dashboard was reduced to less than eight seconds. The type of filter you create mostly depends on the data type of the field that you want to filter. Cause This is a known issue with MicroStrategy Data Engine 12 and 13. NOTE: Data is correct when download the Data Engine version to 10. The New Condition/Condition Editor dialog opens. From the Format menu, select Document Properties. Choose a prompt. filter as part of report When designing reports or dossiers, developers can leverage view filters to restrict the data displayed on a report, within a chapter or on a single visualization, providing users with a different view of the data. It all starts with the Enterprise Semantic Graph – the building blocks of your business that can be quickly created, and easily re-used, accelerating collaboration and development of your suite of BI applications. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Right-click on the filter you want to use as the primary filter and ensure it is set to "all values" in the dashboard. This is a known behavior before MicroStrategy 2020. But today I am going to show you how to pass a selector value from one dossier to another without using the prompt option and also without any custom SDK. Selectors allow a user, in MicroStrategy Web, to. The following procedure describes how to achieve this: Create the highest level filter. For example, the report below contains Region, Category, and Profit. Embedded Filters; This section does not include information about security filters, which are discussed in the System Administration Guide, or creating multiple filters at the same time by using a Command Manager script. 33 (or 33%). Learn on how to create filters in Microstrategy Web (dossier), both page level as well as global filter. This filter starts on the first day of the month from six months ago and ends on last day of the prior month: To pass the prompt answer for an element prompt when the attribute has a compound ID, you separate each ElementID with a colon. Profit Margin = (6-5)/5 which equals 0. From the Filter On drop-down list, select the object (attribute or metric) on which you want to base your filter. In this quick tip, I show you how to filter MicroStrategy reports using a custom SQL query using ApplyComparision and ApplySimple. MicroStrategy provides ETL, data warehousing and data mining for data analysis. 1 and 10. For example, consider a report with a custom group defined as shown below (the examples are based on the MicroStrategy Tutorial project): Its elements have the following display options: The custom group options. Create your selections (WTD, MTD etc) on a spreadsheet and import that into the dossier as a new data set. For detailed information on report filters, see the Advanced Reporting Help. A derived element is a grouping of attribute elements on a report. It is used with logical operators such as AND and OR. 37. , >, =, Like, In, etc. Security filters in MicroStrategy restrict a user's ability to access or view certain objects within a given MicroStrategy project. When a User Group is configured with a System Prompt Security Filter including 'User Login' the MicroStrategy environment will generate and access caches on a User basis even if the User Login does not have an effect on the final result set. The Document Properties dialog box opens. An important step in designing a report is ensuring that the correct data is returned from your data sources to be displayed on the report. A filter screens data in your data source to determine whether the data should be included in or excluded from the calculations of the. Get inspiration at the MicroStrategy data visualization gallery. AS CATEGORY_ID, a11. If the Report Filter panel is not displayed above the report, display it by clicking the Filter icon on the toolbar. The settings are copied from the database. In the pane on the left, navigate to the attribute with the date data type on which you want to qualify. The panel stack is the target of the selector. In the example above, the cascading value is a string. Cascading filters are filters that let you drill into a specific selection to decide what to include or exclude. MicroStrategy Report Services Dynamic Dashboards Training;. This helps to limit the values to ones that are only relevant to the first filter and prevents users from selecting irrelevant data, which creates a better user experience. MicroStrategy Tutorial. Transformations allow you to apply an attribute-element based offset to compare metric data. The filter criteria for the report is found in the WHERE clause of the SQL statement which calculates the metric in question. g. . OR, to convert an existing filter into a security filter, click Import. Select the chapter that contains the visualization to filter. Return Value. 1. Clear the Filter setting: uncheck to exclude attributes absent in report or level (dimensionality) check box. For more information on all types of advanced filters, refer to the Advanced Filters chapter of the Advanced Reporting Guide. The elements to be imported are stored in an Excel file or a text. 11 or above. This tool was introduced in MicroStrategy 8. Click Advanced. The intuitive approach is to separate each criterion with commas ',' but this will create a string that qualifies on all characters at the same time. Intelligence Everywhere. For example, if you want your string in either lowercase or uppercase, you can do it using filters. Description. You will get the following window. Select Filter definition prompt -> Choose from an attribute element list as shown below. In order to protect both security and performance the MicroStrategy system will compare all of the Security. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. Then create a new metric that has a case statement that chooses alternative metrics based on the value of the new attribute in the filter. 4 9 Updated December 5, 2016 You can also create filters on the fly within a report. The most common use for a choice filter is to construct what is known in XLSForm jargon as a cascading select, where a selection in a list (for example countries), controls the. Build Cascading Dashboard Designs to Improve Load Speeds. MicroStrategy Apply functions provide access to functions or syntactic constructs that are not standard in MicroStrategy but are provided by various Relational Database Management System (RDBMS) platforms. Installation And Initial Setup. In this case element browsing can be enabled. In SQL View look at where the cross join appears, and between which tables the cross join appears. Absolute filtering - changes the filter on descendents of the target. For those coming from previous software generations (7, 8, or 9) MicroStrategy Desktop was the tool that was used to create the metadata and reports on a Windows (PC only) environment. here I have 5 hierarchy filters. Run the report in Grid View. Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. An object prompt allows you to select which MicroStrategy objects to include in a report, such as attributes, metrics, custom groups. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. You can add visual representations of the data (that is, called visualizations) to the dossier to make your data easier to interpret, perform manipulations on the data to customize which information to display, and organize. It has simple filters, which get the data based on the values selected by the user. If it is cleared, filter attributes that are not on the report or in the level. By default from date must be set to 1st date of the current month. A filter specifies the conditions that the data must meet to be included in the report results. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. One of the advantages of view filters is that it retrieves information quickly. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. For descriptions of the different types. Save the filter as "Region Filter". The MicroStrategy Intelligence Server provides an attribute level setting to allow or disallow element browse requests and the element cache to ignore the security filter in the cache key. Press and hold the Ctrl key to select multiple attributes or metrics. Usually assigned by administrators, security filters control what warehouse data users can see within MicroStrategy. The Security Filter Editor opens. For detailed information on report filters, see the Advanced Reporting Guide. Selectors provide dossier-style documents with interactivity, allowing each user to change how they see the data. Using a filter on a report narrows the data to consider only the information that is relevant to answer your business question, since a report queries the database against all the data stored in the data warehouse. Annamalai Sambanthan. Click OK to return to the Metric Editor. This is a filter which contains a prompt on an attribute element list. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. Ensure that the filtering for the filtered. Saylor, Sanju Bansal, and Thomas Spahr, the firm develops software to analyze internal and external data in order to make business decisions and to develop mobile apps. The common approaches for incorporating data mining within MicroStrategy are described below: Scoring the Database: Records are scored in batches and saved as tables or columns. Choose attribute Call Center and use the Region Filter created in the previous. Select the Create cache when page-by selections are modified check box. This method uses filter design design tables to realize higher order filters by cascading 1st and 2nd order active stages. Introduction to Filters. 2 From the Format menu, select Document Properties. A prompt allows a user to provide an answer to restrict or filter data during report execution. Please check attached image for reference. Cascading filters in Tableau allow for the selections in the first filter to change the options in the second filter. This leads to the next best practice recommendation. In the Data Source dialog, select Reports. The Level advanced options dialog box opens. The ApplyComparison function allows users to bypass the MicroStrategy SQL parser and create an expression where comparison operators (e. Create a blank dossier or open an existing one. Click on DATA tab on the ribbon. Through the use of the ApplyComparison function, create a custom expression filter to select the desired rows from the desired table. There's a reason we're at the top of the list. Get inspiration at the MicroStrategy data visualization gallery. However, in MicroStrategy Web 10. Select a metric or metrics to combine with filters to create conditional metrics. Follow the same steps you just did on the 2nd order filter with R 1 = R 2 = R 3 and C 1 = C 2 = C 3, and again with R 1 = 1KΩ, R 2 = 10KΩ, R 3 = 100KΩ and C 1. To save the prompt. In shiny, how to link the filter to part of the data to change some of the charts and not others? 0. 1 and it can determine how a given change in a project environment, such as regular maintenance changes to metadata objects or hardware or software upgrades, affects the. Context filters: Dossiers with MicroStrategy 10. An empty selector appears in the dossier. Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. A stand-alone filter is a filter created as an independent MicroStrategy object. Our vision is to enable Intelligence Everywhere. Attribute Qualifications can have many forms, we discuss all of them in this short video. But in reality, many of these dimensional relationships change over time. Example: below the case count value post filter is 11. EnumDSSXMLNodeType. How to Create Context Filters in Tableau. Open the report you want to create a filter for. Using this approach you can transfer a passive RLC reference ladder network of any order into an active circuit (active L-simulation, FDNR-technique). Select the object you want to base your filter on: To base your filter on an object that is part of the report's definition, use the Report Objects pane on the left and. The operator must be In list or Not in list. Visualization Filters and Selectors. Cascading Style Sheets and Layouts. For example, you have a report with Region, Category, and Profit displayed, as shown in. For detailed instructions on completing the Prompt Generation Wizard, see Filtering based on metrics, attributes, or other objects: Object prompts. You'll find everything from waterfall charts to word clouds in our community. There's a reason we're at the top of the list. A filter is composed of one or more qualifications. Create a filter with an element list or qualification prompt on an attribute. Open the document in Design or Editable Mode. (2) However, there is another strategy called "direct synthesis". Somehow the user or the filter got corrupted looks like. If the Grid/Graph is a shortcut, you cannot create a view filter because the Grid/Graph is. Filtering data is a very important part of data analysis and visualization. promptAnswerMode *. Select the filter or prompt to apply to the metric using one of the following methods: To type the filter or prompt directly, begin typing the name of the filter or prompt in the field in the Condition area. Creating a stand-alone filter. Then create a new metric that has a case statement that chooses alternative metrics based on the value of the new attribute in the filter. ‘sort’ command sorts out the content of a file alphabetically. Enable document caching. Only data for the year 2008 is displayed in the report. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. Alternatively, type the name of the attribute in the Find field. MicroStrategy project. MicroStrategy Web relies heavily on this rule, enforced by the browser, for making sure that the proper style rules are applied for every page in the MicroStrategy Web application. The Document Properties dialog box opens. General Preferences. User filterIn MicroStrategy, a security filter is a filter object that is used to narrow down the result set that users or groups can view when they execute reports or browse elements. It all starts with the Enterprise Semantic Graph – the building blocks of your business that can be quickly created, and easily re-used, accelerating collaboration and development of your suite of BI applications. Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. The Project-Level Very Large Database (VLDB) Property setting, found in Joins > Preserve All Lookup Table Elements, 'Preserve lookup table elements joined to final pass result table based on template attributes with filter' is not turned on, which results in. A Filter in AngularJS helps to format the value of an expression to display to the user without changing the original format. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. The MicroStrategy architecture is a meta-driven type where metadata is the central repository of all the objects and can be used by all of the MicroStrategy products. A project is the highest-level of intersection of a. A Relationship filter allows certain attributes to be filtered by their relationship to other attributes. View Filter: View filter works on the executed report as It is on Analytical engine level. i have a Cascaded prompts where i have to display companies based on regions. This can be supported by using a Freeform SQL report as a shortcut-to-a-report qualification on a standard report. However, an extra step must be performed in order to apply the filter. 11 will support prompts for end users. Using the MicroStrategy Tutorial sample data, if you execute the report and answer the prompt by specifying 40 as the Employee Age, the final report looks like the following: Value prompts are typically used on a filter, where they become part of the filter's definition, but they can also be used on a metric as part of the metric's formula. microstrategy. You must have added a panel stack to. The Document Properties dialog box opens. Click the parameter that represents the cascade source. This is useful where reports contain. But today I am going to show you how to pass a selector value from one dossier to another without using the prompt option and also without any custom SDK. Do this for a couple of fields – in the example workbook at the end of this post I’ve used “Zone”, a calculated field that separates. In MicroStrategy Developer 9. You can also access the Advanced Metric Assistant by first selecting metrics. 134. This knowledge base article describes an identified defect in MicroStrategy that prevents users from accessing the Security Filter Manager in MicroStrategy Developer 10. The stand-alone filter can then be used on many different reports, as well as on metrics and other objects. Create a report based of the cube and no data is returned. x and open the project where a security filter should be created. Open the dossier you want to modify. Filter push down is not applied; Changes in data; Changes in the Cube Setting Instruction (CSI) Steps to reproduce The following example uses MicroStrategy Tutorial attributes and metrics: Open MicroStrategy Web. By altering the design to a series of 4-panel dashboards and replacing the quick filters with filter actions, the load time for each dashboard was reduced to less than eight seconds. A filter is a MicroStrategy object that specifies the conditions that the data must meet to be included in the report results. Double-click the Northeast Electronics Revenue -- cleared metric. Answer is, yes with an workaround on the MicroStrategy Dossier. 4. These objects are reusable for all products. You can use the URL API to pass certain types of prompt answers to the page being executed. The following steps demonstrate how to reproduce the issue in tutorial project: M1=Count<Distinct=True ,. Select the heat map visualization. Select Filter definition prompt -> Choose from an attribute element list as shown below. A filter is not required in a. Discover MicroStrategy – the modern, open, enterprise platform that connects every user and every application to all your data. Import table into MicroStrategy using data import in web > save as an In-Memory. Typically, dimensional hierarchies are presented as independent of time, e. Right-click an element and Go to. It also has features to create complex features, which will filter out. These objects are reusable for all products. unchecking apply selection as a filter in microstrategy gives no data. "Cascading" in this context means that because more than one stylesheet declaration could apply to a particular piece of HTML, there has to be a known way of determining which specific stylesheet rule applies to which piece of HTML. From the Tools menu, select View Filter. The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. Select the heat map visualization. A filter sifts the data in your data source to bring back the information that answers exactly what you require. Select the filter or prompt to apply to the metric using one of the following methods: To type the filter or prompt directly, begin typing the name of the filter or prompt in the field in the Condition area. In MicroStrategy Developer, open the document in Design View. A filter can also be a metric qualifier created using custom expressions employing functions. x. How the user answers the question determines what data is displayed on the report when it is returned from your data source. The search object must search within subfolders. Selectors provide dashboards with interactivity, allowing each user to change how he sees the data. Answering all prompts ( promptsAnswerXML parameter) Generating the XML to answer all prompts (including nested prompts) Answering element list prompts ( elementsPromptAnswers parameter) Passing prompt answers for an unanswered. We could design a higher order filter directly, but the direct forms suffer from numerical problems due to limited computational precision. Attribute Qualification Prompt, which allows users to determine how the report's data is filtered, based on an attribute filter. 3K KB33862: How to create nested or cascading selectors and avoid getting blank selections in MicroStrategy Web 9. From the MicroStrategy Developer File menu, point to New > Attribute. Apply the security filter to a user or group. In other words, an application’s business logic is contained. This calculation can be aggregated from the Employee level to the Region level. However, the report limit and the view filter are not interchangeable. Narrowing the focus of a report to the data that is of interest of you enables another level of report analysis that can highlight business trends and figures. Security filters will be added to the SQL code generate by MicroStrategy when you run a report and they will become an additional where condition. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. Click on the Name Filter. The advanced options for the conditional metric establish this interaction. Navigate to a prompted report and click Insert. Drag the report into the filter definition window. Select the formats to cache. Use the drop-down to select an environment. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. To use the selector to include data for selected values, select Include. 1However, in this case, the filter is created using an AND condition. The following is a quick reference table for this MicroStrategy Object: There are different types of Filters depending on what are they made of and where they can be used. However, in MicroStrategy, filters can also be created as part of a given report, at the same time the report itself is being created. MicroStrategy Apply functions provide access to functions or syntactic constructs that are not standard in MicroStrategy but are provided by various Relational Database Management System (RDBMS) platforms. It permits users to create a set of elements from an attribute based on their. A stand-alone prompt can then be used on many different reports, as well as on filters,. x with the date attribute filtering on an aggregate from base derived metric gets ignored in a Dossier/VI Dashboard when attribute join behavior is set to Outer Join To Lookup. Embedded Filters; This section does not include information about security filters, which are discussed in the System Administration Help, or creating multiple filters at the same time by using a Command Manager script. Only one level of nested panel stacks is supported. Cascading analog Op-Amp filters is far more complex than you are making out in this post, especially if you add gain: You make no mention of Miller-Effect, capacitive inter-stage coupling. We use MicroStrategy Tutorial tables that have the Call Ctr Id attribute. There's a reason we're at the top of the list. The security filter applies to all reports and documents, and all attribute element requests, submitted by a user. From the Answer prompt drop-down, select how your selected prompt is answered. Currently, this issue is still being reviewed for feasibility by our Technology team and is not scoped for any upcoming scheduled MicroStrategy release. SYMPTOM: When using an attribute selector on a report that contains a derived. Filters data related to a business attribute’s form (s), such as ID or description. Filters specify the conditions that the data must meet to be included in the report results. Limiting your data – Filters. not work correctly in an intelligent cube report with nested derived metric when "Aggregate from base" is enabled in MicroStrategy Web. MicroStrategy Integrity Manager is an automated report comparison tool designed to streamline the testing of MicroStrategy projects. A view filter is similar to a report limit in that it can also be applied at the report level. Cascaded Prompts in Microstrategy. The type of prompt and the display style determine the style properties that are displayed; not all the properties in the following procedure will apply in every case. Granting the same permissions to a MicroStrategy user directly through the User Editor interface allows for the Security Filter Manager option to show up. Right-click the attribute to create or modify derived elements for, and click Derived Elements. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. In the Properties pane, double-click the Cascade source property. Select a prompt answer and click Apply. Till now I have seen the developers were using prompt to pass the value from one dossier to another. The metric has been set to ignore the filtering criteria that have been specified. A stand-alone prompt is a prompt that is created as an independent MicroStrategy object. Because element prompt answers are matched with prompts using the AttributeID, the order of the prompt answers does not determine the order in which prompts are answered. Case can be used for categorizing data based on multiple conditions. I want to add the date attribute to filter. It is important to design the correct filter to retrieve the desired data. Autostyles can be either saved based on an existing document or they can. Report as filter allows you to create a report and use it as a filter to generate another report. If you created a new dossier, you must save the dossier before adding an existing dataset. You must have added a panel stack to the document, to use as the target of the selector. Action This issue has been fixed in MicroStrategy 2021 Update 6. Whenever users submit an element browse request or a report. Using Freeform SQL Reports to Filter Other Reports. Open the report you are creating a filter for. This technical note describes how to successfully implement this functionality. In the right side of the Security. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. By default, the setting is selected. Hover over the Properties column and click Open Intelligence Server Administration Portal . Discussions and overview/introduction to more complex tools within report studio. These groups provide a new view of report data for analysis and formatting purposes. In MicroStrategy 10. Create a cascading prompt to use values from one prompt to filter values in another prompt. the attribute present in the report template). MicroStrategy Does the Scoring: MicroStrategy scores records using metrics and reports. This helps to limit the values to ones that are only relevant to the first filter and prevents users from selecting irrelevant data, which creates a better user experience. If DHTML is disabled, from the View menu, select View Filter and click the Go icon . Expand the art of the possible with new dossier design options such as enhanced vertical scrolling options and the ability to lock filter. x and open the project where a security filter should be created. If you are using MicroStrategy 2021 Update 2 or a later version, the legacy MicroStrategy Office add-in cannot. A filter can be a report object, that is, a report filter, a report limit, or a view filter, that restricts the data returned or the display or view of data on a report. Filters ensure that the report results contain only the data that answers the specific business query the report was designed to answer. less ,pg and more commands are used for dividing a long file into readable bits. MicroStrategy Desktop provides a variety of options to filter data in a report. Slowly Changing Dimensions. In the Intelligence Server Configuration, the administrator must select the History List database instance in the "Content Server Location" field. Filter Editor contents. A Relationship filter allows certain attributes to be filtered by their relationship to other attributes. Filtering data is a very important part of data analysis and visualization. We lately encountered a scenario where user ran a microstrategy report and it showed data much more than what user security filter permit. For background information on search objects and steps to create them, see the MicroStrategy Developer help. Report filters are a standard MicroStrategy reporting feature that enable you to filter the data retrieved from the data source. The above prompts and. It has simple filters, which get the data based on the values selected by the user. 9. The main difference between report filters and view filters is how they are evaluated by the system. A Relationship filter allows certain attributes to be filtered by their relationship to other attributes. 0. The Report Filter pane allows you to create a filter without having to open a separate object editor (the Filter Editor). Case This function evaluates multiple expressions until a condition is. ACTION: To take advantage of this new feature upgrade to MicroStrategy 10. Pipe is a command in Linux that lets use two or more commands such that output of one command serves as input to. You can also drag and drop the attribute to the right pane. A description of the options available to create and edit a metric. Spotfire Filter applies to all visualizations of a dataset. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. Attribute form qualifications are of type This filter is of type com. Log into a project in MicroStrategy Web. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. MicroStrategy Desktop provides a variety of options to filter data in a. The graph legend or axes can be formatted as well. For this reason, a metric qualification in a filter is a type of set qualification. Create a security filter on Category as well as Region with an “OR” statement between the filters 2. DetailedstepsforallfunctionalityintheMicroStrategysystemareavailableintheOnline Help. Add the Condition. Go to the Tools menu and select My Preferences as shown below: In the My Preferences window, select the Editors tab and click on the Filter Options. Number of Views 4. 6. Data displayed in MicroStrategy Viewers can be filtered by different criteria. ApplyLogic is a. The filter on option adds a view filter to the report but since only data for 2008 has returned, that is the only attribute element in filter on. The. In MicroStrategy Developer, open a hierarchy using either the Hierarchy Editor or Architect, as described below: Locate a hierarchy in the Folder List, right-click the hierarchy, and select Edit. Following is the architecture of MicroStrategy: 1. This calculation is used to build the framework of the cascading menu. However, since a text prompt cannot be directly incorporated in a report object, it. In analyses, you can create the same types of filters as you can in datasets. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. The view filter above is based on an attribute form qualification defined as Year ID equals 2011. 1. The advanced filter feature is useful in applying filter conditions, which will otherwise involve complicated steps. The report displays derived elements defined using. Specify a name and location for the new security filter and click Save. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. This shortcut applies to all filters and limits in reports. a) Attribute form qualification. The concept of Dimensional Modelling was developed by Ralph Kimball and consists of “fact” and “dimension” tables. BasicReportingGuide vii ©2017,MicroStrategyInc. Add the filters to the view. To filter the data to import based on a complex expression. Check available Attributes OR; Use View Filter grid > [+Add Condition] to open a list of. To create an object promptKB15250: An ignored filter qualification with a conjunction of OR causes other qualifications to be dropped in MicroStrategy SQL Generation Engine; In these examples, the same user, with the same security filter, executes the same view report definition against Intelligent Cubes with different attributes. The user double-clicks an object to add it to the Selected list. It will on hit the. In the above, image, we will replace with selected value to respective text box as below: How to achieve it are below ? Place the above created metric with IF () function into the respective viz & target them from Graph Viz. Depending on the type of object you are filtering on, a different set of choices appears. Create a second report with the following: "Region" as attribute "Sales" as metric; Add Regions to the report filter then below that qualification add the filter created in Step 2.