- Welcome to the Knowledge Base
- Introduction to Workbooks
- Using the Knowledge Base
- Editions & Licensing
- Logging In
- Supported browsers
- Landing Pages
- HTML Editor
- Welcome Messages & Bulletins
- Exporting Data
- Multi Language
- Notifications & Reminders
- Workbooks Mobile Client
- Forecasts & Quotas
- Introduction to Importing
- Preparing your Import Data
- Workbooks Import Wizard
- Managing your Imports
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Upload Library
Workbooks Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- Gator Popup
- Reporting incorrect Leads created through Web Insights
- Reporting on Web Insights data
- Using UTM Values
- Why aren’t Online Activities being created in the database?
- Why is GatorLeads recording online activities in a foreign language?
- Using HubSpot with Workbooks
- Introduction to Event Management
- Enabling the Event Management Module
- Using Event Records
- The Event Management Portal
- Compliance Records
- Setting up the Integration
- Sending Mailshots using GatorMail
- GatorMail - Dynamic Content
- GatorMail Domain Setup
- GatorMail Field Mappings
- Managing your GatorMail Account
- Setting up GatorMail Workflows
Electronic Signing Tools
- DocuSign Functionality
- Setting up the DocuSign Integration
- DocuSign - Worked Examples
- DocuSign - Reporting
- Adobe Sign Integration
- Docusign Integration
- Creditsafe Integration
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
Setting up Zaps
- Posted Invoices to Xero Invoices
- Xero payments to Workbooks Tasks
- New Case to Google Drive folder
- New Case to Basecamp Project
- New Workbooks Case to JIRA Ticket
- Jira Issue to new Case
- 123FormBuilder Form Entry to Case
- Eventbrite Attendee to Sales Lead and Task
- Facebook Ad Leads to Sales Leads
- Wufoo Form Entry to Sales Lead
- Posted Credit Note to Task
- QuickBooks Online
- Survey Monkey responses to Tasks
- Multistep Zaps
- Email Dropbox
Workbooks Exchange Server Sync
- WESS System Requirements
- Setting up the WESS
- Synchronising Emails
- Synchronising People & Contacts
- Synchronising Tasks & Meetings
- WESS Troubleshooting
- The WESS Add-in
Workbooks Outlook Connector
- Introduction to the Outlook Connector
- Before downloading the Outlook Connector
- Download/update the Outlook Connector
- Installing the Outlook Connector
- Using the Outlook Connector
- Outlook Connector Troubleshooting
- Microsoft Office
- Scribe/Workbooks Connector
People & Organisations
- Introduction to People & Organisations
- De-duplication and Merge
- Using Loqate
- Data Enrichment
- Introduction to Reporting
- Reporting Explained
- Displaying reports within Record Views
- Displaying Reports
- Adding a Report view to a Dashboard
- Exporting Reports
- Advanced Reporting
- Introduction to Transaction Documents
- Credit Notes
- Customer Orders
- Supplier Orders
- Contract Management
- Introduction to System Administration
Users & Security
- User Groups
- Account Settings
- Licences & Modules
Email & Integration
- Email Settings
- API Keys
- Web to Case and Web to Lead
- Preference Centre
- MailChimp, Constant Contact & dotMailer
- SharePoint Integration
- Bank Account Validation
- Creating & Modifying Picklists
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- PDF Configuration
- Contact Support
Releases & Roadmap
- January 2020 Release
- September 2019 Release
- February 2019 - Event Management Release
- January 2019 Release
- October 2018 Release
- May 2018 Release
- February 2018 Release
- January 2018 Release
- November 2017 Release
- September 2017 Release
- June 2017 Release
- March 2017 Release
- December 2016 Release
- August 2016 Release
- January 2016 Release
- Workbooks Glossary
Creating a Sales Dashboard
This example will talk you through how to build a Dashboard that provides you with an overview of the performance of your Sales Team. This guide will show you how to add different types of Elements to a Dashboard, create a Dashboard Field and a custom View.
This can then be applied to any other Dashboard scenario to help you create and customise any specific requirements.
Stage 1: Create Reports
In order to populate the Dashboard you will first need to create the Reports and Charts needed in order to display the data.
Step 1: Create Template Reports
In this example we are creating a Dashboard using five Template Reports. These can all be accessed from Start > New > Report > Create a Report from a template report and then select the name from the list below:
- Template - Leads Assigned to Sales Reps by Status
- Template - Sales Leads - numbers
- Template - Current Sales Pipeline by Stage
- Template- Opportunities - numbers
- Template - Opportunity Conversion Rates
Once these Reports have been created they are ready to be added to the Dashboard, you may not need to make any changes to these Reports as they are simple templates. However it is worth checking some of the criteria in place to ensure they work with your data.
Step 2: Create a chart
For this Dashboard we will create a Pie Chart for the Report Template - Current Sales Pipeline by Stage to do this you will need to Run the Report and then select the Action to Chart this view. We will then use the Total Amount as the Data Series and the Sales Rep as the Category.
This will then generate a Pie Chart similar to the below:
Stage 2: Create the Dashboard
You can now create the Dashboard and setup the Elements needed
Step 1: Create a new dashboard
To create the Dashboard go to Start > Dashboards and then select New Dashboard.
The Dashboard will then require a Name and select the number of columns, in this example we will call this Dashboard “Sales Performance Dashboard” and set there to be two Columns and a 50/50 split.
Select Save and navigate to the Layout Tab here you will be able to add the Reports and Charts created in Stage 1 to the Dashboard.
Step 2: Add the Reports
To add the Reports select the Add Picklist and then the Report option.
Each Report will need to be added individually, using the Report Column select the Report by name and then the View you would like to add. By default the Title will be set the View name, so may need to be changed if the View is called “Summary” or similar.
Any additional settings can be edited at this stage on the Report, in this example we will use the default settings, but more details on this can be found on our Knowledge Base.
Step 3: Add a chart
Once the Reports have been added the Charted view can be added in exactly the same way, by Selecting Add and then the Chart option.
This time only Reports with a Charted View will appear in the Report Field, this should make it easier to find the required Report. Similarly to a Report element addition settings can be configured for the Element but we will use the default for this example.
Step 4: Modify the element positions
Once you have now added the Report and Chart Views to the Dashboard all of the Views will appear in the left hand column with the most recently created will appear at the top.
By selecting the Element Header you can then drag and drop each element into either Column and into the order you require.
Stage 3: Create a Dashboard Field
We will now create a Dashboard Field which will be used to map the Sales Rep name from each of the Reports and Charts. This allows you to see not only overall Team Performance but can also see an individual’s performance.
Step 1: Create the field
Within the Dashboard select the Fields tab, from here you will create the Dashboard Field.
This Dashboard Field will be called “Record Assigned to” and will be using a Data type of String, as the Assigned to will always be in text form.
Step 2: Add field mappings
A field mapping will now need to be added between the Dashboard Field and each element within the Dashboard, this will then allow you to filter each element as required.
By selecting the Add button you can then select the Element, Report View or Chart View and then the column from each element that you want to map to, this may be called Assigned to, or Sales Rep within the Report.
This will need to be carried out for each Element within the Dashboard that you want to add the mapping to. Within the example below you should end up with a list of field mappings similar to the below.
Step 3: Apply to a View
Once the Field Mappings have been set up we can now apply filters to a Dashboard View. To do this go to the View filters tab and select Add.
At this time there is only one Dashboard View, Default. We will create a filter in the Default view that will allow us to perform a starts with search on the Record Assigned to Dashboard Field that has been created.
This means that we need to select these values for the View and Field options when configuring the Filter. For the Operator select starts with and leave the Text field blank. Ensuring that the Editable box is checked allows us to use this Filter like a Landing Page Filter.
Saving and running the Dashboard, you will now see that there is a Filter at above the the Elements where you can apply a value to the Record Assigned to and filter the Reports and Charts accordingly.
Stage 4: Create a User specific View
We will now create a View to look at a specific User’s performance across these Reports, we will then add an additional View filter to the Dashboard Field so that when the view is selected you will only see the specified User’s activity.
In this example we will be looking specifically at where the Record assigned to value is Jane Fretwell.
Step 1: Create a new view
Within the Dashboard Edit Menu navigate to the Views tab and select Add as we want to keep our Default View.
We will call this View “Jane’s Performance” and provide a Description to match this. Once this is done Save & Close this View.
Step 2: Create a new field mapping
From within the Edit Dashboard menu, go back to the Fields Tab and open the existing Record Assigned to Field. We do not need to create a new Field but can edit the existing one to display different results for different views.
Once you have opened the Dashboard Field select the View filters tab and select Add.
When setting up this Filter, we are going to select “Jane’s Performance” for the in view value, we then apply the operator of is and enter Jane’s full name. In this scenario we will also remove the editable setting from the filter so it will only ever output Jane’s details.
Saving and running the Dashboard now you will notice a new View has been created and is accessible on in the Views section of the menu similar to a Landing Page. As we made the Filter read only there is no visible filter available on the Dashboard as there was with the Default view. The filter has been applied and hidden from a User’s view.