Create a Custom Dashboard

Purpose: To show you how you can add data visualizations to a custom dashboard and utilize its features.

Please review our help guide about creating workbooks (data visualizations) before converting them to a custom dashboard.


Overview

Converting workbooks (presented as data visualizations) to custom dashboards allows for a more dynamic and interactive presentation of data by displaying multiple analyses. Within a published dashboard, users can apply interactive filters and view comprehensive data at a glance. More information about dashboard settings are detailed below.

Once you finish creating data visualizations, click +Dashboard in the top right corner and then enter a name for the custom dashboard. Select in which folder it should be located. Organizing each workbook into a cohesive and unified dashboard helps facilitate easier data interpretation and decision-making.


Dashboard setup

Add filters

Dashboards have filter capabilities, allowing you to refine and customize data visualizations by selecting a specific criteria. Once you save a filter to an existing dashboard, users with the correct permissions will be able to access the filter(s) when viewing the published dashboard.

When in the edit version of a custom dashboard, simply click Add filter within the dashboard to get started.

Clicking Add filter will bring up a list of fields populated from a dataset (e.g., employee compensation). From the left sidebar menu, determine which fields you want to apply as filters to the workbooks. By default, the filter will be automatically applied to all visualizations that pertain to the selected dataset, but you can choose to remove the filter from certain visualizations.

Data visualizations with a filter will be highlighted in blue. To add or remove a filter, simply click on the blue icon in the top right corner of the visualization.

In the example above, I added the Job Employee Type field as a filter. Each filter has additional settings:

  1. Label: Name the filter how you want it to appear in the dashboard.
  2. Description: A description will appear as an informational tooltip when you hover your cursor over the filter. This is optional.
  3. Filter control: There are two filter control types—advanced and single value dropdown. Advanced allows users to select multiple options while single value only allows the user to select one option.
  4. *Default value: This option allows you to select a default filter, along with preset conditions, that will be automatically applied to all relevant visualizations within the published dashboard. In the example above, I selected the employment type of "Full-Time," which means the published dashboard will only show data that pertains to full-time employees. *You can leave this setting as "is any value" if you prefer users to apply any filters.
  5. **Hide this filter: Use this option if you do not want users to access the filter from the published dashboard. The value will still be applied in the background but remains hidden from the user.
  6. Delete filter: Use this option if you would like to delete the filter.

*Setting the default value to "matches user attribute" will automatically personalize dashboard views. For example, a sales dashboard can dynamically filter data to show each account executive only their own deals.

**Hiding dashboard filters will not restrict access to sensitive data. Instead, we recommend using access level settings to determine who should and should not have access to data in your company's dashboards.

Add controls

The controls feature enable users to switch fields within a data visualization. To add a control, click Add control and select which visualizations it should apply to by toggling the option in the top right corner of the visualization. The following are four main types of controls:

  1. Field switcher: Enables swapping between one dimensions or measure, like changing from country to city.
  2. Multi-field switcher: Enables swapping between multiple dimensions or measures, like changing between employee compensation metrics such as base salary and total benefits, or switching between different stages of the hiring process, such as candidates interviewed and candidates hired.
  3. Time frame switcher: Allow users to easily switch the time frame of the underlying data, such as moving from daily to weekly views.
  4. Period over period: Facilitates the comparison of two time periods, letting users select and compare different time dimensions directly from the dashboard.

At least one of the fields being controlled must be present in the data visualization for the control to have an effect.

Example

In the example above, I used the field switcher to adjust data visualizations between the Average Candidates and Hiring Positions Count fields.

Add text tile

Using the Add text tile option, you can use markdown to add text, images, links, and more.

Auto-refresh data

Data in a dashboard can be automatically refreshed for real-time updates. (The auto-refresh and facet filters options are turned off by default.) To enable the auto-refresh functionality, click the Edit dropdown menu > Dashboard settings > toggle on Auto-refresh. Then, determine the auto-refresh timeframe and click Update settings to finalize changes.

Facet filters: If enabled, one filter will refine the results of another filter across workbooks within a dashboard. For example, selecting a division filter will narrow down the department options to only departments within the selected division.