Reader small image

You're reading from  Creating Actionable Insights Using CRM Analytics

Product typeBook
Published inDec 2021
Reading LevelBeginner
PublisherPackt
ISBN-139781801074391
Edition1st Edition
Languages
Tools
Right arrow
Author (1)
Mark Tossell
Mark Tossell
author image
Mark Tossell

Mark Tossell is passionate about solving problems and improving processes using data. Tableau CRM (Einstein Analytics) and Tableau, powered by AI, are the tools of his trade. He is a proud wearer of the Salesforce Gold Hoodie and recipient of the inaugural APAC Awesome Admin award. He is also a Trailhead learning addict, having earned over 420 badges. In addition, he is honored to be a Tableau CRM Ambassador and a Salesforce Partner Solution Engineer. Mark lives in Sydney, Australia, with his wife, Christina, and son, Adam.
Read more about Mark Tossell

Right arrow

Creating a dashboard and placing widgets

The best way to show you how to build a dashboard and help you become familiar with the dashboard editor is to walk you through a simple dashboard build.

Creating a sales dashboard

We will create a sales dashboard based upon the Opportunities dataset in My First Analytics App. Follow these steps:

  1. Create a fresh query by clicking on the Create Query button on the right-hand side of the canvas.
  2. Select the Opportunities dataset in My First Analytics App. This brings you to a view that is familiar to you as being almost identical to a lens.
  3. At the top left, where you see a pencil icon, rename the query Pipeline by Close Date.
  4. Change the measure (Bar Length) to Sum of Amount.
  5. Add a grouping (Bar) for Close Date (Year-Month).
  6. On the far right, click on the Charts icon and change the chart type to Time Bar in the DATES & TIMES category.
  7. Add a filter for Closed equal to the value of False (as in, open opportunities...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Creating Actionable Insights Using CRM Analytics
Published in: Dec 2021Publisher: PacktISBN-13: 9781801074391

Author (1)

author image
Mark Tossell

Mark Tossell is passionate about solving problems and improving processes using data. Tableau CRM (Einstein Analytics) and Tableau, powered by AI, are the tools of his trade. He is a proud wearer of the Salesforce Gold Hoodie and recipient of the inaugural APAC Awesome Admin award. He is also a Trailhead learning addict, having earned over 420 badges. In addition, he is honored to be a Tableau CRM Ambassador and a Salesforce Partner Solution Engineer. Mark lives in Sydney, Australia, with his wife, Christina, and son, Adam.
Read more about Mark Tossell