With the metric widget, you can display content from one or more cells in a sheet.
USM Content
Add a metric widget
To add a metric widget:
- Open a dashboard you want to edit.
- On the top bar, select Edit Dashboard.
- On the top bar, select +Add Widget. The Add Widget panel appears.
- Select the Metric widget. The widget configuration options appear in the right side panel.
- Select Add Data.
- Choose the sheet and cells containing the data you want to display.
Select either Grid data or Sheet Summary data as the data source:
If you chose Grid data, select the cells you would like to display in the metric widget and select OK.
If you selected Sheet Summary data, check the boxes of the sheet summary fields you would like to display and select OK.
If you want to display the data in a grid format, you need to first create a report and use the Report widget type.
If you want to display new fields as they’re added to or deleted from the source sheet, then you need to manually add or remove them from the metric widget as well.
Configure the appearance
Use steps in the following table to configure the widget's appearance.
| To do this | Follow these steps |
|---|---|
| Change the alignment of the data in the widget | In the widget properties panel, select either Stacked or Side-by-Side. |
| Change font formatting | Click the cursor on the item you want to change, then use the popup formatting menu to change your text. |
| Add a title to the widget | Under the Title section of the configurator, toggle Show title on. |
| Adjust the formatting for each field in the widget | To do this, click the field directly within the widget and then choose from the available formatting options on the toolbar. |
| Enable the formatting from the underlying sheet to show in a field | Click on the field and then select Use Cell Formatting: |
| Edit the interaction of the widget (interaction is what happens when you click the widget) | While editing the widget, navigate to Widget Behavior in the configurator and choose an option from the When someone clicks this widget list of options:
|