1. Dashboards and Visualization
  2. Dashboards
  3. Design Dashboards
  4. Ways to Refresh a Dashboard

The Refresh button, on the dashboard toolbar, initiates a round trip to the server to bring the latest data back to the dashboard. A dashboard will automatically refresh when a process is run or an item is added to a numbered list.

There are other ways to refresh a dashboard. The methods described in this topic provide some alternative options for refreshing a dashboard.

The ways in which these alternative methods are implemented will depend on:

  • the kind of data you’re dealing with;
  • the situation in which the dashboard is being used; and
  • how the target user will interact with the dashboard.

Synchronization

If Synchronize Selection is enabled for dashboard elements that share a dimension, when you click a dimension in one of those elements, the entire dashboard refreshes.

This is useful in a context where you click on one element to drive another, such as drilling into a hierarchy. The refresh triggered in this method is implicit — there is no obvious refresh option on the dashboard — a refresh is initiated by clicking on a shared dimension in either dashboard element.

This method requires that the dimension the two elements have in common is on either a row or column.

  1. Choose the data that you want to publish as an element on a dashboard.
  2. From the View menu, select the relevant Publish … to Dashboard command and choose a dashboard. The menu option you choose will depend on the kind of data you’ve chosen to publish.
  3. Apply Synchronize Selection to the new dashboard element.
  4. Choose further data, perhaps from a different module, that contains a dimension shared with the data in the first dashboard element.
  5. From the View menu, select the relevant Publish … to Dashboard command and publish to the dashboard selected in step 2.
  6. Apply Synchronize Selection to the dashboard element.
  7. Arrange the dashboard elements on the dashboard in Dashboard Designer.
  8. Click the Save and Exit button on the dashboard toolbar.

Use a line item as a ‘button’

This is a variation of the previous method. However the detail of the second dashboard element is hidden, leaving a single line item that works as a ‘button’ to refresh the entire dashboard.

This is more useful where users require an explicit refresh option on the dashboard itself.

  1. Choose the data that you want to publish as an element on a dashboard.
  2. From the View menu, select the relevant Publish … to Dashboard command, and choose a dashboard.
    The menu option you choose will depend on the kind of data you have chosen to publish.
  3. Apply Synchronize Selection to the dashboard element.
  4. Choose further data, perhaps from a different module, that contains a dimension shared with the data in the first dashboard element. (Another approach is to add a new line item and name it with the label of the button, for example, Refresh Dashboard.)
  5. Pivot the data to put line items on columns.
  6. Hide all rows and columns, except the name of the line item shared with the data in the first dashboard element.
  7. In Column Settings, set the Width for Row Labels to 6 pixels and the width of the remaining line item to a value that accommodates all the characters in the name.
    You will now have a single field, with the name of the line item emboldened.

  8. From the View menu, select the relevant Publish … to Dashboard command, and publish to the dashboard selected in step 2.
  9. Apply Synchronize Selection to the dashboard element and deselect Show Module name, Show Label, and Show Page Selector.
  10. Arrange the dashboard elements on the dashboard in Dashboard Designer and select Save and Exit from the dashboard toolbar.
    Click on the ‘button’ (line item) to refresh the dashboard.