Skip to main content

Create a Dashboard with a Conversational Query

Follow Along with Trail Together

Want to follow along with an expert as you work through this step? Take a look at this video, part of the Trail Together series.

(This clip starts at the 10:30 minute mark, in case you want to rewind and watch the beginning of the step again.)

Introduction

A dashboard is an interactive collection of widgets that visualizes data query results. Now you’re going to create a dashboard with an interactive chart, a list widget, and a table. You’ll incorporate the lens from the previous step and learn about tools in the dashboard designer, including conversational exploration.

Add the Lens to a Dashboard

To include a lens in a dashboard, clip it. When you clip the lens, CRM Analytics adds the query as a step in a new dashboard (or the most recently used open dashboard).

  1. In your new lens, click Clip to Designer icon to clip the query.
  2. Under Display Label, enter Amount by Industry and then click Clip to Designer.
    CRM Analytics opens the dashboard designer and adds the query in the query panel. The new query displays under the dataset that’s being queried, DTC OpportunityAmount by Industry displays under DTC Opportunity
  3. Drag the Amount by Industry query onto the new dashboard grid.
  4. Drag the corner of the chart to make it bigger.

Add a List Widget

A widget is a basic building block of a dashboard. You add a widget to your dashboard to perform a certain function. Functions might include showing key performance indicators, filtering dashboard results, visualizing data using interactive charts, or showing record-level details in tables. Here, you add a list widget to give dashboard users the power to facet all the charts in the dashboard.

  1. From the widget icons on the left, drag List  onto an empty space on the dashboard.
  2. Click List widget and then select Industry.
  3. Click Create.
  4. Click the list widget to select it.
  5. In the Properties panel on the right, click the Query tab.
  6. Verify that Apply global filters and Broadcast selections as facets are both selected.
  7. Under Selection Type, select Multiple Selection.
  8. On your dashboard, resize the list widget to make it bigger. The list widget shows the values per industry
  9. Click Save button to save your dashboard.
  10. Enter My Amazing Dashboard for the title of your new dashboard, and select App -> My Amazing App.
  11. Click Save.

Add a Conversational Query

A conversational query starts with a word or two from you, and then CRM Analytics provides suggestions that you can accept or edit. In this section, you see how quickly you can hold a conversation with your data, and then add the results to the dashboard.

  1. Switch back to the browser tab where your Developer Edition org is open to Setup Home.
  2. In the Quick Find box, enter Analytics, and select Settings.
  3. Make sure that Enable Conversational Exploration is enabled. If it isn’t enabled, select it and click Save.
  4. Switch to the tab with Analytics Studio, and refresh the browser page.
  5. If you’re not already there, open My Amazing Dashboard and make sure that you’re in edit mode, not preview mode. You should see Dashboard Designer near your dashboard name. If not, click the Edit button.
  6. In the dashboard header controls, click Menu icon to open the menu and select Conversations. (If the Choose Dataset dialog appears, select DTC Opportunity.)
  7. Click in the text entry box, type top 10 amounts by opportunity name, and press Enter.
  8. From the menu on the new chart, select Clip to DashboardThe dropdown menu on the new chart shows the Clip to Dashboard option.The new query, Opportunity_Name_1, that you just clipped to the dashboard displays in the list of queries. The new step, Opportunity_Name_1, displays on the right side.
  9. From the widget icons on the left, drag Table widget onto the dashboard.
  10. From the queries list, drag Opportunity_Name_1 and drop it on the empty table widget.
  11. Click Save button to save your dashboard.
  12. Verify it’s named My Amazing Dashboard and that it’s in My Amazing App, and click Save.

Now that you’ve created your dashboard with a conversational query, you’re ready to apply conditional formatting and annotate a saved view. It’s time to start sharing data insights with others in your org.

Note
Before you click the Verify Step button, make sure that your CRM Analytics-enabled Developer Edition org shows next to the Launch button.

Keep learning for
free!
Sign up for an account to continue.
What’s in it for you?
  • Get personalized recommendations for your career goals
  • Practice your skills with hands-on challenges and quizzes
  • Track and share your progress with employers
  • Connect to mentorship and career opportunities