Creating a new dashboard

Creating a Dashboard

Dashboard allows you to combine multiple reports in a single page for a quick overview. ManageEngine Analytics Plus provides simple & intuitive drag and drop interface to create a Dashboard. You can easily create a visually rich & interactive dashboard using the drag & drop interface by adding reports, widgets, user filters and rich-formatted text in single or 2 column layout. This section describes how to create a Dashboard in detail.

Creating a Dashboard

Once you have created your reports/views that you want in ManageEngine Analytics Plus you can start designing a Dashboard. To create a Dashboard, you have to invoke New Dashboard option.

From the Explorer tab of the workspace (or from any open view), click add new icon and then select New Dashboard option as shown below. The Edit Design window will open. Design your dashboard as needed.

1 - Custom Title added in the Dashboard

2 - User Filter added in the Dashboard

3 - KPI widgets added in the Dashboard

4 - Reports added in the Dashboard

5 - List of Reports in the workspace to drag into the Dashboard

The following section explains how to add the components into your dashboard.

Adding Reports

ManageEngine Analytics Plus allows you to add reports to your dashboard easily with a drag and drop interface.  
Follow the steps below to add reports to your dashboard.

  • Open the dashboard in edit mode.
  • You will notice that all the reports available in this workspace listed in the left panel, which you can drop into the Design Area on the right.

  • Report will be added to your dashboard.

  • Save the Dashboard.

Adding Formatted Text, Images & HTML

Analytics Plus allows you to enhance your dashboard by adding rich formatted text, images and HTML content to enrich your dashboard with relevant contextual information and styling.
To add text:

  • Click Add Text option from the toolbar or double click on any point in the Design Area.
  • Enter the content in the Text Editor that opens.

  • You can insert an image by clicking image icon.
  • You can also insert content using HTML editor. Will be useful to insert any Web components like Youtube video etc.,.

  • Analytics Plus allows you to organize the added text as needed at anytime. To know how to layout your dashboard, click here.

Adding KPI Widgets

ManageEngine Analytics Plus offers a widget-based model for creating single number charts (headline charts) within dashboards. These are called KPI Widgets. This is a pretty useful feature to highlight any key metric in a dashboard for easy comprehension. The key metric can also be accompanied with associated comparison indicators to highlight the trend. 

Click here to read the detailed help document about adding KPI Widgets.

Adding a Widget 

To add a new KPI widget follow the below steps:

  • In the dashboard Edit Design.
  • Click the Add Widget option in the toolbar. The Widget Editorwill open.
  • The Data tab of the Widget Editor provides options to choose the type of widget and the associated columns.   
  • Choose the widget type under Select Layout. You will find six templates.
    You can also view each template with sample data to make a better choice by clicking the Show Samplelink that appears on mouse over.

  • Select the columns required for your calculation in the Select Columnsection. ManageEngine Analytics Plus will return a single value based on the columns and function selected in this section. 
    • In the Data Column drop-down select the data column that you want to display in the widget along with the calculation function to apply over it. 
    • In the Group By drop-down select the column by which the above mentioned data column value should be grouped.  
  • Based on the type of layout that you choose, you might have to provide additional information to create the widget. This is to be provided in the  Show Value Assection. 
    • The Primary Value drop-down allows you to apply a summary function over the data column dropped 
    • The Secondary Value allows you to specify an additional column along with a calculation function applied, that will be displayed along with the Primary value (primary metric).  

For instance, if your primary metric is total  sales, you can also choose to display the maximum and minimum sales values alongside the main value by selecting the appropriate template. 

Upto two secondary values could be displayed along with the primary value based on the template you choose.  

 

ManageEngine Analytics Plus also allows you to format the data as you would do table column usin the Format link. 

The Filters Tab

In the Filters tab, you can filter the data as required, by dropping the columns into the filters area and selecting the appropriate values.

 

 The Settings tab

The Settings tab provides option to format the widget. With this you will be able to customize the label name, font and the comparison indicator pattern.

 

 The following are the setting option available.

Themes

You can apply widget themes to customize the background of the widget. 

  • Presets - Select the color of the theme. This will be the background color of the card. You can also customize the color using the Custom option.
  • Font Color - You can change the font color of the text in the widget by clicking the Font Color icon.

Primary Value

This section provides options to customize the primary value displayed.

  • Label - You can customize the following aspects of the label:
  • Name - Specify the name to be displayed as label.
  • Text Style - Customize the font style of the label as needed.
  • Value - Customize the font style of the value displayed.

Secondary Values 

This section provides options to customize the secondary value.  

  • Label - Specify the data to be displayed as a secondary value. You can customize the font style of the label as needed.

Comparison Indicator

Using this you can configure the indicator icons and color that are to be shown in the widget when the Primary value is lesser than or, greater than or equal to 0. This has two options.

  • Icon - Choose the icon type and color.
  • Value - You can use this option to color the primary value.

Parameterized Format

ManageEngine Analytics Plus allows you to specify Labels for both Primary Value and Secondary Values in a parameterized format, enabling you to display dynamic values in the dashboard widget.

The following is the given format to specify a parameterized format.

${ColumnName}.LABEL -  Refers to the default label of the column used.
${ColumnName}.VALUE - Refers to the corresponding functional value of the
column used.
${OPERATION} - Refers to the corresponding Show Value As operation.

The following screenshot shows KPI widget added in a Dashboard.

Editing the widget

Whenever required, the widget can be edited. Hover the mouse on top of the widget till a menu bar appears, and click the Edit option. The Widget Editor will 
open. You can modify the settings as required. 

Adding User Filters

ManageEngine Analytics Plus allows you to include dynamic filtering capability in the dashboard view mode using the User Filter option. This enables viewers of the dashboard to apply filters dynamically and view the required information. You can add User Filters to the entire dashboard or for the individual reports embedded as required.

The following sections explain how to add User Filters.

User Filter for the Dashboard

To add User Filter to the Dashboard:

  1. In the Edit Mode User Filters section will be available. Click Add User Filter button.
  2. Columns from all tables used in the views of the dashboard will be listed in the column panel at the left. Drag and drop the required columns to be used as user filters.
  3. Editing user filter column is similar to editing user filter for charts (or pivot table or summary view).

Auto Add User Filter

ManageEngine Analytics Plus allows you to add existing user filters that have been added to a report to be automatically added for the dashboard too.

This is a easy & convenient way to add users filters to a dashboard, without the need to repeat the task of user filter creation again.

To achieve this:

  1. Select the Auto Add User Filter check box from the User Filters field.
  2. Add reports with existing user filters to the dashboard. User filters in these reports will be automatically added to the dashboard.

Adding Timeline Filters

Analytics Plus allows you to create a common Date/Period user filters that can be applied on all reports in the dashboard. This user filter is different from the other filters (described above), as it is not tightly bound to any (date) column in a table.
With this timeline filter you will be able to setup a common Date/Period user filter independent of the tables on which the reports have been created. When you use the timeline filter in a dashboard, Analytics Plus will apply the criteria on all reports, matching it with the best possible date column associated with the report. By default, if the report has a date column, it will filter using it. The matching date columns can also be customized.
Since this is a common period filter, you can setup only one timeline filter in a dashboard.

To add a timeline filter,

  • Click Add User Filter button and select Include Timeline Filter check box (or drag and drop) as shown in the snapshot.

  • Click the edit icon that appears on hovering the mouse on the timeline filter. In the Edit Timeline Filter dialog that opens, you can change the filter name in the Filter Display Name box.

  • Click the Edit link to change the values that you wish to display in the Timeline filter.

  • You can select the values by selecting the check boxes.

  • Click Apply to add the filter.

How does this filter work

When you apply this filter, by default it will be applied only on those reports that have a date column as a part of it. The date columns can be customized using the Timeline filter column mapping section(as shown in the below snapshot).

  • In the Date columns to use for filtering section you can specify the date column to be filtered. You can specify multiple columns as well.
  • You can also specify the order for applying filters in this section

  • On date columns used in the report (default option)- choose this option to apply the timeline filter on the date column used in the report which is a part of the dashboard.

  • On date columns in the table on which the report has been created - choose this option to apply the timeline filter on the reports present in the table on which the report is created, although the report does not contain a date column itself.

  • On date columns in related tables - choose this to apply the timeline filter on the reports in the dashboard which does not contain a date column in its table but has a date column that is contained in a related table.

  • Click Apply. This filter will be applied.

 

Merge User Filters 

You can merge duplicate user filters from different tables as one common filter. The animation below shows the merging of user filters with a simple drag and drop. 

You can add or remove the mapped columns from these filters as shown below. 

Note: 

  • You cannot remove the primary user filter column over which the other user filters are merged.
  • You cannot merge two columns from a table into the same user filter.

User Filters for the Individual Reports

You can also add user filters for individual reports that have been added in a dashboard.
To achieve this:

  • Create a report (chart/pivot/summary view) with User Filters.
  • Add this report to the dashboard.
  • Hover your mouse over the added Report.
  • Select the Show User Filter check box from the Options. Click Apply.
  • User Filters will be added to the corresponding report alone.

Columns Not Related

ManageEngine Analytics Plus will display an alert over a user filter column (refer to the image below), when you delete all the reports that uses this column from the dashboard. This helps you to easily identify columns which are no more relevant in user filters and remove them. Hover your mouse over the corresponding column and select Remove from the highlighted options. You cannot save the dashboard without removing it.

 

Layouting components in Dashboards

ManageEngine Analytics Plus offers a wide range of options to customize the dashboard. With its drag and drop interface you can layout of the reports, widgets, user filters & formatted text as you need and create a visually rich dashboard quickly. You can do all these in the Edit mode of the dashboard.

Resizing column

You can easily align the column space for each component by dragging the separation border.

Reorganizing Component

You can rearrange the components in dashboard into any location needed by using the drag and drop option.

Reports specific customizations

ManageEngine Analytics Plus provides context specific options to customize any report that you drop in a dashboard. These options will appear on mouse over.

  • Refresh: Using this option you can reload the report
  • Options: Various options will be listed under this based on the type of view/report.

Refer to the following table for the setting available in this section.

OptionDescriptionApplicable View Type
Show TitleSelect/deselect this option to show/hide the corresponding report's title.All Views
Show DescriptionSelect/deselect this option to show/hide the corresponding report's Description.All Views 2

Apply Dashboard Filters

Select/deselect this option to include/exclude the Dashboard's User Filters for the corresponding report.
User Filters allow users to apply selected filters dynamically to
show only permitted subset of values in the corresponding view.
All Views
Legend PositionSelect the position of the Legend you need from the drop-down list. Supported positions are: Hidden, Right, Left, Top-Left, Top-Center, Top-Right, Bottom-Left, Bottom-Center and Bottom-Right.Charts
Search BoxSelect/deselect this option to include/exclude search box for the table.Table
  • Expand/Contract: Using this option you can change the dashboard layout to single or double column display for the corresponding view in that row.

Choose Expand option for single column display and Contract option, for double column display. When Contract is selected, you can resize the view.

Use this option to create a Single or Double Column layout for a dashboard.

  • Remove: Using this option you can delete the view from the Dashboard.

Text and Image specific customizations

You can customize text and image added in Dashboard. These options will appear on mouse over.

Edit - Using this option you can open the text editor to modify the content.
Expand/Contract - Using this option you can change the dashboard layout to single or double column display for the corresponding view in that row. Choose Expand option for single column display and Contract option, for double column display. When Contract is selected, you can resize the view.
Remove - Using this option you can delete the element from the Dashboard.

KPI Wigdet specific customizations

You can customize KPI widget in Dashboard. These options will appear on mouse over.

Edit - Using this option you can open the KPI widget editor to modify the content.
Expand/Contract - Using this option you can change the dashboard layout to single or double column display for the corresponding view in that row. Choose Expand option for single column display and Contract option, for double column display. When Contract is selected, you can resize the view.
Remove - Using this option you can delete the widget from the Dashboard.

Customizing the Theme

Analytics Plus allows you to customize your dashboard theme as needed. This will be beneficial while embedding content, as you can customize the dashboard to suit your website or application.
The following steps explain the process of customizing your dashboard.

  • Open the Dashboard in View Mode.
  • Click Themes at the top right corner. The Dashboard Themes dialog will open, displaying six different themes with six types of layouts for the dashboard.

  • Select the required preset theme, with the required layout design. 
  • The color of these six preset themes can also be varied as per the user requirements.

  • Click Customize at the top right corner to the modify the theme.
  • Change the theme settings as required. Options will vary depending on the theme you have selected.
  • Click Apply.

Share this post : FacebookTwitter