With the metric widget, you can display content from one or more cells in a sheet.
After selecting the metric widget type, select Add Data to choose the sheet and cells containing the data you'd like to display.
You have the option of selecting 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.
Once you've chosen the data to display, use the following steps to make the widget look the way you want.
| 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:
|
