Custom Dashboard

Custom Dashboard allows you to design your own dashboards to meet business needs using a combination of built-in metrics and custom KPIs based on the user’s demographic or context information to provide a more tailored and relevant view of the data.

Using Custom Dashboard, you can select the metrics most relevant to your needs and display them in a way that is easy to understand and use. This can be particularly useful if you have a lot of user conversations and data that you need to track and monitor, as it allows you to focus on the most important information and ignore the rest.

Custom Dashboards are available along with the otherout-of-the-box dashboards in the Bot Builder. For more information on Default Dashboard, see here.

Follow these steps to build Custom Dashboards:

Identify the data points that you need to capture for deriving the metrics, based on your business requirements and needs.
Define suitable Custom Meta Tags to emit these data points in the Bot definition. To know how to add custom meta tags to your Virtual Assistant (VA), see here.
Design widgets, preview, and update the dashboard with these widgets.

The following sections describe the steps to create custom dashboard widgets.

Go to Analyze > Custom Dashboards in the left navigation menu, to add multiple custom dashboards for your VA.

Each of these dashboards can have one or more widgets.
Each widget in the dashboard must be associated with a dataset
You need to define a query to extract the required data to be displayed in a widget

Add Custom Dashboards

You can add one or more Dashboards by providing basic details of the Dashboard.

To add a new dashboard, click on the kabab icon on the top right and select the ‘New Dashboard’ option. Enter the name of the dashboard.
Please note that you can edit the name of the Dashboard anytime.
By default, each custom dashboard comes with a Date Filter, allowing you to filter the records for all the widgets in the dashboard. You can choose between 24 hours, 7 Days, and a custom date range. You can also configure and add custom filters, allowing you to filter all the widgets within the dashboard. See Create Custom Filters for Custom Dashboard to know more.
You can choose a Color Theme for your dashboard.
You can Add Widget to a given Dashboard (see below for details).
You can reorder the widgets within a dashboard using the move cursor, visible on the mouse hover over the widget, to drag and reorder the widget anywhere on the Dashboard.
Using the Kebab menu (vertical ellipses) icon, you can do the following:
- New Dashboard: Allows to create a new dashboard
- Clone Dashboard: Copies the dashboard to a new dashboard with the same configuration
- Export Dashboard: Exports the configuration of the dashboard in a JSON file
- Delete Dashboard: Allows you to Delete the custom dashboard

Add Widgets

You can add one or more widgets to a Dashboard using the Add Widget button. You can add up to 4 widgets per row and organize them by moving anywhere within the row or across the rows on the dashboard. You can also manually resize the widgets.

Widget configuration involves two steps:

Data Definition
Data Representation

Data Definition

Every widget must have a query defined to retrieve and represent the required information on that Widget. Following are the configurations used to generate the query definition:

Dataset defines the data source. The source can be:
- Analytics: Analytics gives access to data about Success Intents, Failed Intents, Success Tasks, and Failed Tasks associated with your VA. You can view key fields like MetricType, Channel, UserId, etc.
- Message: This dataset provides VA and User messages for your VA. You can view key fields UserId, Channel, etc.
- Sessions: The dataset lists conversation sessions associated with your VA. You can choose to view key fields like UserId, Channel, etc.

Note: You can view the top 20 records for all the dataset fields.

The platform allows you to choose between Query Mode and Advanced Mode while writing a query. For more information, see Widget Configuration Modes.

Date Range is set by default to the past 7 days and can be customized to a range of 90 days. This date range is only used for preview purposes.
Select fields to be depicted by the Widget.

- The fields differ for each selected dataset. See the table for more details. For example to list the success & failed intents, metricType:
- You can apply on these fields the aggregation functions like “min”, “max”, “sum”, “count”, or “avg”“. For example to count the total triggered intents, count(metricType), you can give a display name as an alias – count(metricType) as total.

Aggregate Functions

While defining a query, you can click the drop-down provided for each field in Select, to access the relevant aggregate functions. On selecting the appropriate aggregate function, you can enter the filter criteria.

Note: Aggregate functions are visible only when the user chooses the Advanced mode.

The following table describes all the available aggregate functions:

Aggregate Function	Description
Sum	The arithmetic total of all values in the column
Min	The smallest-value element in the column
Max	The largest-value element in the column
Average	The mean average of the elements in the column
Count	The total number of elements in the column
None	Use it to remove an aggregate function added to a query

The Distinct function is used to obtain the number of distinct values across the column. It is allowed with the following aggregate functions:

- Sum
- Count
- Average
Apart from these if you have defined any Custom/Meta Tags for your VA, you can use them under the appropriate heading with the following notation: userTag.tagname = value. If you declared a Message level custom tag, select the Message Dataset and enter messageTag.TagName. This would result in an empty dataset, and as a result the display would be empty.
Filter By clause is used to extract only those records that fulfill a specified condition. You can apply the following operators on these fields: “=”, “>=”, “<=”, “>”, “<“, “in”, “not in”.
For example, to obtain the count of a specific FAQ, the following details are entered in the query setup.
```
taskName = 'What account privileges does an authorized user have?' and metricType = successtasks.
```
While conjugating multiple conditions, they would be evaluated left to right, and this ordering cannot be changed using parentheses ()

Note: In the query setup, for Filter By, individual AND, OR operators, and multiple ANDs, ORs, can be applied, but a combination of AND/ORs is not supported.

Group By fields for applying the aggregating functions. For example you can display the count of all messages, grouping by the userId. To understand the Group By usage, see the examples at Create Custom Dashboard
Having clause is used to filter the results with aggregate functions as ‘Where’ keyword cannot be used here. For example, count(messageid)>10. The clause works only with the ‘Group By’ function.
To understand how the Having clause works, see Filter the Messages using the Having Clause.

Note: In the Having clause, the fields with aggregate values in the Select clause are automatically included.

Sort By fields (actual field names, not alias as give in the Select clause) to order the results in ascending or descending order – “asc”, or “desc”. For example to sort in the descending order of the metric type, metricType desc

Note: In the Select clause, you can provide an alias to make column names more readable. For other fields, you cannot define aliases and must give actual column names.

Run the query to see the results in a tabular format.

Note: A tag added for Select, Filter By, Group By, Having etc. can be deleted using a Delete icon which is displayed only upon hovering over the tag.

End-user Vs. Developer Interactions

By default, the end-user interactions are displayed for all the datasets in the Custom Dashboards. If you want to display the developer interactions, use the isdeveloper flag to filter the interactions as follows:

To display only the developer interactions, use isdeveloper = include in the filter condition.
To display both the developer and the end-user interactions, use one of the following in the filter condition:
- isdeveloper = include or isdeveloper = exclude
- isdeveloper = exclude or sessionid = "any developer session Id"

In any custom dashboard widget, for any dataset, you can assign a value to the isdeveloper flag in the Filter By clause as shown below.

Data Representation

The next step is to render the data in a visually appealing way. The following options are available for data representation:

Table renders the data in a simple row and column format. You can specify the Columns and their order from the Dimensions option.
Pivot chart summarizes the data. You can specify the Dimensions – the columns to be displayed; Metrics – the value against the column; and Overlay – the column to be considered in case a data series needs to be represented. For example, if the dimension is set to be ‘date’, metric as ‘number of chats’ and overlay to be ‘customer type’, then the number of chats per customer type, with each distinct customer type as a series, would be displayed.
Bar Chart is used to depict the data across the X- and Y-axis. The results can be split into Data Series based on the Overlay field and get multiple lines plotted.
Horizontal Bar Chart is used to depict the data across the X- and Y-axis, a flipped version of Bar Chart. The results can be split into Data Series based on the Overlay field and get multiple lines plotted.
Line Chart is used to depict the data across the X- and Y-axis. The results can be split into Data Series based on the Overlay field and get multiple lines plotted.
Pie Chart is used for aggregation data to depict part-of-whole scenarios. Use Dimensions to set the fields to be depicted and the Metrics to set the aggregation function to be depicted.
Donut Chart is similar to a Pie chart but has better visualization.
Label Chart highlights value or metric in a space of its own.

Click the Preview button to visualize the widget. If it suits your purpose, add the widget to your Dashboard to save the changes.

Note: You have to successfully run the query to be able to Preview it.

Widget Actions

Using the more icon (vertical ellipses) against each Widget, you can access the following options:

The Edit Widget option opens the Widget definition page where you can make changes to an already defined Widget.
The Clone Widget option is used to duplicate the Widget definition and modify it.
The Export option is used to export the widget data
- JSON format includes the final results that are displayed in the Widget UI
- CSV format exports the results of the query that is associated with the widget (before converting the data as per the Widget UI)
The Delete Widget option is used to delete the widget from the Dashboard.
Additionally, you can organize the widget by moving anywhere within the row or across the rows on the dashboard. You can also manually resize the widget.

Note: The final Widget definitions of a custom dashboard can be exported in JSON format. The individual widget data can be exported in CSV format.

Widget Configuration Modes

The platform allows users to select between Query Mode and Advanced Mode to extract data from a selected dataset. Widget configuration modes are introduced in the 10.0 release.

Query Mode

Query mode is for users and developers who can write queries to create a widget. Ideally, advanced users who know the fields in the dataset are recommended to use this feature.

Advanced Mode

Advanced mode is a user-friendly way to create a custom dashboard without the technical know-how of writing queries or the dataset. The platform provides you with the type-ahead suggestions of the fields, aggregate function, and alias while writing a query.

Note: The configured data remains intact when you toggle between Advanced and Query modes. You can modify the configurations of any widget using either of the modes.

Type Ahead Suggestions

In the Advanced Mode, you get type-ahead suggestions to write the criteria for Select, Filter By, Group By, Having, and Sort By clauses. The platform provides suggestions of the fields present within the selected dataset or message tags, session tags, and user tags that are added to the bot. The platform also allows you to add aggregate functions, filter criteria, conditional operators, alias names, etc., to build a valid query.

Note: You can add custom meta tags to the query that are not included in the bot while configuring the widget. However, to get the right data, you need to add the custom meta tag to the bot configuration.