Adding text to a dashboard

Once you have created a dashboard, you can add text to the dashboard. Text can serve as a label for your data or provide background information, a description, or instructions for the dashboard. You can reposition, resize, and format the text. In the example below, the text at the top of the dashboard provides tips for using the grid. The text has been formatted to display in a smaller font.

Text displaying tips for using the grid

You can type the text to display, as in the example above, or you can drag and drop a dataset object into the text field. When you use a dataset object, the text automatically changes depending on what is displayed in the dashboard (also known as dynamic text). You can combine both text and dataset objects in the same text field.

For example, you can use a combination of text and a dataset object as a title. Your dashboard, which is filtered on the Region attribute, contains a visualization that displays metric values for your regions. Add a text field, type “Revenue and Profit Data for ” (note the extra space) in the text field, and then drag and drop the Region attribute into it. When you select the Northeast region in the Filter panel, the text field displays “Revenue and Profit Data for Northeast”, and the visualization displays metric values for the Northeast region only. If you select another region in the Filter panel, both the text field and the visualization automatically change.

For steps to add text, see Adding and formatting text.

Displaying the results of a derived metric in a text field

You can use a text field to create a list of all the elements for an attribute. An attribute element is a value of an attribute. For example, North is an element of the Region attribute.

To do this, create a derived metric with the definition ConcatAgg(Attribute@form), replacingAttributewith the name of the attribute. (An attribute form is additional descriptive information about an attribute. For example, the attribute Customer has the forms First Name, Last Name, Address, Email Address, and so on.) Drag the derived metric into the text field. The attribute elements are displayed as a comma-separated list, such as North, South, East, West. For steps to create a derived metric, see Creating a metric based on existing objects: Derived metrics.

Creating a dynamic metric using a text field

You can create a metric by typing a function directly in the text field. For example, you can type {Revenue-Cost}, where Revenue and Cost are both metrics, in the text field. The text will display as a single value.

Combining text and dataset objects in a text field

In the following example, text and dataset objects are combined. The words Cost = Revenue - Profit = are text that was typed in, while {REVENUE} and {COST} are the metrics displayed in the grid. A metric was created with the formula {REVENUE - COST}. The dollar sign in front of the created metric was typed, because the Revenue and Cost metrics are formatted in the dashboard, but the created metric needs the currency formatting.

Text field containing a dynamic metric

The Revenue and Cost metrics are each displayed as a single value, as shown below. They show the total of all the Revenue values and Profit values, as shown in the totals in the grid. The metric that is created is also calculated at the grand total level.

Text field with data

Displaying dashboard information using a text field

You can display dashboard information, such as the dashboard name and description, or the current date and time in a text field. The available codes are described in the following table. Be sure to include the braces ({ }) when you type the code in the text field.

Description Code Sample Display
Date & Time Current date and time, of the client computer {&DATETIME} 11/15/2003 7:10:55 PM
Current user The full name, not the login, of the user who views the dashboard {&USER} Jane User
Dashboard name {&DOCUMENT} Regional Sales Summary
Dashboard description {&DESCRIPTION} Revenue and profit by region
Project name {&PROJECT} MicroStrategy Tutorial
Dashboard execution time {&EXECUTIONTIME} 11/15/2003 7:11:15 PM

For example, you add the {&DOCUMENT} code to a text field in a dashboard named Regional and Category Data, as shown below:

Text field displaying {&DOCUMENT} code

The dashboard name is displayed, as shown below:

Regional and Category Data text field

Adding and formatting text

Follow the steps below to add and format, edit, delete, or move and resize a text field in a dashboard.

Prerequisite

You must have the Web Edit Dashboard and Web Run Dashboard privileges.

To add text

1 From the dashboard's toolbar, click the Insert icon Insert icon, then click Text. A text field is added to the dashboard and displayed.
2 Add the text to display, as described below. You can combine both text and dataset objects in the same text field. For an example, see Combining text and dataset objects in a text field.
To add text, in the field, type the text to display, and then press ENTER. For an example, see Adding text to a dashboard.
To add a dataset object, drag and drop the object from the Datasets panel into the text field. For an example, see Combining text and dataset objects in a text field.
To display dashboard information, type the code into the text field. For a list of the available codes, and an example, see Displaying dashboard information using a text field.

To format the text

3 If the text contains numeric data, you can format the numbers, as described below:
a Hover the cursor over the text field, then click the arrow icon displayed to the right, and select Number Format.
b From the drop-down list, select the type of number formatting to use to display numeric values.
c Select the appropriate format options, such as the separator symbol, currency symbol, and number of decimal places.
d Click OK to save the number formatting.
4 You can select formatting options for the text, such as font color, background color, or whether to bold or italicize text, using the Properties panel. For detailed information on each of the text formatting options, see Dashboard Editor: Text: Properties.
If the Properties panel is not displayed, from the View menu, select Properties Panel. If the Properties panel is hidden behind another panel, click the Properties icon Properties icon to display the Properties panel.

To edit, move, resize, or delete a text field

1 To edit a text field, click the text to edit, then type the new text to display.
2 To move a text field, click and drag the text field, so that a blue indicator line is displayed in the location to move the text field to. The text field is moved and displayed in its new location.
3 To resize a text field, hover the cursor over the edge of the text field to size. Click and drag the edge to change the size of the text field.
4 To delete a text field, hover the cursor over the text to delete and click the arrow icon, then select Delete. The text is deleted from the dashboard.

Related topics

Adding images to a dashboard
Adding an HTML container to a dashboard