How to create visual insight in microstrategy. This is a javascript. How to create visual insight in microstrategy

 
 This is a javascriptHow to create visual insight in microstrategy 1 for iOS

x, the following error message appears when exporting a Visual Insight Analysis to Flash, as shown below:Create a VI based on the report and choose Vertical Area - Absolute as the visualization. In MicroStrategy Web 9. x. Create a metric with the filter. Adding a dataset from the sub menu options in a Visual Insight Dashboard does nothing in MicroStrategy Web 9. set ("height", (window. Add an attribute to the Rows drop zone. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformNew feature in MicroStrategy 9. x, users can define the merge setting for the rows and columns. x, threshold is not applied in the Total of the Visual Insight Dashboard, as shown: CAUSE: Currently, this feature is not available in MicroStrategy Web 9. 3. The goal is to select which Metric you want to display. In MicroStrategy Web Customization Editor, create a new plugin and give it a meaningful name; Under Application Settings tab, expand MicroStrategy Web Configuration > Pages > Html5Vi (HTML5 VI. x. Before Customization: After Customization: Launch the Web Customization Editor. In MicroStrategy Web 9. This issue occurs for all versions of MicroStrategy Web 10. Visual Insight allows you to create customized, interactive dashboards that you can use to explore your business data. 1Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformTo Create Metrics. Take the Visual Data Discovery - Visual. Basically, a quick dashboard is like a document, but the process of creating this dashboard is easier and faster. Create a report with Category, Profit, Cost, and Revenue. PCWorld Apr 19, 2011 11:40 am PDT. 3. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformCreate a new plugin using the web customization editor. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThis is a short demo for how to use MicroStrategy Analytics (formerly known as Visual Insights pre 9. The HTML container can be added either as an. 0 - 10. From the report execution page, rename one of the attributes on the report and save the report. Note: Filters can only be created out of metrics and schema attributes. The user can then move the filter panel to the top where the selectors will be automatically arranged horizontally. The Select Dataset dialog box opens. 1. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence. The following snippet can be extended through the RWExecute task or used in standalone code. how to show a Scatter Plot using C3. Toggle the filter values. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingEnterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThis Knowledge Base article describes how some users may find that bar graph do not render when adding certain data sets as well as the reason and code fix implemented to omit the issue. In the Grid pane, select the drop down next to a Metric and choose Thresholds. Upon making this selection, the row headers will now be merged. 18K KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. 0: Network Visualization widget in Visual Insight. x-10. 1; Product Documentation: How to Create a Derived Metric from an. ACTION: Contact MicroStartegy Technical Support for an update on the issue. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; Consultinghow to show a Scatter Plot using C3. Notice that the prompt page displayed and the user can select a quarter prior to the execution of Visual Insight with Direct Data Access option. For example: RemoveVISubMenuItem. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. You create and interact with Visual Insight (VI) dashboards. Create a report with Quarter and Year attribute plus "Revenue" metric. So we built the Time Series visualization to analyze that data. 5 iPad app show duplicate metric columns titles when using a horizontal bar graph as shown below. 3. 1, the original name still appears on the VI filter pane, as shown below. Dossiers. Content In order to create a metric in MicroStrategy Visual Insight to filter on a specific attribute, a Case statement function can be used to get the designed results. Instead, users may observe that the tooltip displays, for example, "Metric: Revenue" when hovering over the object in the Report Objects or Datasets pane, or. This issue has been addressed in MicroStrategy Mobile 10. Published: Jun 22, 2017Case function doesn't display in available function list but it is supported in MicroStrategy Visual Insight 9. KB439719: In MicroStrategy 10. A user can create a history list subscription for a Visual Insight dashboard to be delivered on a schedule to a designated user's email. Add two attributes to the grid. 5 that a horizontal bar graph in Visual Insight shows duplicate metric titles. Advanced Apps. Create a Visual Insight Dashboard with the dataset from Step 1 and add the Category, Subcategory and Profit objects to a grid visualization. 2. 4. To reproduce the issue, create a document that uses the created report as a dataset and run it in Flash mode or create a Visual Insight dashboard. MicroStrategy can display data as part of an interactive map, which can include important information along with additional geographical information. It can be done by setting the source visualization as “Use as Filter”. Right-click the Region attribute on the grid and select "Attribute Forms" and then "ID". MicroStrategy Insights Starting in MicroStrategy 2021 Update 7 (September 2022), Insights are supported in MicroStrategy Library (web browser only) on the. ACTION:The HTML5 Visual Insight page in MicroStrategy Web 10. MicroStrategy can display data as part of an interactive map, which can include important information along with additional geographical information. 1Import a RS document or VI dashboard into Excel with MicroStrategy Office; 2. 5. Business Intelligence with MicroStrategy Cookbook covers the full cycle of a BI project with the MicroStrategy platform, from setting up the software to using dashboards in the. 0, visualizations such as Charts, Grids, and Graph Matrices cannot be zoomed in and out with the two finger pinch and zoom gesture. 3. MovingDifference. MicroStrategy Web 10. The following steps will remove a toolbar sub-menu item in MicroStrategy Visual Insight Dashboards using the SDK 10. Related articles from the Community: Knowledge Base : How to create a derived metric. SYMPTOM In MicroStrategy 10. You can also display VI dashboards on an iPad with MicroStrategy Mobile. Follow the steps below using the MicroStrategy Tutorial project: 1. Open the Diagnostics and Performance Logging Tool from the MicroStrategy Intelligence Server machine. Vitaracharts can be used in Dossier , Visual Insight or even for pixel perfect Report Services Documents. On the dataset "Revenue & Discount by Category, Country, Month" create a new derived metric "KPI" defined as follows. As you track data points from the Insights page, MicroStrategy runs advanced models to spot outliers and trends to deliver useful. Instructions for MicroStrategy Web 10. Insert a standalone filter to the dashboard. This document discusses about a known issue about pie chart inin MicroStrategy Mobile 10. In order to create a metric in MicroStrategy Visual. 10. Check the Merge checkbox under Rows in the Header section. 1, when a report contained in a Visual Insights is modified by changing the displayed attribute forms, the changes are not reflected on the VI AnalysisMicroStrategy Intelligence Server, MicroStrategy Intelligence Server Universal, MicroStrategy Distribution Services, MicroStrategy Report Services, MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Web Reporter, MicroStrategy Web Analyst, MicroStrategy WebWhen a Google Sankey Diagram is deployed from Visualization Gallery into Microstrategy 10. 2 with one dataset containing one metric and one attribute, create a bar graph with the attribute in the Vertical box and the metric in. This article details the behavior differences of an object prompt report when creating a visual insight dashboard through the web folder browser versus the tools menu in the prompted report. In the Grid pane, select the drop down next to Cost and choose Thresholds. 4. In order to calculate the difference for a metric Revenue between Year 2011 and 2012 in MicroStrategy Visual Insight, MovingDifference function can be used to get the designed result. 8, you can now see additional information relating to function generation. 5. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. 68K. In MicroStrategy Web 10. If the first date argument is later than the second date argument, the result is a negative number. 4. This video will go over MicroStrategy Visual Insight: What is Visual Insight (VI), What is a VI dashboard, Characteristics of a VI dashboard, Creating a VI dashboard, VI dashboard Panes, VI capabilitiesWorkstation is the only space for analysts and app architects to build and manage content of all types. N/A. In the MicroStrategy Tutorial project, create a Visual Insight dashboard with a bar graph;Create a stacked bar graph with the drop zone configuration identical to the screenshot below: Sort the graph by the Metric - Ascending, using the menu shown below: Note that the graph is sorting by only the blue element, and not the sum of the blue and red elements. x, users may notice that the row headers are not merged, like shown below: ACTION Follow the steps below to merge the row headers into a single entry:How to prevent Visual Insight from creating a sample report in MicroStrategy Web 9. After enabling value data labels for a line graph on Visual Insight dashboard in MicroStrategy Web 10. Add formatting condition (for example Cost greater than 20). Enable the filter panel from the View menu. STEPS TO REPRODUCE: Create a VI dashboard with 3 visualizations: V1, V2 and V3 configured as: V1 filters V2 and V2 filters V3. Create a new Dashboard with. This is a javascript. This Knowledge Base article describes an issue with Flash Visual Insight show data dialog that does not provide a scroll bar for larger content. Create a bar graph visualization for a report that has above 30 categories. The result does not. Insert a filter on Profit. This document explains how to create custom color thresholds in Visual Insight in MicroStrategy 9. Each. Add a filter. 2) Create a custom group based on one of the attributes in the report. For example: RemoveVISubMenuItem. Create a Visual Insight dashboard and. Dashboards open by default in Visual Insight Mode, where you can easily drag and drop attributes and metrics to display data, create filters, group data, and more. Add a second sheet to the dashboard. You can also display VI dashboards on an iPad with MicroStrategy Mobile. Customize the format of the imported document; 3. MicroStrategy. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. Click on 'Revenue' and Sort Ascending. All other Standard shape files like countries of the world are shown centered. Web Professional . See the previous images above to see how the row headers should now appear. When an object is added to the drops zone of Visual Insight, the system Double Byte input is grayed out in MicroStrategy Web 9. 5. This issue does not occur for pie chart graphs in report services documents. 5. choosing metric and condition. Reports. 5: Launch the Web Customization Editor. Assuming that a new Dashboard will contain 0 datasets, developers can insert logic to enable panels such as the "Add Existing Dataset" panel when a Dashboard has 0 datasets. On the left a panel the objects from "dataset 1" are displayed (Region and Revenue) 6. 4. Go to the More Options link at the bottom of the pane. Click on the visualization containing the grid with the attribute. Using Visual Insight in MicroStrategy 10. In MicroStrategy Web 10, users can use an ESRI Map as a filter for other visualizations. A visualization is a visual representation of the data in a Visual Insight (VI) dashboard, such as a grid or graph. The following customization will remove the "Browse All Objects" and "All Objects" links from the Dashboard Datasets options in Visual Insight Dashboard. 1. Visualizations display as blank after applying a metric filter on a Visual Insight dashboard in MicroStrategy Web 9. x Visual Insight, which supports HTML5, data labels will not overlap each other. opening the alerts editor. The function returns the moving difference between current and preceding values. At least View access needs to be granted for this object as it is required to create Visual Insight dashboards. Navigate to the Visual Insight page in MicroStrategy Web, for example by creating a new dashboard. 2. This document discusses about a known issue about pie chart inin MicroStrategy Mobile 10. SYMPTOM: Users have the ability to create different graph types in the form of visualizations in Visual Insight in MicroStrategy Web 9. x. Add Year to columns and Cost/Revenue to rows 5. This is expected behavior. 1, 9. In order to utilize the feature, one can: 1. Click on Add dataset and select "dataset 2" How to properly migrate a Visual Insight analysis across projects without recreating the underlying cube. When the value is less than ~0. Reopen the Report and add the Region's ID form on the grid. You can also. However, the dashboard behavior differs depending on whether the Visual insights dashboard was created through the web folder or by first opening the prompted report to create a dashboard from the tool menu. 5Change data font in VI with dataset from imported data (Intelligence cube)Create a Visual insight Dashboard with Categories and Profit. CAUSE: This is a known issue in MicroStrategy 9. Don't choose the type of visualization yet. In Visual Studio 2022 version 17. Our goal was simple — to build the next-generation dashboard editor. Adding a dataset from the sub menu options in a Visual Insight Dashboard does nothing in MicroStrategy Web 9. 4. Users can also move a column "Left", "Right", or "Move to Beginning". How to Merge Row Headers in the Grid visualization in Visual Insight with MicroStrategy Web 10. 4. ACKNOWLEDGED IN-PROGRESS SOLVED (Version: 10. This issue is under review from the MicroStrategy team. 4. 1 and 10. 1 Visual Insight in Microstrategy 9. Loading. 5. Not able to perform a column merge in Visual Insight dashboards when an attribute has more than two attribute forms and at least couple metrics in MicroStrategy Web 9. Go from data to insight in minutes with MicroStrategy Visual Insight, the data discovery and visualization. With MicroStrategy 9. In Web, click New Dashboard. 5, follow instructions in KB310745. 1 for iOS. Insert a filter on Profit. In the first sheet, add a visulaization. STEPS TO REPRODUCE: In MicroStrategy Web, create a report with attributes Category, Subcategory, Item and a metric Cost. 4. 4 and newer using the Advanced Threshold Editor. Create a new plugin and give it a meaningful name, such as addButtonToVI, and click OK. KB439937: How to create an OLAP function derived metric that will calculate without regard to filtering applied at the visualization level in a Visual Insight dashboard in MicroStrategy 10. For examples of widgets that display on mobile devices that have MicroStrategy Mobile installed, see Widgets for mobile devices. 1. 1, a user can add multiple attribute selectors of type checkbox to a Visual Insight dashboard. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. The fuel for business dashboards is data, so each one needs to have one or more data sources. This Knowledge Base article describes how some users noticed that the Apostrophe character does not appear when using 10. Click on View > Filter panel to show the filter pane in the second sheet. On these dashboards, attributes on certain visualizations, such as the Grid visualization, can be used as filters to target other visualizations. 4. Sources include cloud databases, data warehouses, physical access systems and web applications. Create a new Visual Insight Dashboard. Create an Intelligent Cube, with Region, Category, Cost and Profit. Notice the name of the metrics appears twice: STEPS TO REPRODUCE: Create a new Visual Insight dashboard in MicroStrategy Web 10. Have you ever missed the Pixel Perfect Document's Metric & Attribute selectors? Here is how to create similar features in Dossier / Visual Insight ! Many thanks to Philippe Royer for finding and sharing this solution. x This article discusses how to create an OLAP function derived metric in a VI dashboard that will calculate based on the data contained in the visualization. Users can take advantage of D3’s features and several of its wrapper libraries for making visualizations on VI Dashboards and Report Service documents . The impact is limited to the MicroStrategy Web 9. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingVisual Insight allows users to create multi-tabbed "insight dashboards" that can present different views of a business issue. 1). In a Scatter grid or Pie chart Visual Insight dashboard, a text metric does not display in the tooltips. 1, create a report with Customer Region, Customer State, and Profit. In MicroStrategy 9. Number of Views 230. These are the steps to enable this feature: 1. Use Visual Insight to create a map visualization to display this location data. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. Click the vertical eclipse icon (More) on the top right of the visualization. Create a new Visual Insight dashboard using that report as the dataset. 1, users could right click an Intelligence cube to create a URL API call that would allow users to automatically create a Visual Insight dashboard using that same cube, as shown below: However, in MicroStrategy Web 10, this 'Link' property is no longer available for Intelligence cubes, as seen below: CAUSE: The following steps will remove a toolbar item in MicroStrategy Visual Insight Dashboards using the SDK 10. Please observe the below screenshot (on top). Disabling the Legend for a Heat Maps in a Visual Insight dashboard still shows the legend in MicroStrategy Mobile 10. This issue occurs when the Use ACL is missing on the Light Theme object. STEPS TO REPRODUCE 1. Click on the visualization containing the grid with the attribute. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingWhy MicroStrategy Why MicroStrategy; Customer Stories; PlatformThis article outlines an issue where a visual insight graph does not render after saving, a blank page is returned. Step by step instructions on how to create a virtual time period attribute with the values MTD, QTD, YTD using a MicroStrategy Custom Group. For more information and steps to create an alert-based subscription, see the MicroStrategy Mobile Administration Help. 1 Tutorial Project, create a report with the following objects: Attributes: Day, Category, Subcategory; Metrics: Profit. xHowever, there is still a way for users to view back-end data in a Visual Insight dashboard. Convert the report to a Visual Insight dashboard. Follow these steps to reproduce this issue in MicroStrategy Tutorial project. ACTION: This issue has been addressed in MicroStrategy Web 10. 5, Visual Insight dashboards executed on the MicroStrategy 10. The following steps will remove a toolbar sub-menu item in MicroStrategy Visual Insight Dashboards using the SDK 10. When the ESRI map contains an attribute in the tooltip drop zone different than the GEO attribute, hovering over the markers will display a table of data that represents the relationship between those two attributes in the tooltip. Click Show Data on the Day level. Select project properties. In MicroStrategy Web 10. For example, you can: Upload FilesOr drop files 644 With the release of MicroStrategy 10. The Select Dataset dialog box opens. 0-10. The email will contain a URL API link to the dashboard, however, in MicroStrategy Distribution Services 10. Insert as dataset a New report with Category and Item attributes and Cost. In MicroStrategy Web 10. Change visualization to horizontal bar graph;. After renaming an attribute or metric on a report or data set that is used in a Visual Insight dashboard in MicroStrategy Web 10. This feature is available in MicroStrategy Web 10. ACTION: Contact MicroStrategy Technical Support for an update on the status of the issue. Upgrade to this version to take advantage of this fix. 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. Number of Views 4. This Knowledge Base article describes a known issue that metric names display on the wrong axis on a Visual Insight Dashboard in MicroStrategy Mobile 9. Starting in MicroStrategy 2021 Update 9 (March 2023), Insights are also supported on MicroStrategy Library for iOS and Android. Upgrade to take the advantage of this fix. Using report filters instead of Visual Insight filters or using filters based on attributes instead will work correctly. x. Drag an element from either attribute. all. New Feature in MicroStrategy Web 10: Ability to create element groups in Visual Insight. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. In MicroStrategy Mobile 10. There is an enhancement requested to implement this feature. 4. Number of Views 445. One use case is to determine if a Visual Insight Dashboard is new. Add a filter. STEP 1: Enable the MCE trace. 4 and newer using the Advanced Threshold Editor. x. This Knowledge Base Article describes an issue that has been classified as defect in MicroStrategy 10. ADDITIONAL TROUBLESHOOTING: Telling a Story with MicroStrategy Dossier. Display the dashboard as a Bar Chart. 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. Security; Next Steps; Overview. Create a Visual Insight dashboard and choose "dataset 1" as the dataset. In some cases, if videos are blocked on the network then the page will have a blank video. 3. 5. 5. Select More Options at the bottom of the pane. x. Right click on the filter on the filter panel. KB45815: New Feature in Visual Insight MicroStrategy Web 9. 1. Click on MicroStrategy Web Configuration inside the Application Settings view to expand the hierarchical. 4. At least View access needs to be granted for this object as it is required to create Visual Insight dashboards. 2, the link sent to the user will take the user to a Report Services Document version of the. x. KB219522: How to access the SQL view of a Visual insight Dashboard using an MCE Trace in MicroStrategy Web Number of Views 2. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. e. Visual Insight allows you to create customized, interactive dashboards that you can use to explore your business data. Add a Grid visualization from Report 1. Add a Grid Visualization with Country as an attribute and Cost as the metric. 1In MicroStrategy Web 10. 5. Create a new plugin and give it a meaningful name, such as addButtonToVI, and click OK. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform The formatting will display as clear text, instead, as shown below, in MicroStrategy 10. Note that in MicroStrategy Web 9. Assuming that a new Dashboard will contain 0 datasets, developers can insert logic to enable panels such as the "Add Existing Dataset" panel when a Dashboard has 0 datasets. Drop zones. CAUSE: This is a known limitation of Visual Insight in MicroStrategy Web. When running a Visual Insight report in MicroStrategy Web 9. The following steps will remove a toolbar item in MicroStrategy Visual Insight Dashboards using the SDK 10. x, and 10. First, you open a blank document and select a report to use as the document's dataset. 4. 4. b. You can share a dashboard through email, by linking to the dashboard, or by embedding the dashboard in a web page. In the Select Dataset dialog box, navigate to the Intelligent Cube that you want to use for the dashboard. 6. 4. For this check an attribute. MicroStrategy Visual Insight was included with the standard user licenses, had a flash based engine and it was working only on web (and mobile). These dashboards can be saved and shared so colleagues can access them and benefit from the analysis. 3. Create a Dashboard using both Reports as datasets. In the ever-evolving space of visualizations Vitaracharts is updated every quarter to add new charts and features to ensure our customers stay up to. After upgrading to MicroStrategy Web 9. Enable the data labels on the graph matrix visualization. Select the metric in Visual Insight 4. 4. In this video we cover how to upload external data,. CAUSE: This is a known limitation of Visual Insight in MicroStrategy Web. x, an Exclamation mark is displayed, rather than the Visual Insight Report, this article describes how this problem can be handled. MicroStrategy Desktop is a new product aimed at the individual BI user based on its Visual Insight product, competing most directly with the likes of Tableau. Number of Views 4. 1. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. Use the intuitive Format Panel to easily customize the design. When creating a Bar Graph in MicroStrategy Visual Insight Dashboard the option to sort on metrics will not work as expected if the option "left row" is enabled. This feature is available in MicroStrategy Web 10. A user may create a Visual Insight dashboard and some visualizations and later realizes the user wants to add or remove some description forms. Google Map visualization for newly created dashboard is not enabled by default for Visual Insight (Analysis) in MicroStrategy Analytics Enterprise Web 9. x search for Attribute elements has been designed in a way so while searching it will bring all the Elements with the matching letters being search. x - 10. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Create a new Visual Insight analysis or Dashboard from a report that contains Year, Category, and Profit. You create the customized, interactive VI dashboard in MicroStrategy Web, and use it. TL;DR: It's true often you can do a thing in desktop, but you can't do it in MicroStrategy web, or vice versa. In order to calculate the difference for a metric Revenue between Year 2011 and 2012 in MicroStrategy Visual Insight, MovingDifference function can be used to get the designed result. Currently, filtering on date attributes using a dynamic date feature exists for both visual insight and report services documents. 0. Add a Grid visualizations from Report 2. Create a Dashboard using both Reports as datasets. In MicroStrategy releases prior to MicroStrategy Web 10. However, when the tooltip has more data than there is room for in the visualization window, the tooltip grid gets cut off and there is no way to scroll. This Knowledge Base article describes how some users may find that bar graph do not render when adding certain data sets as well as the reason and code fix implemented to omit the issue. In the dashboard, change the attribute to the format that you need. In MicroStrategy Web 9. blogspot. 4. Refresh. Before Customization: After Customization: Launch the Web Customization Editor. Different steps therefore need to be taken in order to customize the source of this page successfully, while adhering to best practices in. Add two additional visualizations to the dashboard. Check 9. The dashboards can feature a wide range of compelling data visualizations including tables, charts, and maps for quick and easy data analysis. 1, a user has to scroll in a Visual Insight to view the whole bubble chart when there are many attribute elements in the bubble charts x-axis: In MicroStrategy Web 10. 3. 1. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe formatting will display as clear text, instead, as shown below, in MicroStrategy 10. In MicroStrategy Tutorial: Create a Report with Category, Subcategory, and Profit. Key in 'Category' between braces after the formula, as shown in the screenshot below. 1 Visual Insight Dashboard, users may notice that the options to “Keep Only”, “Exclude”, “Keep Only and Show”, or “Show Data” are no longer available when attempting to filter on existing visualizations other than simple grids.