Microstrategy compound grid. Metric with an IF Function. Microstrategy compound grid

 
 Metric with an IF FunctionMicrostrategy compound grid  Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik

Using the Connector. Click Insert Visualization to add a new, blank visualization to the dossier. Click Insert Visualization to add a new, blank visualization to the dossier. 1 and 10. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. [データセット] パネルで、アトリビュートとメトリックをダブルクリックし、ビジュアリゼーションに追加し. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). Right-click on a dossier. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. General Settings. in Microstrategy Dossier, is it possible to create 2 rows of header, such that the first row is the grouping information and spans to number of columns to identify as a. This section helps you choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Formula and dimensionality are the two important components in a metric. 1 and 10. Click More in the top right of the heat map and choose Create Contextual Link and select This Dossier. compound attributes. From the Visualizations panel, select Grid . Select one of the following export formats: To export the report to an Adobe PDF file, select PDF. For example, users can have a smart compound metric and a component metric of this compound smart metric on the grid in the document. However, o n iPad with MicroStrategy Mobile 9. To prevent users from navigating out of the document, they might want to hide some sections from the page. While all metrics have a formula, not all of them have. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. For example: Create a line graph with Revenue,. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. To do so, click Tools > Report Details Page after the report has. Tasks. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. When setting a grid as a selector of another grid in Visual Insight in MicroStrategy Web 9. The Grid Settings section allows you to select the Fit to page option, which fits the grid's width onto one PDF page width, or you can select the Allow horizontal pagination option, which breaks a wide grid onto numerous pages. A visualization is a visual representation of the data in a dossier, such as a grid, line chart, or heat map. Compound Statements. The graph shows revenue by category and region. Labels: #Prompts in URL API #mstr urlapi. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. promptAnswerMode *. Type a name for the metric in the Metric Name field. In MicroStrategy SQL Generation Engine 9. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. It is now possible to format column groups differently, freely alternate the placement of metrics and attributes in the column headers for each group of columns, or choose which columns of the Grid should show the subtotal value or all values. Select More Options at the bottom of the pane. Color from the Advanced Color Picker will. View the visualization's name and data requirements. Creating Waterfall Charts. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. 5. The report using in this example has the following structure when executed in Web or Developer: Region,Income Bracket, Metrics, Revenue. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. However, the "Report returned no data" message does not necessarily indicate that a null value has been encountered. Mar 17, 2022 -- 2 Working with data is fun! Recently I found myself obsessed with MicroStrategy’s grid tool. Graph: Displays the data visually like a standard MicroStrategy graph report. Metric with an IF Function. . You treat one attribute as a child of the other and have a compound key for the lower level attribute. E2open - MicroStrategy Training. 4 and later. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. . To use Natural Language Query, go to the Dossier Authoring interface (Web, Workstation, or Desktop), and click on the insight icon located at the top right corner: . This groups them, but doesn't label them quite yet. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Relationship tables in Microstrategy. A normal attribute represents a single hierarchy level (for example, Month). Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. From the Visualizations panel, select Grid . The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Subscribe. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Below are the steps to enable/disable the settings of data blending: 1. x, the series lines do not inherit the color of the series markers and change depending on which metrics are displayed on the graph. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. x-10. Erstellen einer zusammengesetzten Tabellen-Visualisierung. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Click Insert Visualization . Custom grids allow you to utilize dynamic text fields in order to create grids that provide mo. (Does it sound like multisourcing for all the users without admin help?)MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. This design may look strange, but in most cases there are. It is used to apply database (row-level) security to a MicroStrategy user. How to Share a Dossier. Export a dossier when viewed in presentation mode. In this case, the only object in the columns for this grid is the metric "Revenue". A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Compound Grid visualizations. First, do "Change Visualization" on your grid and set it to "Compound Grid". Use the Visualization Gallery to perform the following tasks: Select a visualization's type. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. In MicroStrategy Analytics Enterprise Web 10, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI). x, select 'Project Documentation' from the Tools menu to start the wizard. For example, a document contains two Grid/Graphs. This article provides a list of new enhancements and default settings available to users exporting a dossier to a PDF in MicroStrategy version 2020 of Workstation, Web, or Desktop. Learn how to switch to a compound grid, add column sets in this new visualization. Export Page-By Information: Selected by default. The Grid/Graph is displayed as a grid or as a graph, depending on how the report is displayed. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. The graph legend or axes can be formatted as well. Users sometimes encounter the "Report returned no data" message when executing a report and are unable to display the report result as an empty grid instead. Open a new or existing dossier. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. 1, the value range of the metric slider changes accordingly. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). {&GROUPLABEL} Name of the graph item's category. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. A dataset is a standard MicroStrategy report. For the Time hierarchy, the offset can. 最上部のツールバーで、 [ビジュアリゼーションを挿入] をクリックします。. 11. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. The compound join saves memory space and processing time on the Intelligence Server executing the document. 4. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Super Cubes in MicroStrategy 2019 Beginning in MicroStrategy 11. 4 and later. 2. But this behavior can be changed by using the 'From Clause Order' VLDB property under the 'Joins' folder. The simple key shows how you can identify a calling center with only its Call_Ctr_id. To export a report while viewing it, click the name of a grid report to display it. Follow the steps below for an example of how to do this. x, select 'Project Documentation' from the Tools menu to start the wizard. Select the entire visualization or just the area you want to format. If the document is being displayed on an iOS device, you can link the report to the cells of a transaction table. Step 1: Figure out how many electrons the molecule must have, based on the number of valence electrons in each atom. MicroStrategy Library is an interactive application of the MicroStrategy Business Intelligence platform that lets business users harness the analytical power of MicroStrategy in a simple, clean and modern user interface. In this tutorial video, we'll show you how to modify Grid visualizations in MicroStrategy to export them to Excel. x. 5. The Group Editor opens. Open the dossier you want to modify. Upon making this selection, the row headers will now be merged. Turning on totals returns a row for the total, even though there are not rows of data to show. Click the vertical eclipse icon (More) on the top right of the visualization. Create a Report Services Document 2. Create a compound metric called B with expression "RunningSum(A)" as shown below. Run the document on iPad, as shown below: 12. There's a reason we're at the top of the list. Note how a grid is returned with the total when there are no rows of data: Cause This is a known issue in MicroStrategy 10. 4074 views · September 04, 2020. 1929 views | September 04, 2020 02:01. Copy individual cells from grid visualizations to the clipboard. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. This means you can have multiple. New workaround Attribute left outer join effect in MicroStrategy Web Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. The spreadsheet retains the formatting of the report as displayed in MicroStrategy Web, such as colors, fonts, and structure. Use the Visualization Gallery to perform the following tasks: Select a visualization's type. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. Incluso, si. In the Editor panel, click Add Column Set to create another column set. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. Excel: This allows the user to export the document to Microsoft Excel in . Learn how to switch to a compound grid, add column sets in this new visualization. Creating a. xls format. Use the links below to create visualizations using the Visualization Gallery:The grid is targeted by a grid selector and a metric slider selector. Set Data Engine Version setting to 11 or. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. Example 1: Compound key with Effective Date and End Date. Select the desired option for 'Show attribute names'. x, follow the steps below:. The following general formatting options are available to format data cells, columns, and rows in the grid visualization: Enable Banding: Select this checkbox to apply alternating colors to rows in the grid. MSTR Health Center (if it's not uninstalled) MSTR Office (if installed) DHTML Editing Component (if installed) Restart the machine. To access the Advanced Sort dialog: Select a grid visualization. Enable Outline: Select this checkbox to enable outline mode. I'm showing on a grid visual unique IDs from the fact table and a measure that checks if there is value in a specific column in the fact table for the selected id. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. Excel with plain text: Export the report to Microsoft Excel as plain text. A compound grid with more than one column set is being used (image for reference): While looking normal in the dossier: After exporting to excel, the rows are not. Tasks. Enable the Show attribute names parameter. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. A normal attribute represents a single hierarchy level (for example, Month). 1919 views | September 04, 2020. Export Report Title: Selected by default. The Grouping panel is displayed. View data in simple grid format and leverage page-by options. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. That's why it show a static text "{[New Derived. Click Insert Visualization . 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. A compound attribute is an attribute with multiple columns specified as the ID column. 364 subscribers. Get the exclusive on MicroStrategy Workstation. Microstrategy Dossiers With the release of MicroStrategy 10. Go to project configuration by right clicking on specific project (You need admin rights to do this). However, the SQL used to execute the report can still be viewed and obtained. This metric is used for getting "1" value for all rows. x-10. The data from the datasets is used to populate the report. Click the Options icon . For steps and information on how the datasets are joined, see the. 4. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. promptAnswerMode *. Insert an HTML container (and not an image) and insert the script below. 0 or above. Visualizations provide a variety of ways for you to display and interact with the data in a dossier. Export: Choose Whole report vs. [REVENUE2], NULL)" It is essential to include the Name function when using = in place of IS. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. MicroStrategy recommends that when choosing your colors, to keep the 60-30-10 rule in mind. Metric Expressions. Create or edit reports with authoring functionality. Create a Compound Grid. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. Create a report with the Region and Month attributes and the Revenue metric in the grid and filter. In the example, Year 2001 has value for Item Sold but not for Sales. The Profit metric is a simple sum of the Profit fact. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). In diesem Lernprogramm erfahren Sie, wie Sie zu einer zusammengesetzten Tabelle wechseln, Spaltensätze innerhalb der zusammengesetzten Tabelle hinzufügen und einen einfachen Anwendungsfall für die Nutzung dieses neuen Visualisierungstyps finden. Select Custom as the Category and create the format using the number format symbols listed in the table below. Creating a 'Compound Grid' 4104 views | September 04, 2020 02:40. Microstrategy Dossiers With the release of MicroStrategy 10. 4. 11?; Knowledge Base: Annotate. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. E2open - MicroStrategy Training. In this case, only one form exists for each, as shown below:Microstrategy Document Editor Sections Important Notes: The Layout area is in the center of the Document Editor interface and provides the framework for precisely controlling where controls (such as text fields, grid and graph reports, images, and widgets) are displayed when the document is viewed in different display modes, printed,. This tutorial will guide MSTR users to share dossiers through Web and Library. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. This article describes how to display username on the report grid with MicroStrategy Developer 9. Made up of two or more grids of any type (column, modular, symmetrical, and asymmetrical) on one page, they can occupy separate areas or overlap. To create a MicroStrategy Environment connection file . Export server-level settings and import them for use with another server. The contents of the grid report are displayed, separated by commas. The effects are summarized in Level metrics. intelligence platform that adds in-memory delivery applications. Follow the simple steps below to create a datamart report: 1. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. Relate tables contain the ID columns of two or more attributes, which will define associations between them. Related articles from the Community: Knowledge Base: Dossier is no longer certified when downloaded as a . The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. 4. For example, a document contains two Grid/Graphs. 4 and later. x and 10. x: Create a metric called A with expression "Min(1){~}" as shown below. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Input connection parameters for the connector:MicroCharts are visualizations that MicroStrategy has in Document, but not in Dossier. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Create a second metric identical to the first, but add the predefined Year to Date transformation. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Learn more. compound attributes. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. HTML: The grid report is exported to an HTML file. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. Grid Settings You can choose how to export wide grids. Insert an HTML container (and not an image) and insert the script below. Add an attribute and a metric to both Column Set 1 and Column Set 2. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. You can quickly create multiple element groups at the same time. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. 6. Select only Configuration Objects for documentation. Click the Options icon . In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. Fields. When a display alias is set for objects in a grid, the object alias is not displayed in the report filter in MicroStrategy Developer. Data from the input objects defined in the Transaction Services report is displayed in the grid, text fields, or cells for users to. In the top toolbar, click Insert Visualization . The third pass combines the results from the first two passes to generate data for Unit Sales and returns the final result to the end user. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Overview of level metrics in MSTR. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. Foreign Keys Panel. Notice that some metrics from the right grid are missing. To enable totals or subtotals for a metric. With a few lines of code, data scientists can extract data from cubes and reports and publish entirely new datasets for consumption by other analysts. x - 10. This can be in the form of graphs, charts, maps or other graphic depictions that. The following procedure describes how to achieve this: Create the highest level filter. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. You can import business data from many different sources, including local files, databases, Google Drive, etc. Drag and drop the . Even after following the steps in KB37102: The color of a series in a graph changes depending on the information that is displayed by the graph in MicroStrategy 9. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. In the Editor panel, click Add Column Set to create another column set. How to Share a Dossier. Enable Outline: Select this checkbox to enable outline mode. KB298312: Subtotal of a compound metric doesn’t show correctly in Visual Insight in MicroStrategy Web. 4 and later. 3. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Export server-level settings and import them for use with another server. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. x, follow the steps below:. Click the grid visualization to label that as the target. This feature is only implemented for element list prompts. Excel with formatting: The report is exported and displayed as a Microsoft Excel spreadsheet. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. Create a metric that sums the fact Units Sold. Line: Select the style of the grid lines from the drop-down list. Create a compound metric "Count Employee" as "Count Employee temp" + "Zero" with the definition: ( + Zero) Under the "Subtotals/Aggregation" tab, enable the setting "Allow Smart Metric", at the bottom of the pane: Use the compound metric "Count Employee" on. All Grid Fonts: Select font formatting options for all text. This means that every metric is evaluated in separate SQL passes. Click Certify. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. Grid Panel. Copy individual cells from grid visualizations to the clipboard. Compound grids offer enormous flexibility and a lot of room for creativity. Step 2. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. This version of the product is no longer supported in accordance with MicroStrategy's support lifecycle. Save designs as templates. An input box will be displayed with a list of recommended questions based. This may make related application objects (reports, filters. Use the links below to create visualizations using the Visualization Gallery:Considerations for the use of star schemas with MicroStrategy SQL Generation. x and 10. Click Insert Visualization . Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. This is an excerpt from my presentation at the July meeting of the San Francisco Bay Area MicroStrate. General Settings. This case is also explained with an example based on the MicroStrategy Tutorial project. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. This document provides the steps to accomplish the same. Connecting Tableau to TDV Using ODBC. DAY_DESC. MSTR Secure Enterprise. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. 9, we’ve taken a leap forward in our dashboarding capabilities. To reference an image using relative path, the following. [グリッド] > [複合グリッド] を選択します 。. In the drop-down on the selection bar, select. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. New workaround Attribute left outer join effect in MicroStrategy Web Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. The Profit metric is a simple sum of the Profit fact. Create a Report Services Document 2. This document provides the steps to accomplish the same. Make two grids with different attributes and metrics in each 3. The graph legend or axes can be formatted as well. Create. Learn to share exact chapter level filter state of the dossier by embedding a filter in the comments. In a document, you can display a report by adding a Grid/Graph to the document. The "Grouping" property has six possible. Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. Then it creates a third metric, a compound metric. This video show how to share a filter with other MicroStrategy Library users. In the list of categories on the left, click Subtotals. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. Use the links below to create visualizations using the Visualization Gallery:The grid is targeted by a grid selector and a metric slider selector. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. Like other visualizations, a Compound Grid can be used as the target of a selector. In MicroStrategy 2020, the Export to PDF window in a dossier allows for more customization and provides new default settings. Portion displayed only (only the displayed page if multiple pages). 3. MicroStrategy is an enterprise BI application software. How to use the MicroStrategy 2020 compound grid. Click Advanced, then New to create a custom subtotal. Type the following for the name: "Total for the #P #0". 678 views 2 years ago MicroStrategy 2020. View the visualization's name and data requirements. 02:40. x When a security filter is used, different users get different report results when the same report is being executed, hence there might be a need to include the name of the user who generated the report in the grid to differentiate the. 5. Add data to the report and leverage formatting capabilities in the modern Library interface. A Compound Grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. communicate with mapping. Upgrade to MicroStrategy 11. You treat one attribute as a child of the other and have a compound key for the lower level attribute. The following code sample will execute a report using a ReportBean, and output the column headers from the report grid. Assuming CP1252As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. Continue with the previous Steps 2 and 3 above. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. . You can display data in a grid layout. Microstrategy Dossiers With the release of MicroStrategy 10. Make two grids with different attributes and metrics in each 3. From the Insert menu, point to Widgets, and then select Microcharts. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. Cardinality Statistics Panel. A compound grid requires at least one attribute and one metric. Select the 'Advanced' tab, as shown. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. 4.