The derived metric is now set to the level of Category: Published: Apr 4, 2017. Create a report with Quarter and Year attribute plus "Revenue" metric. 68K. Convert the Visual Insight dashboard to a Report Services Document. 1: Support showing Total values on the top position in grid in Visual Insight DashboardIn MicroStrategy Web 9. 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. In MicroStrategy Web 9. Workaround:In a Visual Insight dashboard containing a date attribute, right-click the date attribute and select “Create Time Attributes. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Number of Views 4. Automated Insights (Ai) helps organizations make better business decisions, faster. Create a new Dashboard with. 2. Click on the visualization containing the grid with the attribute. x. Save and Close. 4. MicroStrategy Visual Insight was included with the standard user licenses, had a flash based engine and it was working only on web (and mobile). 98K. When clicking on the marker to. STEPS TO REPRODUCE 1. There are several ways to create a Visual Insights dashboard from a prompted report. x Visual Insight (VI), the user does not have the ability choose attribute forms from inside VI. 4. 1, a user can view the whole bubble chart without having to scroll by choosing the option "Container (Compact)" in. x and 9. Instructions for MicroStrategy Web 10. 1, a bubble grid in a Visual Insight Dashboard does not display the metric value in the tooltip when the metric that is in the Color by section has the value 0When accessing Visual Insight Dashboards through MicroStrategy Mobile 9. 5: Launch the Web Customization Editor. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below. NOTE: This only works on Visual Insight dashboards with at least 2 datasets. Back then, the dossier editor (formerly known as Visual Insight) was a powerful BI tool with limited design functionality. The following example shows how to access this in Chrome: Using Visual Insight in MicroStrategy 10. CAUSE: This is a known issue in MicroStrategy Web 9. How can users enable and show the search box for the "Check Boxes" filter display style in Visual Insight and Dossier in MicroStrategy Web SYMPTOM: In some scenarios, the "Check Boxes" style filter provides a search box to help in narrowing down the list of available filtering elements. It allows the user to import data from several different sources, manipulate. In the Project Property Pages, navigate to C/C++ > Optimization. 1, the ability to link/unlink attributes in Report Services documents and Visual Insight dashboards was introduced for data import cubes. Upgrade to this version to take advantage of this fix. 3. Micro Strategy also supports mobile BI. In Visual Studio 2022 version 17. 3 things have progressed immensely since and visual insight can be used to create some serious dashboards which can bring true business value on all levels. This issue has been addressed in 10. MicroStrategy 2 min #04 - In Memory, Live Connect, Multi Source, why would you need to choose ? Agile BI - In-Memory capabilities provide tremendous acceleration to your Dashboards. 5 that a horizontal bar graph in Visual Insight shows duplicate metric titles. It can be executed in Express and Flash modes also. CAUSE: This is a known limitation of Visual Insight in MicroStrategy Web. Right-click the attribute and select 'Add to filter'. 1, and it is currently being evaluated for a potential fix in a future version. 1 for iOS. Reports. Create an Intelligent Cube, with Region, Category, Cost and Profit. Create a Visual Insight dashboard using the report from step 1 as a dataset. 0. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; Consulting Import and refine data to create datasets in dashboards. Step by step instructions on how to create a virtual time period attribute with the values MTD, QTD, YTD using a MicroStrategy Custom Group. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingFollow the steps below using the MicroStrategy Tutorial project: 1. STEPS TO REPRODUCE: 1) Create a New VI Dashboard (choose any Dataset as the issue is not related to the selected Dataset) 2) Add a Text Field (Tools -> Add Text Field)Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThis Knowledge Base article describes how to create a derived metric that can use the whole dataset of the report, rather than the default functionality of using the grid dataset using the Lag function as an. For more information and steps to create an alert-based subscription, see the MicroStrategy Mobile Administration Help. 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. D3 Visualization is supported starting from MicroStrategy. Create a dataset with Category, Item, Revenue, and Profit Margin. Cards. x, and 10. 1After changing Heap Map to Grid, users will see that there are thresholds automatically applied to the grid after the conversionWhen exporting a Visual Insight dashboard containing ESRI maps, the following message is displayed: Map requires a connection to MicroStrategy Web . 4. Design workflows, create content groups, or customize application components with the no-code framework. create a derived metric named "Metric Selector". 4. The following customization will remove the "Browse All Objects" and "All Objects" links from the Dashboard Datasets options in Visual Insight Dashboard. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. x. Create a Visual Insight dashboard and. This issue does not occur for pie chart graphs in report services documents. KB322853: The "Hide null/zero" option stops hiding nulls and zeros in a Visual Insight graph after adding new object to the graph in MicroStrategy Web 10. Visual Insight allows you to streamline the tasks required to create a polished dashboard. Create a Visual Insight Dashboard with report 3. In MicroStrategy Web 9. The VisualizationGallery. In MicroStrategy Visual Insight 9. Format, analyze, filter, and layer the visualizations to create appealing, insightful Visual Insight (VI) dashboards through the MicroStrategy Web interface. x. Notice the selections don't get cleared, the data just gets refreshed. One use case is to determine if a Visual Insight Dashboard is new. Create a metric with the filter. 1 application for iOS. Key in 'Category' between braces after the formula, as shown in the screenshot below. The PDF file exported from Visual Insight cannot be saved in Chrome for MicroStrategy Web 10. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Add it to the grid. Problem is: 100% in-memory solutions cannot fit all your requirements. How to Add an Image to the Toolbar Section for Document Pages, Including Visual Insight using the MicroStrategy Web SDK 9. x. Create an Intelligent Cube, with Region, Category, Cost and Profit. Check the Merge checkbox under Rows in the Header section. In MicroStrategy Web 10. 3. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. Number of Views 31. Create a metric with the filter. Create a bar graph visualization with the Custom Group and a single metric. New Feature in MicroStrategy Web 10: Ability to create element groups in Visual InsightWhy MicroStrategy Why MicroStrategy; Customer Stories; PlatformFiles(1) Create your own dashboards in less than ten minutes and without any help from IT. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformIn MicroStrategy Web 9. 1Vitaracharts is a library of 25+ visualizations for MicroStrategy Desktop, Web and Mobile. 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. However when exporting multiple grid visualizations from the same dashboard in MicroStrategy Web 10. <b>Atlanta</b> STEPS TO REPRODUCE: Create a report with an attribute that uses an HTML tag. STEP 1: Enable the MCE trace. 7 functions differently than other pages. 4 for the ESRI map widget visualization filter. Create a new Visual Insight and add a report that contains an attribute to the dashboard. Create a report with: This article describes how to create a metric with an attribute as a filter using a Case statement in a Visual Insight dashboard in MicroStrategy Web. Save this as "Document1" Create a new Blank Document. 4. 4. However, users may notice that in certain scenarios, the link/unlink option is either greyed out or does not appear. 5Visual Insight allows you to create customized, interactive dashboards that you can use to explore your business data. Users can also move a column "Left", "Right", or "Move to Beginning". 1, a user creates a Visual Insight dashboard and wants to remove “Convert to document” option in order to prevent other users from a conversion by mistake. x. In a Scatter grid or Pie chart Visual Insight dashboard, a text metric does not display in the tooltips. Before Customization: After Customization: Launch the Web Customization Editor. 0, when opening any window within a Visual Insight dashboard that includes a scroll bar, there is a noticeable delay where the scroll bar will not move until a second or two after. SYMPTOM: In MicroStrategy Web 10. 0 An analysis is created in Visual Insight mode. 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. Add two attributes to the grid. It allows the user to import data from several different sources, manipulate the data, and apply visualization techniques as per business needs. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Add a Grid visualization from Report 1. 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. Drag an element from either attribute. 86K. Click Run to create the metrics listed. 1 Visual Insight in Microstrategy 9. 2. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 0 . 3. 4. x, an Exclamation mark is displayed, rather than the Visual Insight Report, this article describes how this problem can be handled. STEPS TO REPRODUCE . ADDITIONAL TROUBLESHOOTING: Telling a Story with MicroStrategy Dossier. 1 and 10. 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. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. VI Dashboards allow users to quickly and elegantly display and consume data. Save the document. Create a Dashboard using both Reports as datasets. We’ve evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. 6, it is possible to hide the visualizations gallery for Visual Insight using the following parameter in URL API: hiddensections=gallery A sample URL would look like the one below:Narratives generated by Automated Insights’ Wordsmith. 4. 3. For example, you can:When running a Visual Insight report in MicroStrategy Web 9. 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. Click the name of your report to execute it. STEPS TO REPRODUCE 1. xHowever, there is still a way for users to view back-end data in a Visual Insight dashboard. 2. Choose the setting to show Values as data labels in the visualization properties under Shapes and Data Labels. The impact is limited to the MicroStrategy Web 9. Change column width. These are the steps to enable this feature: 1. 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. 2. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThis is a short demo for how to use MicroStrategy Analytics (formerly known as Visual Insights pre 9. Press the Select Target button. Select all selections for that selector. Add an attribute to the filter panel of any type. Dashboards can be emailed as a PDF to other users. 4. 0, as seen in tech note KB249716. The HTML container can be added either as an. Select project properties. 5 and above, it is possible to hide the black toolbar for Visual Insight using below parameter in URL API: hiddensections=dockTop A sample URL API would be:This Knowledge Base Article outlines a defect where the title bar of a visualization does not retain extra spaces or tabs in Visual Insight or Dossier. Google Map visualization for newly created dashboard is not enabled by default for Visual Insight (Analysis) in MicroStrategy Analytics Enterprise Web 9. This is a javascript. ACTION: Grant at least View access to the Light Theme Object to create new Visual Insight dashboard. 4. 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. Rename the metric in dataset object panel. 4. KB220960: The Show Data "+" drop down menu does not scroll in Visual Insight in MicroStrategy Web 9. In MicroStrategy, create an attribute that can return all the location data for each entry. 77K KB318747: How to apply view filters for individual visualization in a Visual Insight dashboard in MicroStrategy Web 10. 1Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformTo Create Metrics. In order to utilize the feature, one can: 1. 4. For example, you can: Add, rearrange, or remove report objects quickly from a visualization in a dashboard. Consider the following four scenarios: Why MicroStrategy Why MicroStrategy; Customer Stories; Platform This video walks through how to use in-memory and live data in a single dashboard. 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. When users create a Grid visualization in Visual Insight using MicroStrategy Web 9. In this tutorial, you learn how to set an alert on a report to get an email once the conditions of the alert is met. Create a new Visual Insight and add a report that contains an attribute to the dashboard. Loading. Create a visual insight and add Category to the grid. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe formatting will display as clear text, instead, as shown below, in MicroStrategy 10. 1 Hotfix 5. 4. Visual Insight dashboards are quicker to design than Report Services documents. MovingDifference. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. In MicroStrategy Web 9. Grid selector information is lost when converting a Visual Insight dashboard into a Report Services Document, in MicroStrategy Web 9. Please observe the below screenshot (on top). 4. Right click on the filter on the filter panel. com Format: A MicroStrategy Online Training Video blog. choosing metric and condition. 5. CAUSE: This is expected behavior. You can share a dashboard through email, by linking to the dashboard, or by embedding the dashboard in a web. Display the dashboard as a Bar Chart. Currently, it is not supported to keep the format when refresh RS document or VI dashboard from. x, not all of the data labels show, like shown below. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user. 1. Advanced Apps. x, pie chart visualizations in Visual Insight dashboards and Dossiers do not show slices for elements with small percentage values. Date filter in Visual Insight displays elements in a reversed order in MicroStrategy Web 9. 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. Web Professional . KB219522: How to access the SQL view of a Visual insight Dashboard using an MCE Trace in MicroStrategy Web Number of Views 2. js library in Visual Insight Dashboard in MicroStrategy Web using Web SDK. Refresh. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. In the Select Dataset dialog box,. set ("height", (window. 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. Tooltip is not visible. Users can import data (modeled or not) and immediately create interactive visualizations and dashboards. x, users expect to see the description appear in the tooltip when hovering above the object. 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. When running a Visual Insight report in MicroStrategy Web 9. x. 5 and later: For steps on how to remove a toolbar item in Visual Insight with the MicroStrategy SDK 10. 7 MicroStrategy Visual Insights visualizations. "Re-prompt" option is also available under "File" menu. 1. Notice the name of the metrics appears twice: STEPS TO REPRODUCE: Create a new Visual Insight dashboard in MicroStrategy Web 10. This behavior has been logged as a Defect by MicroStrategy Technical Support for version 10. 4. 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. x and above. Security; Next Steps; Overview. It was tested that in MicroStrategy 10. Number of Views 4. The following KB article iterates through the formatting properties and values of a grid object from a Visual Insight dashboard using the MicroStrategy Web SDK 10. 4. 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. Right-click the attribute and select 'Add to filter'. In Visual Insight in MicroStrategy Web 9. CAUSE: This is an identified defect in MicroStrategy Web 10. 4. Right-click the Region attribute on the grid and select "Attribute Forms" and then "ID". 1. x product when data value for derived metric component is a warehouse null. The ability to create Derived Element Groups in Visual Insight was introduced in MicroStrategy 10. Add a filter. Introduction to Visual Insight MicroStrategy Visual Insight Essentials 1 20 from DATA ANALYSIS 102 at NIT RourkelaVisual insight provides the user with the ability to create quick, interactive dashboards. 4. Users can manually check to not display this page again. CAUSE: This is a known limitation of Visual Insight in MicroStrategy Web. After renaming an attribute or metric on a report or data set that is used in a Visual Insight dashboard in MicroStrategy Web 10. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 3. Add a second visualization just so that the graph matrix is pushed into a narrower size. The result does not. x 4. Web Professional and OLAP. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. After making modifications in the underlying report and saving it, existing Visual Insight. Create a new plugin and give it a meaningful name, such as addButtonToVI, and click OK. KB45422: Korean is broken in Search Box display type Filter in Visual Insight in MicroStrategy Analytics Enterprise Web 9. x, attribute elements values appear in blank in the Filter Pane of a Visual Insight Analysis; however, the Filter Pane continues acting as filter, as shown: CAUSE: In this case, this issue was noticed after adding new Attribute Forms to the referred Attribute and for an unknown reason the Attribute Form used as Report. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. 2. At least View access needs to be granted for this object as it is required to create Visual Insight dashboards. Hiding the Navigation Bar in a MicroStrategy Web Document. When the attribute used as a selector has a compound key, i. Refresh. Add a Grid visualizations from Report 2. 4. Customize the format of the imported document; 3. Add this code to the JavaScript file that was created: mstrmojo. Add a grid with the attribute Customer. This issue occurs for all versions of MicroStrategy Web 10. 5. 4 Visual Insight, users do not see the option to. The following snippet can be extended through the RWExecute task or used in standalone code. 2. MicroStrategy Insights Starting in MicroStrategy 2021 Update 7 (September 2022), Insights are supported in MicroStrategy Library (web browser only) on the. Number of Views 578. ACTION: Contact MicroStrategy Technical Support for an update on the status of the issue. Once added from the top menu toolbar it appears on top of the visualizations in the dashboard. Drag an element from either attribute. blogspot. This article details a case in which the sorting is not applied to a Vertical Bar graph when done on a metric in a Visual Insight dahboard in MicroStrategy 9. Add a Grid Visualization with Country as an attribute and Cost as the metric. x and 10. Open the Diagnostics and Performance Logging Tool from the MicroStrategy Intelligence Server machine. 1. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. 18K. The fuel for business dashboards is data, so each one needs to have one or more data sources. Don't choose the type of visualization yet. 1 and aboveThe search box filter stops working at times when running a Visual Insight dashboard with MicroStrategy Web 9. Without data, the dashboard will not show the user anything. N/A. Use the “Browse All Objects” option to add the “Category” and “Item” attributes to the visualization, as well as the “Revenue” metric. x. Create a new plugin and give it a meaningful name, such as addButtonToVI, and click OK. 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. This feature is available in MicroStrategy Web 10. However, when a user replaces a dataset with an identical dataset in a MicroStrategy Web 9. Toggle the filter values. 3. In MicroStrategy Web 9. You can also display VI dashboards on an iPad with MicroStrategy Mobile. Create a Visual Insight dashboard and add the above cube as the dataset: 3. 2. When users create or run a Visual Insight Dashboard for the first time, they are presented with a Welcome screen page called "Getting Started" which has a short demo video of the Visual Isight features. Disabling the Legend for a Heat Maps in a Visual Insight dashboard still shows the legend in MicroStrategy Mobile 10. 4 Hotfix 4, within the “MicroStrategy Tutorial”, create a new VI dashboard. x when viewing a dashboard where a threshold is set on a percent metric the legends display incorrectly with the negative range displaying positive values if the selection chosen does not have any negative values as seen below. 4. Data can be connected through an API, flat file, or database. 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. The Select Dataset dialog box opens. x. 4 and newer using the Advanced Threshold Editor. Create a Dashboard in Visual Insight using the report and insert both attributes and metric into a grid visualization. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. Create an Intelligent Cube with "Customer", and add the attribute form "Email" into the cube. STEPS TO REPRODUCE: 1) Create a VI in 10. This means the Visual Insight filter is applied after the aggregate from base metric has already calculated. This tutorial shows how to create derived attributes and metrics in a dossier. Check 9. This issue does not occur for pie chart graphs in report services documents. Right-click on the document. 1Create/Save a new Visual Insight analysis . Create a report based on the Intelligent Cube. 0: Network Visualization widget in Visual Insight. This article describes how to remove a toolbar sub-menu item in visual insight dashboards using the MicroStrategy Web SDK 10. 1, create a Visual Insight dashboard. CAUSE: This is a known limitation of Visual Insight in MicroStrategy Web 9. Create a second Report with Category, Item, and Revenue. The following steps will add a toolbar item in MicroStrategy Visual Insight Dashboards using the MicroStrategy Web SDK 10. Before Customization: After Customization: Launch the Web Customization Editor. x. Visit the data visualization and data dashboard galleries for inspiration. 5. Upon making this selection, the row headers will now be merged. 4. Separate attribute forms should be created for latitude and longitude, and should also support the numeric data of these values. Using report filters instead of Visual Insight filters or using filters based on attributes instead will work correctly. Create additional visualizations to display the data in multiple ways, then easily modify, rearrange, or resize visualizations in a dashboard. STEPS TO REPRODUCE: Create a line graph on a Visual Insight dashboard. 1Import a RS document or VI dashboard into Excel with MicroStrategy Office; 2. 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. Content. This Knowledge Base Article outlines a limitation of MicroStrategy Web 10. Press the Select Target button. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence. In an upgraded. 2) Create a custom group based on one of the attributes in the report. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Create a Dashboard using both Reports as datasets. x MicroStrategy 2 min #32 - Metric and Attribute Selectors in Dossier / Visual Insight. In MicroStrategy Tutorial: Create a Report with Category, Subcategory, and Profit. The HTML container can be added from the top menu toolbar. 4. Adding a dataset from the sub menu options in a Visual Insight Dashboard does nothing in MicroStrategy Web 9. If the first date argument is later than the second date argument, the result is a negative number. In the dashboard, create a derived metric, RankBy using the Rank function based on profit for Top10. Add a Grid visualization from Report 1. "The. 4. ACTION:This issue has been classified as a defect by MicroStrategy. A developer may need to know the number of datasets within a Visual Insight Dashboard. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. In MicroStrategy Web 10. 1Create a report with one attribute and one metric. In MicroStrategy Web 9.