Table of contents<\/h3>\n\n- \n\t\t\t\t\t
\n1 New display of ratings
\n<\/a><\/li>\n- \n\t\t\t\t\t
\n2 Parallel processing of status steps
\n<\/a><\/li>\n- \n\t\t\t\t\t
\n3 Images in activities
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.1 Definition of a new dashboard
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2 Dashboard Designer
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.1 General
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2 Design dashboard
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.1 Creating a new dashboard
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.2 Table
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.3 Diagram
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.4 Instrument
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.5 Pivot table
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.6 Indicator
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.7 History
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.8 Map
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.9 Image
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.10 Text
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.11 Global filters
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.12 Predefined filters for individual elements
\n<\/a><\/li>\n- \n\t\t\t\t\t 3.2.2.13 Interactions
\n<\/a><\/li>\n<\/ul>\n1. Display MSO Dashboard<\/h3>\n
A dashboard created using the Report Designer can optionally be displayed in up to two different places: (1) Reports; (2) Dashboards;<\/p>\n
(1) If you select the \u201cReports\u201d option when creating your dashboard, the dashboard can be accessed and analyzed via the \u201cReports\u201d tab, just like all other reports.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_1-1.png\")
\t\t\t\t\t\t\t\t<\/a>
\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_2-3.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n(2) If the \u201cDashboard\u201d usage is selected, the dashboard appears after calling up the \u201cDashboard\u201d tab. It is important to note that only one dashboard can be selected for this display. This means that the dashboard selected first is always visualized in the corresponding tab.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_3.png\")
\t\t\t\t\t\t\t\t<\/a>
\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_4.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nNote: If you open the \u201cDashboard\u201d tab although no dashboard\/report has been selected for use in the dashboard, the following message appears:<\/em><\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_5.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nNote: If you cannot see the \u201cDashboard\u201d tab in your application, this function must still be activated for your application by MSO. Accordingly, please contact us directly.<\/em><\/p>\n2. Use MSO Dashboard<\/h3>\n
MSO dashboards offer a wide range of functions and serve as the perfect BI tool for analyzing your data cubes. The respective functions are defined as part of the creation process (see chapter 3) and can therefore vary.<\/p>\n
(1) A major advantage of MSO dashboards is that several diagrams can be displayed on one page and that clicking on a specific area in a diagram filters all other views to this area. If, for example, only complaints relating to the country Sweden are to be displayed in a complaints dashboard, the entire view can be filtered by clicking on the corresponding map section. (As an alternative to a filter function, links can also be opened by clicking on certain areas of the dashboard, allowing measures to be edited directly, for example).<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_6.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n(2) If a filter is set by clicking on an element of a diagram, it can be removed again by clicking on the filter symbol at the top of the respective diagram.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_7.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n(3) In addition to the filter function, each individual diagram can also be re-sorted, displayed in full-screen mode and exported as a .pdf, image or Excel file.<\/p>\n
(4) In addition to these functionalities per diagram, the dashboard can also be displayed as a whole in full-screen mode and exported as a .pdf, image or Excel file. The corresponding buttons are located above the dashboard. The dashboard data can also be updated at this point.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_8.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3. Create MSO dashboard<\/h3>\n
The creation of dashboards is very similar to the already familiar procedure for creating reports. The most important steps for creating a dashboard are described in the following chapters. For a comprehensive description of all functions, please refer to the report\/dashboard designer manufacturer’s manual: https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/index.html?dashboards.htm <\/a><\/p>\n3.1 Definition of a new dashboard<\/h4>\n
(1) To create a new dashboard, first switch to the administration area and select the \u201cReports\u201d field in the \u201cOther settings\u201d section.<\/p>\n
(2) Then click on \u201cNew report\u201d, whereupon the definition window for a new report or dashboard opens.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_9.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n(3) Give your dashboard a name and specify where the dashboard should be displayed (see chapter 2) (1). After clicking on \u201cNext\u201d, you can determine which database fields you would like to use in your dashboard. In addition to a few general fields (ID, Title, Status, Responsible, Responsible, ….), it can also be useful to include categories, global fields and event-specific data (2). Once you have selected all the fields, you can confirm your entry by clicking \u201cNext\u201d. Before you can start with the actual creation of the report, you must finally specify whether you only want to use data from a specific event (filter function) and whether the data should already be sorted (sort function) (3). These two functions are optional. Click on \u201cSave\u201d to save all entries and the program automatically opens the report\/dashboard designer.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboards_10.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2 Dashboard Designer<\/h4>\n3.2.1 General<\/h5>\n
The user interface of the report\/dashboard designer can be divided into three sections: Menu (1), Properties (2), Page\/Dashboard(3).<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_1.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n(1) The menu consists of a total of six tabs, \u201cFile\u201d, \u201cHome\u201d, \u201cInsert cells\u201d, \u201cPage\u201d, \u201cLayout\u201d and \u201cPreview\u201d:<\/p>\n
File:<\/strong> Save all changes, exit the Designer (back to the database) and call up the documentation.<\/p>\nStarting position<\/strong>: Editing of all texts and fields (font size, color, background, frame, … ? compare with Microsoft Word)<\/p>\nInsert cells<\/strong>: Add new dashboard elements (tables, charts, instruments, maps, text fields, images, indicators, filters).<\/p>\nPage<\/strong>: Definition of the page layout (between desktop and mobile application).<\/p>\nLayout<\/strong>: Editing the positioning of individual elements in relation to each other (\u201cIn the foreground\u201d; \u201cIn the background\u201d).<\/p>\nPreview<\/strong>: Preview of the created dashboard as it would be displayed in the database.<\/p>\n(2) The properties contain a total of three tabs, \u201cProperties\u201d, \u201cDictionary\u201d, \u201cReport tree\u201d:<\/p>\n
Properties<\/strong>: Each inserted element (table, diagram, …) has different properties, such as the labeling of the x- and y-axis. These properties can be edited accordingly at this point.<\/p>\nDictionary<\/strong>: Display of all data fields that have been transferred from the database to the reporting tool as well as a list of all newly calculated data columns or added data sources.<\/p>\nReport tree<\/strong>: Hierarchical display of all elements used in the report. Can be used for quick navigation as part of dashboard creation.<\/p>\n(3) The page represents the actual dashboard. All fields can be inserted here and positioned as desired (within the specified frame).<\/p>\n
3.2.2 Design dashboard<\/h5>\n3.2.2.1 Creating a new dashboard<\/h6>\n
By clicking on the \u201cplus symbol\u201d, you can insert both a new report page and a new dashboard. To add a new dashboard, please click on \u201cNew dashboard\u201d.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Desginer_2.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nNote: To display only the dashboard, the page that already exists by default (Page1) must be removed. This can be done by right-clicking on the \u201cPage1\u201d tab as soon as the new dashboard has been inserted.<\/em><\/p>\n3.2.2.2 Table<\/h6>\n
Various elements can be added to the dashboard using the \u201cInsert cells\u201d tab To insert a new table, the \u201cTable\u201d button must first be activated. The desired position of the table can then be drawn in the dashboard.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_3.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nTo display the desired data in the table, any elements of the dictionary can be added as columns. A new column is added to the \u201cTable\u201d field using drag & drop.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_4.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nAs soon as all the desired columns have been added, they can be edited further. For each column, you can specify whether it is to be displayed as a simple dimension, measure, bar, color scale, indicator or chart. In addition, you can also decide whether the table should have a result row and how this result is calculated (Sum: sum of all values; Min: smallest value; Max: largest value; Count: Number of all values; Average: Average value). Finally, the interaction can be used to define what happens when a corresponding cell in the table is clicked.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_5.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.3 Diagrams<\/h6>\n
To be able to insert a new diagram, you must be in the \u201cInsert cells\u201d tab in the menu bar. As soon as the \u201cDiagram\u201d button has been activated there, the placeholder for a new diagram can be drawn in the dashboard.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_6.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nData fields from the dictionary can then be dragged and dropped into the diagram. The default chart is a bar chart. Data columns that are dragged into the \u201cValue\u201d field therefore correspond to the y-value and data columns that are dragged into the \u201cArgument\u201d field correspond to the x-value of a classic diagram.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_7.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nAs soon as a data column has been defined as a value and this value has been selected with a mouse click, the chart type can be selected. A variety of common diagrams are available here: Column diagram; Line diagram; Area diagram; Range diagram; Bar diagram; Scatter plot; Pie chart; Network diagram; Funnel diagram; Financial diagram; Gantt diagram; Ring diagram; Bubble diagram; Sunburst diagram; TreeMap; Pictorial representation; Waterfall diagram<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_8.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nRegardless of the type of diagram, you can specify for each value how it should be calculated depending on the argument. To do this, the corresponding value must first be selected with a mouse click. The expression can then be edited and all available mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values) are displayed. Click on the desired operator to customize the printout and the graphical output.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_9.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.4 Instruments<\/h6>\n
A new instrument is inserted via the \u201cInsert cells\u201d tab. As soon as the tab is selected and the \u201cInstrument\u201d field has been activated with a mouse click, a new instrument can be added to the dashboard.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_10.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nThe placeholder can then be filled with any column of the dictionary using drag & drop.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_11.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nAs soon as a data column has been selected, additional editing options appear. On the one hand, the displayed value can be calculated using mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values). On the other hand, the type of instrument can also be changed, which adapts the visual display. A total of five different display modes are available: \u201cFull round disk\u201d, \u201cHalf round disk\u201d, \u201cLinear (vertical)\u201d, \u201cLinear (horizontal)\u201d and \u201cSphere\u201d.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_12.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nIf \u201cUser-defined\u201d is selected instead of \u201cAuto\u201d mode, the displayed interval [minimum value; maximum value] can be entered manually. In addition, you can also select \u201cColor\u201d instead of \u201cNo\u201d for the area type, whereupon different colors can be assigned to different, individually definable areas.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_13.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.5 Pivot table<\/h6>\n
Using a pivot table, data within a table can be grouped, totaled and displayed hierarchically depending on several arguments. A new pivot table can be drawn in the dashboard via the \u201cInsert cells\u201d tab and the \u201cPivot table\u201d selection field.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_14.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nAs soon as the placeholder for the new pivot table has been inserted, any number of data columns from the dictionary can be defined as columns and rows of the pivot table using drag & drop.<\/p>\n
Note: The hierarchical grouping of the columns and rows depends on the order entered.<\/em><\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_15.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nOnce all columns, rows and the value content (total) have been entered, additional settings can be made. With regard to the columns and rows, the \u201cTop N\u201d field can be used to specify whether the number of displayed elements should be limited to a certain value.<\/p>\n
With regard to the value content, you can determine how it is to be calculated. By clicking on the small triangle symbol, the expression can be extended by the corresponding mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values).<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_16.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.6 Indicator<\/h6>\n
Indicators make it possible to display a value. It is also possible to output the percentage deviation of this value from a specific target value. To be able to use an indicator, the \u201cIndicator\u201d field must be selected in the \u201cInsert cells\u201d tab and a corresponding position drawn in the dashboard.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_17.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nThe data column from the dictionary from which the indicator (value) is to be calculated can then be dragged and dropped into the element. Optionally, another data column can be added, from which the target value is derived.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_18.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nYou can then determine how the value of the indicator should be calculated. To edit the expression, simply click on the triangle symbol and select one of the available mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Number of all values; Median: Median of all values). In addition, you can also select a symbol and its color, which is displayed next to the indicator.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_19.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.7 History<\/h6>\n
A graph can be used to display a value in relation to a specific target value. To add a gradient to the dashboard, activate the \u201cGradient\u201d selection field in the \u201cInsert cells\u201d tab with a mouse click and then draw the desired position in the dashboard.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_20.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nAs soon as the element is in the dashboard, a data column from the dictionary can be set as the value and another data column as the target via drag & drop. If no target is specified, the progression is always 100% and therefore makes little sense. Instead, it is advisable to use an indicator at this point.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_21.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nOnce a data column has been selected for both the value and the target, you can then specify which mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values) are used to calculate the value and the target and in which mode the display should take place. A total of three modes are available for this, circle with centered percentage display, pie chart and data bar with percentage display.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_22.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.8 Map<\/h6>\n
Maps can be used to visualize values depending on a specific location. There are basically two different maps available for this purpose. You can use a schematic map of the region or an online map (Bing). To call up one of these two maps, select the \u201cMap\u201d field in the \u201cInsert cells\u201d tab with a mouse click and then select the corresponding map. The map can then be drawn in the dashboard.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_23.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nRegion map:<\/strong>
\nAfter the map has been inserted, it is advisable to first select a suitable map section (default: USA). You can then specify whether the values should be generated manually or on the basis of a data column in the dictionary. The prerequisite for the values to be displayed depending on a data column is that a column exists that corresponds to the correct English spelling of the respective country. <\/p>\nIf the Data column option is selected, at least one column with the \u201cKey\u201d (= name of the country in English) and another column with the value must be added via drag & drop. The expression for calculating the value can be calculated using the available mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values).<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_24.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nYou can then select one of the four map types, Individual (color assignment based on a data column), Group (color assignment grouped by a data column), Heatmap (color assignment depending on the height of the value), Heatmap with groups (color assignment depending on the height of the value and grouped by a data column), and decide whether the country names should be displayed in full length or abbreviated.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_25.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nOnline map:<\/strong>
\nOnce the placeholder for the online map has been inserted in the dashboard, it can be filled in two different ways. Either two data columns with the corresponding coordinates (one column with the longitude and another column with the latitude) are added via drag & drop or a single data column with a specific location (country name, zip code, …).<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_26.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nYou can then select the data column from the dictionary from which the value to be displayed for each location results. The triangle symbol can be used to edit the expression and thus start the calculation of the value using the available mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values).<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_27.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nIn contrast to a regional map, an online map offers additional editing options. These can be called up by clicking on the \u201cMore options\u201d button. The map can be customized using the four parameters \u201cPage view mode\u201d, \u201cType\u201d, \u201cCulture\u201d and \u201cColour\u201d.<\/p>\n
Page view mode<\/strong>: Definition of how the value is displayed. One of the four available modes, \u201cBubble\u201d (bubble size per location depending on the size of the value), \u201cValue\u201d (value as a simple number), \u201cSymbol\u201d (value as a simple number next to a self-defined symbol) and \u201cDiagram\u201d (display of the value depending on an argument in the form of a pie chart), can be selected.<\/p>\nType<\/strong>: Selection of the format (country name, zip code, …) of the selected data column for defining the location.<\/p>\nCulture<\/strong>: Determine in which language the countries\/regions should be displayed on the online map.<\/p>\nColor<\/strong>: Definition of the color highlighting of the individual countries. You can select the same color for all countries (Flat), a different color for each country (Color each), colors depending on a group affiliation (Group), or a specific color for each country using an additional data column (Value).<\/p>\n3.2.2.9 Image<\/h6>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_28.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nThere are then three options for filling the image field with a corresponding representation. A local image file can be integrated into the report using the folder icon. Instead, you can also display one of the available symbols with the selected color or enter a hyperlink.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_29.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nTo display a local image saved on the computer in the dashboard (e.g. company logo, background image, …), a corresponding image field must be inserted. To do this, activate the \u201cImage\u201d selection area in the \u201cInsert cells\u201d tab with a mouse click and then use the mouse to draw the positioning of the element in the dashboard.<\/p>\n
3.2.2.10 Text<\/h6>\n
To be able to insert a new text field, you must be in the \u201cInsert cells\u201d tab in the menu bar. As soon as the \u201cText\u201d button has been activated there, the placeholder for a new text field can be drawn in the dashboard.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_30.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nThe editing window for text entry then opens automatically. Any text can be entered here and formatted accordingly. In order for formatting changes to be applied to a text that has already been entered, the text must be selected.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_31.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.11 Global filters<\/h6>\n
Adding global filters makes it possible to limit all dashboard content to specific data. If the \u201cInsert cells\u201d tab is active in the ribbon, the desired filter can be selected by clicking on \u201cFilter\u201d and then drawn into the dashboard.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_32.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nYou can choose between a total of five different filter types, \u201cCombo box\u201d, \u201cDate field\u201d, \u201cList field\u201d, \u201cTree view field\u201d and \u201cTree view\u201d<\/p>\n
Combo box<\/strong>: Filter option with regard to an element. Filter must first be opened by clicking with the mouse.<\/p>\nList field<\/strong>: Filter option with regard to an element. Filter is already open in list view.<\/p>\nTree view field<\/strong>: Filter option for several elements that are hierarchically linked in a tree structure. Filter must first be opened by clicking with the mouse.<\/p>\nTree view<\/strong>: Filter option for several elements that are hierarchically linked in a tree structure. Filter is already open in list view.<\/p>\nDate field<\/strong>: Filter option with regard to a date field using a calendar.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_33.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nAs soon as a filter has been selected and a corresponding placeholder has been drawn in the dashboard, the data column from the dictionary that is to be used as a filter attribute can be added via drag & drop.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_34.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nAs soon as the desired data column has been added from the dictionary, further optional settings can be made for the filter. You can specify whether only a single or multiple selection is permitted for the filter (selection mode). If the \u201c(Show all) values\u201d checkbox is selected, the filter is given the value \u201c(All)\u201d if no other selection has been made. If more than one filter element is used, the filters can also be linked to each other, provided that one filter is selected as the parent element for the other. This ensures that only the selection options that match the filtering of the parent element are available for the child element.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_35.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.12 Predefined filters for individual elements<\/h6>\n
In some cases, it can be useful to filter a specific element in the dashboard to a limited amount of data in advance, but not to apply this filter globally to all elements (e.g. displaying an indicator with the number of all measures in arrears ? Filter: Measure in arrears). Such a filter function is available for each element and can be edited by clicking on the funnel symbol after activating the element.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_36.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nThe data column to which the filter condition is to be applied can then be dragged and dropped into the filter field.<\/p>\n
\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_37.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\nTo define a filter condition, a corresponding condition and the corresponding value must be selected. Only data that fulfills this filter condition is then taken into account in this diagram\/element.<\/p>\n
\n1 New display of ratings
\n<\/a><\/li>\n
\n2 Parallel processing of status steps
\n<\/a><\/li>\n
\n3 Images in activities
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n
\n<\/a><\/li>\n<\/ul>\n
1. Display MSO Dashboard<\/h3>\n
A dashboard created using the Report Designer can optionally be displayed in up to two different places: (1) Reports; (2) Dashboards;<\/p>\n
(1) If you select the \u201cReports\u201d option when creating your dashboard, the dashboard can be accessed and analyzed via the \u201cReports\u201d tab, just like all other reports.<\/p>\n
(2) If the \u201cDashboard\u201d usage is selected, the dashboard appears after calling up the \u201cDashboard\u201d tab. It is important to note that only one dashboard can be selected for this display. This means that the dashboard selected first is always visualized in the corresponding tab.<\/p>\n Note: If you open the \u201cDashboard\u201d tab although no dashboard\/report has been selected for use in the dashboard, the following message appears:<\/em><\/p>\n Note: If you cannot see the \u201cDashboard\u201d tab in your application, this function must still be activated for your application by MSO. Accordingly, please contact us directly.<\/em><\/p>\n MSO dashboards offer a wide range of functions and serve as the perfect BI tool for analyzing your data cubes. The respective functions are defined as part of the creation process (see chapter 3) and can therefore vary.<\/p>\n (1) A major advantage of MSO dashboards is that several diagrams can be displayed on one page and that clicking on a specific area in a diagram filters all other views to this area. If, for example, only complaints relating to the country Sweden are to be displayed in a complaints dashboard, the entire view can be filtered by clicking on the corresponding map section. (As an alternative to a filter function, links can also be opened by clicking on certain areas of the dashboard, allowing measures to be edited directly, for example).<\/p>\n (2) If a filter is set by clicking on an element of a diagram, it can be removed again by clicking on the filter symbol at the top of the respective diagram.<\/p>\n (3) In addition to the filter function, each individual diagram can also be re-sorted, displayed in full-screen mode and exported as a .pdf, image or Excel file.<\/p>\n (4) In addition to these functionalities per diagram, the dashboard can also be displayed as a whole in full-screen mode and exported as a .pdf, image or Excel file. The corresponding buttons are located above the dashboard. The dashboard data can also be updated at this point.<\/p>\n The creation of dashboards is very similar to the already familiar procedure for creating reports. The most important steps for creating a dashboard are described in the following chapters. For a comprehensive description of all functions, please refer to the report\/dashboard designer manufacturer’s manual: https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/index.html?dashboards.htm <\/a><\/p>\n (1) To create a new dashboard, first switch to the administration area and select the \u201cReports\u201d field in the \u201cOther settings\u201d section.<\/p>\n (2) Then click on \u201cNew report\u201d, whereupon the definition window for a new report or dashboard opens.<\/p>\n (3) Give your dashboard a name and specify where the dashboard should be displayed (see chapter 2) (1). After clicking on \u201cNext\u201d, you can determine which database fields you would like to use in your dashboard. In addition to a few general fields (ID, Title, Status, Responsible, Responsible, ….), it can also be useful to include categories, global fields and event-specific data (2). Once you have selected all the fields, you can confirm your entry by clicking \u201cNext\u201d. Before you can start with the actual creation of the report, you must finally specify whether you only want to use data from a specific event (filter function) and whether the data should already be sorted (sort function) (3). These two functions are optional. Click on \u201cSave\u201d to save all entries and the program automatically opens the report\/dashboard designer.<\/p>\n The user interface of the report\/dashboard designer can be divided into three sections: Menu (1), Properties (2), Page\/Dashboard(3).<\/p>\n (1) The menu consists of a total of six tabs, \u201cFile\u201d, \u201cHome\u201d, \u201cInsert cells\u201d, \u201cPage\u201d, \u201cLayout\u201d and \u201cPreview\u201d:<\/p>\n File:<\/strong> Save all changes, exit the Designer (back to the database) and call up the documentation.<\/p>\n Starting position<\/strong>: Editing of all texts and fields (font size, color, background, frame, … ? compare with Microsoft Word)<\/p>\n Insert cells<\/strong>: Add new dashboard elements (tables, charts, instruments, maps, text fields, images, indicators, filters).<\/p>\n Page<\/strong>: Definition of the page layout (between desktop and mobile application).<\/p>\n Layout<\/strong>: Editing the positioning of individual elements in relation to each other (\u201cIn the foreground\u201d; \u201cIn the background\u201d).<\/p>\n Preview<\/strong>: Preview of the created dashboard as it would be displayed in the database.<\/p>\n (2) The properties contain a total of three tabs, \u201cProperties\u201d, \u201cDictionary\u201d, \u201cReport tree\u201d:<\/p>\n Properties<\/strong>: Each inserted element (table, diagram, …) has different properties, such as the labeling of the x- and y-axis. These properties can be edited accordingly at this point.<\/p>\n Dictionary<\/strong>: Display of all data fields that have been transferred from the database to the reporting tool as well as a list of all newly calculated data columns or added data sources.<\/p>\n Report tree<\/strong>: Hierarchical display of all elements used in the report. Can be used for quick navigation as part of dashboard creation.<\/p>\n (3) The page represents the actual dashboard. All fields can be inserted here and positioned as desired (within the specified frame).<\/p>\n By clicking on the \u201cplus symbol\u201d, you can insert both a new report page and a new dashboard. To add a new dashboard, please click on \u201cNew dashboard\u201d.<\/p>\n Note: To display only the dashboard, the page that already exists by default (Page1) must be removed. This can be done by right-clicking on the \u201cPage1\u201d tab as soon as the new dashboard has been inserted.<\/em><\/p>\n Various elements can be added to the dashboard using the \u201cInsert cells\u201d tab To insert a new table, the \u201cTable\u201d button must first be activated. The desired position of the table can then be drawn in the dashboard.<\/p>\n To display the desired data in the table, any elements of the dictionary can be added as columns. A new column is added to the \u201cTable\u201d field using drag & drop.<\/p>\n As soon as all the desired columns have been added, they can be edited further. For each column, you can specify whether it is to be displayed as a simple dimension, measure, bar, color scale, indicator or chart. In addition, you can also decide whether the table should have a result row and how this result is calculated (Sum: sum of all values; Min: smallest value; Max: largest value; Count: Number of all values; Average: Average value). Finally, the interaction can be used to define what happens when a corresponding cell in the table is clicked.<\/p>\n To be able to insert a new diagram, you must be in the \u201cInsert cells\u201d tab in the menu bar. As soon as the \u201cDiagram\u201d button has been activated there, the placeholder for a new diagram can be drawn in the dashboard.<\/p>\n Data fields from the dictionary can then be dragged and dropped into the diagram. The default chart is a bar chart. Data columns that are dragged into the \u201cValue\u201d field therefore correspond to the y-value and data columns that are dragged into the \u201cArgument\u201d field correspond to the x-value of a classic diagram.<\/p>\n As soon as a data column has been defined as a value and this value has been selected with a mouse click, the chart type can be selected. A variety of common diagrams are available here: Column diagram; Line diagram; Area diagram; Range diagram; Bar diagram; Scatter plot; Pie chart; Network diagram; Funnel diagram; Financial diagram; Gantt diagram; Ring diagram; Bubble diagram; Sunburst diagram; TreeMap; Pictorial representation; Waterfall diagram<\/p>\n Regardless of the type of diagram, you can specify for each value how it should be calculated depending on the argument. To do this, the corresponding value must first be selected with a mouse click. The expression can then be edited and all available mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values) are displayed. Click on the desired operator to customize the printout and the graphical output.<\/p>\n A new instrument is inserted via the \u201cInsert cells\u201d tab. As soon as the tab is selected and the \u201cInstrument\u201d field has been activated with a mouse click, a new instrument can be added to the dashboard.<\/p>\n The placeholder can then be filled with any column of the dictionary using drag & drop.<\/p>\n As soon as a data column has been selected, additional editing options appear. On the one hand, the displayed value can be calculated using mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values). On the other hand, the type of instrument can also be changed, which adapts the visual display. A total of five different display modes are available: \u201cFull round disk\u201d, \u201cHalf round disk\u201d, \u201cLinear (vertical)\u201d, \u201cLinear (horizontal)\u201d and \u201cSphere\u201d.<\/p>\n If \u201cUser-defined\u201d is selected instead of \u201cAuto\u201d mode, the displayed interval [minimum value; maximum value] can be entered manually. In addition, you can also select \u201cColor\u201d instead of \u201cNo\u201d for the area type, whereupon different colors can be assigned to different, individually definable areas.<\/p>\n Using a pivot table, data within a table can be grouped, totaled and displayed hierarchically depending on several arguments. A new pivot table can be drawn in the dashboard via the \u201cInsert cells\u201d tab and the \u201cPivot table\u201d selection field.<\/p>\n As soon as the placeholder for the new pivot table has been inserted, any number of data columns from the dictionary can be defined as columns and rows of the pivot table using drag & drop.<\/p>\n Note: The hierarchical grouping of the columns and rows depends on the order entered.<\/em><\/p>\n Once all columns, rows and the value content (total) have been entered, additional settings can be made. With regard to the columns and rows, the \u201cTop N\u201d field can be used to specify whether the number of displayed elements should be limited to a certain value.<\/p>\n With regard to the value content, you can determine how it is to be calculated. By clicking on the small triangle symbol, the expression can be extended by the corresponding mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values).<\/p>\n Indicators make it possible to display a value. It is also possible to output the percentage deviation of this value from a specific target value. To be able to use an indicator, the \u201cIndicator\u201d field must be selected in the \u201cInsert cells\u201d tab and a corresponding position drawn in the dashboard.<\/p>\n The data column from the dictionary from which the indicator (value) is to be calculated can then be dragged and dropped into the element. Optionally, another data column can be added, from which the target value is derived.<\/p>\n You can then determine how the value of the indicator should be calculated. To edit the expression, simply click on the triangle symbol and select one of the available mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Number of all values; Median: Median of all values). In addition, you can also select a symbol and its color, which is displayed next to the indicator.<\/p>\n A graph can be used to display a value in relation to a specific target value. To add a gradient to the dashboard, activate the \u201cGradient\u201d selection field in the \u201cInsert cells\u201d tab with a mouse click and then draw the desired position in the dashboard.<\/p>\n As soon as the element is in the dashboard, a data column from the dictionary can be set as the value and another data column as the target via drag & drop. If no target is specified, the progression is always 100% and therefore makes little sense. Instead, it is advisable to use an indicator at this point.<\/p>\n Once a data column has been selected for both the value and the target, you can then specify which mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values) are used to calculate the value and the target and in which mode the display should take place. A total of three modes are available for this, circle with centered percentage display, pie chart and data bar with percentage display.<\/p>\n Maps can be used to visualize values depending on a specific location. There are basically two different maps available for this purpose. You can use a schematic map of the region or an online map (Bing). To call up one of these two maps, select the \u201cMap\u201d field in the \u201cInsert cells\u201d tab with a mouse click and then select the corresponding map. The map can then be drawn in the dashboard.<\/p>\n Region map:<\/strong> If the Data column option is selected, at least one column with the \u201cKey\u201d (= name of the country in English) and another column with the value must be added via drag & drop. The expression for calculating the value can be calculated using the available mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values).<\/p>\n You can then select one of the four map types, Individual (color assignment based on a data column), Group (color assignment grouped by a data column), Heatmap (color assignment depending on the height of the value), Heatmap with groups (color assignment depending on the height of the value and grouped by a data column), and decide whether the country names should be displayed in full length or abbreviated.<\/p>\n Online map:<\/strong> You can then select the data column from the dictionary from which the value to be displayed for each location results. The triangle symbol can be used to edit the expression and thus start the calculation of the value using the available mathematical operators (Sum: sum of all values; Avg: average value; Min: smallest value; Max: largest value; DistinctCount: Number of all unequal values; Count: Count: number of all values; Median: median of all values).<\/p>\n In contrast to a regional map, an online map offers additional editing options. These can be called up by clicking on the \u201cMore options\u201d button. The map can be customized using the four parameters \u201cPage view mode\u201d, \u201cType\u201d, \u201cCulture\u201d and \u201cColour\u201d.<\/p>\n Page view mode<\/strong>: Definition of how the value is displayed. One of the four available modes, \u201cBubble\u201d (bubble size per location depending on the size of the value), \u201cValue\u201d (value as a simple number), \u201cSymbol\u201d (value as a simple number next to a self-defined symbol) and \u201cDiagram\u201d (display of the value depending on an argument in the form of a pie chart), can be selected.<\/p>\n Type<\/strong>: Selection of the format (country name, zip code, …) of the selected data column for defining the location.<\/p>\n Culture<\/strong>: Determine in which language the countries\/regions should be displayed on the online map.<\/p>\n Color<\/strong>: Definition of the color highlighting of the individual countries. You can select the same color for all countries (Flat), a different color for each country (Color each), colors depending on a group affiliation (Group), or a specific color for each country using an additional data column (Value).<\/p>\n There are then three options for filling the image field with a corresponding representation. A local image file can be integrated into the report using the folder icon. Instead, you can also display one of the available symbols with the selected color or enter a hyperlink.<\/p>\n To display a local image saved on the computer in the dashboard (e.g. company logo, background image, …), a corresponding image field must be inserted. To do this, activate the \u201cImage\u201d selection area in the \u201cInsert cells\u201d tab with a mouse click and then use the mouse to draw the positioning of the element in the dashboard.<\/p>\n To be able to insert a new text field, you must be in the \u201cInsert cells\u201d tab in the menu bar. As soon as the \u201cText\u201d button has been activated there, the placeholder for a new text field can be drawn in the dashboard.<\/p>\n The editing window for text entry then opens automatically. Any text can be entered here and formatted accordingly. In order for formatting changes to be applied to a text that has already been entered, the text must be selected.<\/p>\n Adding global filters makes it possible to limit all dashboard content to specific data. If the \u201cInsert cells\u201d tab is active in the ribbon, the desired filter can be selected by clicking on \u201cFilter\u201d and then drawn into the dashboard.<\/p>\n You can choose between a total of five different filter types, \u201cCombo box\u201d, \u201cDate field\u201d, \u201cList field\u201d, \u201cTree view field\u201d and \u201cTree view\u201d<\/p>\n Combo box<\/strong>: Filter option with regard to an element. Filter must first be opened by clicking with the mouse.<\/p>\n List field<\/strong>: Filter option with regard to an element. Filter is already open in list view.<\/p>\n Tree view field<\/strong>: Filter option for several elements that are hierarchically linked in a tree structure. Filter must first be opened by clicking with the mouse.<\/p>\n Tree view<\/strong>: Filter option for several elements that are hierarchically linked in a tree structure. Filter is already open in list view.<\/p>\n Date field<\/strong>: Filter option with regard to a date field using a calendar.<\/p>\n As soon as a filter has been selected and a corresponding placeholder has been drawn in the dashboard, the data column from the dictionary that is to be used as a filter attribute can be added via drag & drop.<\/p>\n As soon as the desired data column has been added from the dictionary, further optional settings can be made for the filter. You can specify whether only a single or multiple selection is permitted for the filter (selection mode). If the \u201c(Show all) values\u201d checkbox is selected, the filter is given the value \u201c(All)\u201d if no other selection has been made. If more than one filter element is used, the filters can also be linked to each other, provided that one filter is selected as the parent element for the other. This ensures that only the selection options that match the filtering of the parent element are available for the child element.<\/p>\n In some cases, it can be useful to filter a specific element in the dashboard to a limited amount of data in advance, but not to apply this filter globally to all elements (e.g. displaying an indicator with the number of all measures in arrears ? Filter: Measure in arrears). Such a filter function is available for each element and can be edited by clicking on the funnel symbol after activating the element.<\/p>\n The data column to which the filter condition is to be applied can then be dragged and dropped into the filter field.<\/p>\n To define a filter condition, a corresponding condition and the corresponding value must be selected. Only data that fulfills this filter condition is then taken into account in this diagram\/element.<\/p>\n
\n\t\t\t\t\t\t\t\t<\/a>
\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a>
\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n2. Use MSO Dashboard<\/h3>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3. Create MSO dashboard<\/h3>\n
3.1 Definition of a new dashboard<\/h4>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2 Dashboard Designer<\/h4>\n
3.2.1 General<\/h5>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2 Design dashboard<\/h5>\n
3.2.2.1 Creating a new dashboard<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.2 Table<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.3 Diagrams<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.4 Instruments<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.5 Pivot table<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.6 Indicator<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.7 History<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.8 Map<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\nAfter the map has been inserted, it is advisable to first select a suitable map section (default: USA). You can then specify whether the values should be generated manually or on the basis of a data column in the dictionary. The prerequisite for the values to be displayed depending on a data column is that a column exists that corresponds to the correct English spelling of the respective country. <\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\nOnce the placeholder for the online map has been inserted in the dashboard, it can be filled in two different ways. Either two data columns with the corresponding coordinates (one column with the longitude and another column with the latitude) are added via drag & drop or a single data column with a specific location (country name, zip code, …).<\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.9 Image<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.10 Text<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.11 Global filters<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n3.2.2.12 Predefined filters for individual elements<\/h6>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
\n\t\t\t\t\t\t\t\t<\/a><\/p>\n
![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_38.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_39.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n![\"\"](\"https:\/\/staging.mso.de\/wp-content\/uploads\/2020\/10\/MSO_Dashboard-Designer_40.png\")
\t\t\t\t\t\t\t\t<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"