The Dundas BI dashboard editor is displayed when you create a new dashboard from the main menu or from the home screen. The editors for reports and scorecards include the same features plus some additional elements specific to those views, and several elements and windows are common to other editors.
Elements of the editor include the toolbar at the top, a status bar along the bottom, and the actual design surface with horizontal and vertical rulers. The white, rectangular portion of the design surface represents your dashboard and is generally referred to as the canvas.
You design dashboards and other views simply by dragging items from the Explore window on the right, and placing them on the canvas. For example, drag a metric set to the canvas and it will automatically appear as a chart or other type of visualization showing actual data values. Or, add a label component to the canvas and use the Properties popup or window to change its font size and color.
Related video: Introducing the Dashboard Designer
Here's a quick tour of the main elements of the user interface (UI) for editing views.
The toolbar at the top of the screen lets you perform a wide range of design functions. You can copy and paste items from the clipboard, add different types of content to the canvas, or apply a style or theme. Essential operations such as switching to view mode are always visible in the toolbar while the remaining buttons may be scrolled left or right depending on the available space.
Certain operations appear or disappear from the toolbar according to the current selection. For example, if you select a data visualization on the canvas, you'll see a set of toolbar buttons on the right with a blue edge on top. These buttons correspond to operations that apply to the selected data visualization, such as Re-Visualize.
The status bar (also known as a taskbar) displays the name of the current dashboard or view, and lets you rename it as well. Hover over or long-tap the name to see its location, including its project and any subfolders.
Next to the name is a message area that informs you whenever your editing has been auto-saved. Further to the right, you'll find a set of controls for adjusting the zoom level and snap-to-grid options for the canvas.
See Using the status bar to learn more.
The horizontal and vertical rulers which are attached to the design surface help you to size and position elements on the canvas. The default units are pixels (px), with the top-left corner of the canvas corresponding to the position (x=0, y=0). The rulers also track the location of your mouse pointer as you move it across the design surface.
To switch the rulers to percent units, click px. In this mode, the bottom-right corner of the canvas corresponds to the position (x=100%, y=100%).
The canvas is the rectangular portion of the design surface that corresponds to the dashboard (or other view) that you are editing. When you click outside of any content, the toolbar presents options that are applicable to the view itself and the Properties window displays its properties such as Re-Size Mode and Height.
As you drag content around the canvas, a snap grid appears along with dotted lines that make it easy to align it with other elements on the dashboard.
Right-click (or long-tap) over an element on the canvas to open a context menu which gives you convenient access to many of the same functions available from the toolbar.
A set of tabbed windows are docked along the bottom and right sides of the editor. By default, the windows docked on the bottom are collapsed (e.g., the Parameters window), while the ones docked on the right are expanded (e.g., the Explore window). To learn how to work with and arrange these windows, see Using dockable windows.
All of the work that you do in Dundas BI occurs within the context of a current project, which allows users to collaborate on the same dashboard or BI effort. The Explore window lets you navigate this current project, which appears as a collection of folders containing files such as data connectors, metric sets, and dashboards. Almost anything can be dragged directly onto the canvas to add it to your view, including all types of data, metric sets, maps, themes, and even other dashboards or views.
Using the Explore window, you can easily switch between different kinds of tasks, from editing dashboards to creating data cubes and more. For example, right-click (or long-tap) on the Metric Sets folder and select New Metric Set to edit a metric set full-screen. Or, click New Folder to create a sub-folder to better organize your project items.
Enter search terms in the Explore search box to quickly find the files you want.
The toolbar at the top of the Explore window lets you enable checkboxes on project items and apply operations such as check in and check out on multiple files at once. The Explore toolbar is also responsive to the current selection in the treeview and presents similar options to that of the context menu.
Layers give you a way to organize elements on your dashboard as a collective unit, which you can then show or hide either when editing or set up to be shown or hidden while viewing. One reason for separating elements into different layers is when you have a complex dashboard with overlapping elements. As you're designing, you can hide layers that are completed and show just the layers you are actively working on. Layers can also be locked to prevent accidental modification (e.g., moving a chart out of position by mistake).
The Layers window lets you choose the active layer, add new layers, and show or hide each layer independently. See Layers and groups to learn more.
Properties are settings you can customize for visualizations, components, or parts of a view such as the dashboard's canvas.
Some of the most common properties can be accessed from the Quick Access Properties panel that appears when selecting any element on the canvas or the canvas itself. All user types can access these properties when editing, which can include various font settings, fill color, and border/outline styling.
The first time a visualization is selected, the Quick Access Properties lists properties that apply to the whole visualization, such as the overall font and outer border.
Many visualizations contain various elements within them that each have their own settings. Click again on an individual element within it if you want to customize it, such as a cell in a table, a chart axis and its labels, or a chart axis tick mark. The Quick Access Properties will update to show the settings that currently apply to that particular element if available.
The Properties window is available to users with at least a power user seat type, and lets you view and change the complete set of properties available for the selected element. If no element is selected (e.g., you clicked on the canvas outside of any content), the Properties window shows the properties of your dashboard or whichever type of view you are editing.
The Properties window is normally docked to the side, but you can also right-click (or long-tap) and choose Properties to open it. Similar to the Quick Access Properties, after first selecting a visualization, you can click or right-click a particular element within the visualization to select it and open the relevant subset of properties.
The Properties window also gives you access to the complete set of actions lists supported by that element, allowing you to add actions to customize behavior when an event occurs while viewing. See Using interactions for more.
View parameters pass a filter value to one or more metric sets and data visualizations. These are used to connect filters with your visualizations to pass them your selected filter values, or they can be created on their own without a filter control. Open the Parameters window to view and manage the parameters defined on your dashboard or other view.
Visualizations can also act as filters, so that you can click directly on data to filter, drill down, navigate to details and more. See Using interactions for the types of interactions that are available.
The Brush View Parameter that appears by default in the Parameters window is used for data brushing, which is a built-in feature that allows you to select or hover over data in one visualization and have it automatically selected in another. The brush view parameter facilitates communication between different data visualizations on the dashboard, indicating the data item based on its measure and hierarchy values, and highlighting all the matching data items.
You can open the Properties window for the dashboard to change the view parameter used for data brushing or disable automatic brushing.
With automatic brushing disabled, you can set up your own custom brushing or selection behavior by setting up a filter interaction with the Brush View Parameter as the target parameter.
Select a data visualization on the canvas if you are editing a dashboard or view, and then open the Data Preview window to see the underlying data values displayed in a table. Note that the displayed preview may differ from the resulting data visualization, for example totals are normally hidden in charts.
Hover over a table cell, or click to select a row or column in the Data Preview window, and corresponding data will be highlighted in your own visualizations. This is an example of the automatic data brushing in Dundas BI.
Clicking to select rows or columns will also display corresponding statistics in the status bar.
The Data Preview window also lets you view performance measurements and warning messages related to data retrieval for the selected data visualization on the canvas.
3. Data Analysis Panel
For every data visualization, there is a corresponding metric set that encapsulates the data that is being visualized, and settings that determine what each part of the data is used for by the current visualization.
Modifying all data-related settings is done using the Data Analysis Panel. Contrast this with the Properties window, which you use for customizing the specific visualization such as its appearance, animation, and interactivity.
If the metric set is checked out to you, you can directly add or remove measures and hierarchies from the Data Analysis Panel. Use the buttons at the top of the Data Analysis Panel to make other changes to the metric set (including overrides) or the visualization.
4. See also
- Video: Introducing the Dashboard Designer
- Using the home screen
- Working with projects
- Using the status bar
- Edit versus view mode and sandbox view
- Using dockable windows
- Using a template grid for resizing
- Using interactions
- List of keyboard shortcuts
- Script Library
- Filter child dashboards from a parent dashboard