Displaying PowerMetrics on a dashboard

Dashboards are used to display a set of related PowerMetrics. Dashboards are highly flexible, empowering you to create unique displays tailored to your specific needs and audience. This flexibility enables you to mold your data to effectively inform others and illustrate progress toward your business goals. A diverse set of editing options means you can individualize each dashboard display.

When interacting with a dashboard, available options depend on whether you are in View mode or Edit mode.

The article includes the following:

Finding your dashboards

The Dashboards page displays a list of all of your dashboards.

To open the Dashboards page:

  • In the left navigation sidebar, click Dashboards.

From here you can share and delete existing dashboards or add new dashboards. You can also search for a dashboard (based on its name or its owner’s name) and filter to find either all of the dashboards or only the ones you created.

Note: If you’re doing a string-based search (more than 1 word, separated by spaces) enclose your string in quotes (“ “). Otherwise, your search will filter based on each individual word you enter in your string.

The following details display in your Dashboards page:

  • The dashboard name
  • The dashboard owner
  • When the dashboard was created and when it was last modified (updated)

Selecting a dashboard from this list opens it and adds it to your list of dashboards (for quick access) in the left navigation sidebar. Your 5 most recently opened dashboards display there, in alphabetical order.

Adding and deleting a dashboard

To add a dashboard:

  1. In the left navigation sidebar, click the + beside Dashboards and enter a name for the dashboard by either selecting the text in the title text field or by entering a name in the properties panel under Dashboard Name.
  2. Click Save.

Note: You can also add a dashboard from your Dashboards page, which opens when you click Dashboards in the left navigation sidebar.

To delete a dashboard:

  1. In the left navigation sidebar, under Dashboards, select the dashboard you want to delete.
  2. Click the 3-dot menu in the upper-right corner of the dashboard and click Delete.

Note: You can also delete a dashboard from your Dashboards page, which opens when you click Dashboards in the left navigation sidebar. From here you can delete individual dashboards or select multiple dashboards to delete them all at once.

View mode

View mode enables you to set personal options for your dashboard. The customizations you make while in View mode persist locally and are only visible to you. To make permanent changes to a PowerMetric on your dashboard, you need to be in Edit mode. The changes you make in Edit mode are visible to you and others.

When in View mode, you can:

  • Select the date range and dimensions by which to filter all PowerMetrics on the dashboard (by selecting an option from the drop-down list and calendar at the top of the dashboard).
  • Share the dashboard. Learn more about sharing here.
  • Revert clears any personal modifications you’ve applied, resetting your view of the dashboard and its PowerMetrics to the last saved version.
  • Delete the dashboard. (This option is only available if you created the dashboard or have been granted Edit access to it.)
  • Enter Edit mode. (This option is only available if you created the dashboard or have been granted Edit access to it.)
  • Access the following options for individual PowerMetrics on the dashboard (by clicking the 3-dot menu for each PowerMetric):
  • Expand/Collapse - Interact with your PowerMetrics while in full-screen mode. Once one PowerMetric is expanded, you can navigate between all of the PowerMetrics on a dashboard. Options are accessed from the expanded PowerMetric’s 3-dot menu. When you’re done exploring, click the button to collapse the PowerMetric and return to your dashboard.
  • Go to (name of the PowerMetric) - Navigate to the PowerMetric's Explore View page. If this is a visualization that displays data for more than one PowerMetric, select which individual PowerMetric you want to go to.
  • Add to dashboard - Add the PowerMetric to an existing or new PowerMetric dashboard.
  • About - Display information about the PowerMetric, including (if applicable) the name of the PowerMetric view (which displays at the top of the window), the name of the source PowerMetric (if you click the link beside 'PowerMetric', you open the PowerMetric in its Explore view), the owner, when it was last refreshed and last modified, and a definition with the formula (if it was created using one of the metrics from MetricHQ). If this is a visualization that displays data for more than one PowerMetric, select which individual PowerMetric you want to learn more about.

Edit mode

Edit mode is used for authoring and editing dashboards for you and your team. When you make changes in Edit mode, you are setting the default display that everyone will see when viewing the dashboard and its PowerMetrics.

Edit mode options range from simple modifications, like adding PowerMetrics, images, and text boxes to a dashboard and modifying the dashboard layout, to more integral edits, such as adding multiple PowerMetrics to individual visualizations, selecting an alternate date range, choosing a different visualization type, and viewing cumulative data and trend lines.

When you add a dashboard, you enter in Edit mode, where you can interactively make adjustments to your dashboard and each of its PowerMetrics. To enter Edit mode for an existing dashboard, click the Edit button in the upper-right corner of the dashboard.

Notes:

  • You can edit dashboards that you create and those to which you have Edit access.
  • Your edits only take effect after you click “Save”. If you previously made personal modifications to the dashboard, those with shared access to it must choose the "Revert" option (accessed from the dashboard’s 3-dot menu) to see the new saved version.

This section includes:

Adding and removing PowerMetrics

Each dashboard can display up to 15 PowerMetrics.

The following procedures describe how to add an existing PowerMetric to a dashboard. You can create and add a new PowerMetric by selecting Create a new PowerMetric instead.

To add a PowerMetric to a dashboard:

  1. In an open dashboard, click theEdit button in the upper-right corner.
  2. In the dashboard toolbar, click the Add a PowerMetric button.
  3. From the Display drop-down list, choose the category of PowerMetrics you want to select from (see below).

  1. Click thebutton beside the PowerMetric(s) you want to add to the dashboard.
  2. When you’re finished adding PowerMetrics, click Done.
  3. Click Save.

Note: You can also add a PowerMetric to a dashboard from the PowerMetric's Explore View page by clicking the 3-dot menu beside the PowerMetric's name and then clicking Add to dashboard > Add to PowerMetric dashboard.

To remove a PowerMetric from a dashboard:

  1. In an open dashboard, click the Edit button in the upper-right corner.
  2. Click the PowerMetric you want to remove and then click the Remove button in the dashboard toolbar.
  3. Click Save.

Adding images

Add colour, context, and vitality to your dashboard with images!

We support the following image file types: PNG, JPEG, and SVG. The maximum file size is 10 MB.

Note: Images don’t count toward your 15 PowerMetric limit for a dashboard.

To add an image to a dashboard:

  1. In an open dashboard, click the Edit button in the upper-right corner.
  2. In the dashboard toolbar, click the Add an image button.
  3. Select the image to insert.

The image is added to the first available space on the dashboard and can be resized by clicking and dragging its bottom-right corner.

  1. Click Save.

Note: You can duplicate or remove an image by clicking the image (with the dashboard in Edit mode) and selecting options from the dashboard toolbar.

Adding text boxes

Add titles and descriptions to your dashboard with text boxes. You can also insert UTF-8 characters and emojis. In addition, keyboard shortcuts, such as copy/paste and undo/redo, are supported.

To add a text box to a dashboard:

  1. In an open dashboard, click the Edit button in the upper-right corner.
  2. In the dashboard toolbar, click the Add a text box button.

The text box is added to the first available space on the dashboard and is ready for you to modify with your own information. You can resize the text box by clicking and dragging its bottom-right corner.

  1. Click the text box to display the properties panel, where you can apply and modify formatting.
  2. Click Save.

Note: You can duplicate or remove a text box by clicking it (with the dashboard in Edit mode) and selecting options from the dashboard toolbar.

Adding multiple views of a PowerMetric

You can add multiple copies of the same PowerMetric to a dashboard and then create unique representations of the data by applying different filters and segmentation to each copy.

Note: You can also create multiple copies of an image or a text box on a dashboard by clicking the image or text box (with the dashboard in Edit mode) and selecting the Duplicate button in the dashboard toolbar.

To duplicate a PowerMetric:

  1. In an open dashboard, click the Edit button in the upper-right corner.
  2. Click the PowerMetric you want to duplicate and then click the Duplicate button in the dashboard toolbar.
  3. Click Save.

Adding dashboard filters

Adding dashboard-wide filters enables you to display related PowerMetrics in context and more easily compare and showcase your data.

To add dashboard filters:

  1. In an open dashboard, click the Edit button in the upper-right corner.
  2. In the dashboard toolbar, click theAdd and remove filters button and select the dimensions you want to display on your dashboard.
  3. Click Save.

Modifying the dashboard display

You can modify your dashboard display by resizing individual PowerMetrics and reordering their position on the dashboard.

To resize and reorder PowerMetrics:

  1. In an open dashboard, click the Edit button in the upper-right corner.
  2. Click and drag the bottom-right corner of a PowerMetric to resize it.
  3. Click and drag a PowerMetric to change its position on the dashboard.
  4. Click Save.

Choosing dashboard date range and filter settings

You choose date range and filter settings at the dashboard level. Your choices will apply by default to all PowerMetrics on the dashboard, however, colleagues who view the dashboard can optionally make personal changes to these settings.

Notes:

  • You can set the dashboard date range and modify its filters in either View or Edit mode.
  • If you modify the filters and want to return to the dashboard’s original settings, click the 3-dot menu for the dashboard and select Revert
  • You may notice some date ranges are not available. That's because the range of historical data you can access is dependent on your pricing plan. Learn more here.

To choose the dashboard date range:

  • Select from the drop-down list and calendar options at the top of the dashboard. You can choose from our pre-set options or click Custom and apply a unique date range.

After adding filters (dimensions) to your dashboard, you can further define the information you want to display by choosing members to display for each dimension.

To choose members for a filter:

  1. On your dashboard, click the filter(s) for which you want to include or exclude members.

  1. Select members as desired.
  2. Click either Include or Exclude.
  3. Click Filter.

If there are a lot of members in your PowerMetric, use the Search feature to find them.

Note: If your browser window is too narrow to list all of the filters you've applied, click the Filters applied button, to view and modify your list of applied filters.

Editing individual PowerMetric settings

Note that the options available to you when editing depend on the chart type and style and the settings you chose when you created the PowerMetric.

To edit an individual PowerMetric, with the dashboard in Edit mode, click the PowerMetric. The properties panel displays on the right and gives access to the following options:

In the Display tab:

  • Title - Rename the PowerMetric. 

  • Chart Type and Style. Choose a combination of chart type and style to display your data meaningfully. For example, if you want to display data in a chart with stacked columns, you would select Bar / Column as the Chart Type and Stacked Column as the Style.

Available chart types are: bar and column charts, heat maps, line and area charts, pie and donut charts, radar plot charts, summary charts, tables, tree maps, waterfall charts, scatter and bubble charts, and combination charts. Available styles depend on the chart type chosen. Note: Stacked bar charts don't support trend lines. If your PowerMetric includes trend lines, your visualization will default to a column chart.

  • Display Top or Bottom - For ranked tables, choose whether to display the Top or the Bottom rows from your data and the Number of rows to display.

  • Break lines for blank values - When there are gaps in data, for example, if data is not refreshed during a time period, you can choose to break the chart lines to show the gaps in data. Alternatively, you can display a continuous line, where a line is drawn between known data points to fill in the gaps. By default, we break lines for blank values but you can deselect this option if you'd rather see a continuous line.

  • Show values as labels - Display values as labels in your chart. This option is not available for tables or summary charts.

  • Legend position - If your visualization includes a legend, choose to display it at the bottom, right, left, or top of your chart. You can also remove the legend by selecting None.

  • Comparison - Choose to either apply no comparison or to compare your data to other time periods (vs a previous period, vs the same period (last year), or vs a custom period). Comparisons are made between equivalent time period types. For example, if the date range selected is "today", then the previous period will be "yesterday". Note that the date range for the dashboard and for the individual PowerMetric you are working with must be set to a time period that enables a comparison. For example, if you set the date range for a dashboard to All Time, it will not be possible to compare to a different time period.

For line and bar charts, the previous period's data displays in the background as a grey dotted line. Note: The comparison setting is not applicable to the 100% bar, column, and area chart styles.

For summary charts and ranked tables:

  • There are a few options to choose from. You can display the percentage change or value change between the current value and the previous value (the delta), or you can show a comparison value (both values display together). Green is used to show a positive trend and red is used to show a negative trend.
  • When comparing data from a partial period, we compare it to a previous partial period. For example, if you are halfway through a month and want to compare to the previous month, your PowerMetric will be compared to the same period of the previous month.
  • When comparing, if there is no difference in values, no data available to compare to, or the time period set for the dashboard, or the PowerMetric, is not suitable for a comparison (for example, the dashboard time range is set to “All Time”) then the chart displays “--”.

  • Trend line - To more easily see data trends over time, you can apply a trend line to your visualization. Select Moving Average if you want to smooth out fluctuations in data so you can more clearly gauge patterns and trends. Select Linear if you want to see a straight line, indicating the general direction in which your data is heading. When you select either option, a line is added to your chart. If you also select Show as cumulative, the trend line is drawn using cumulative data. Trend lines exclude data from incomplete, partial periods.

In the Data tab:

  • For chart types that support multiple PowerMetrics:
  • You can add up to 4 PowerMetrics to a visualization, for a total of 5 PowerMetrics. When you click the button (as shown below), the Add a PowerMetric window opens. Click the + button beside each PowerMetric you want to add to your chart. Learn more about multiple PowerMetrics here.

Note: Some chart types don’t support multiple PowerMetrics. If you add multiple PowerMetrics to a visualization that supports them and then change the chart type to one that doesn’t support them, data for the first PowerMetric listed in the Data tab will display.

  • For chart types that combine PowerMetrics (scatter, bubble, and combination charts):
  • For scatter charts, select the PowerMetric you want to display for the X-Axis and the Y-Axis by clicking the button. Learn more about multiple PowerMetrics here.

  • For bubble charts, select the PowerMetric you want to display for the X-Axis, the Y-Axis, and the bubble Size by clicking the button. Learn more about multiple PowerMetrics here.

  • For combination charts, select the PowerMetric you want to display as Columns and the one you want to display as a Line by clicking the button. Learn more about multiple PowerMetrics here.

  • Aggregation - Choose how you want the PowerMetric's value to be aggregated over time by clicking the drop-down arrow beside the PowerMetric name, as shown below. Available aggregation methods depend on the type of data in your PowerMetric. The selected default aggregation is based on the choice you made when creating your PowerMetric.

  • Show as cumulative - Choose to view your PowerMetric data as a cumulative sequence by clicking the drop-down arrow beside the PowerMetric name, as shown below. Viewing your data from this perspective illustrates growth over a time period.

  • Segment by - Choose the dimension(s) by which you want to segment your data. Breaking down your data enables you to see your business performance from different perspectives. For example, you might choose to segment your sales data based on region, sales rep, or product type.

Note: To optimize clarity in your visualization, we recommend building your PowerMetric using fewer than 20 members. If your PowerMetric includes > 20 members, all members above the first 20 will be grouped together under “Other” in your visualization.

  • Over - Choose how you want your data to be grouped. Klipfolio automatically sets the time periodicity to use for your PowerMetric based on the date range you selected. For example, if you're viewing a date range for your data for the "Last 7 days", the auto-periodicity will be set to "Auto (Daily)". If your date range is "Last 8 weeks", the auto-periodicity will be set to "Auto (Weekly)". You can override the auto-selected time periodicity by choosing an alternate option from the drop-down list. By default, the x axis displays time but bar charts enable you to select either a time dimension to group by or a non-time-related dimension.

In the Filter tab:

  • Select a date range. The Use dashboard date range option is selected by default and applies the date range as set at the dashboard level. You can optionally select Custom to set a unique date range for a PowerMetric. You may notice some custom date ranges are not available. That's because the range of historical data you can access is dependent on your pricing plan. Learn more here.

If you chose Custom and you have applied unique filters to the PowerMetric, you can access date range setting details by clicking "x" filter. See below:

  • Click the drop-down arrows to filter your data by selecting the members to include for each dimension.

Note: Dimensional member filtering is done at the dashboard level but you can choose to apply unique filters at the individual PowerMetric level. Your individual PowerMetric settings override those that are set at the dashboard level. For example, if the dimensional member “Germany” is selected at the dashboard level and you select “Greece” at the individual PowerMetric level, the individual PowerMetric will display data for “Greece” only. When you apply unique filtering, you can access filter details by clicking "x" filters in the PowerMetric tile.

Learn more

Have more questions? Submit a request