- Welcome to the Knowledge Base
- Introduction
- Training
- Desktop Environment
- Preferences
- Activities
- Cases
- Forecasts & Quotas
- Importing Data
- Leads
-
Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
-
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
- Event Management
- Compliance Records
- GatorMail Integration
- Opportunities
-
Integrations
- Mapping
- Electronic Signing Tools
- Creditsafe Integration
-
Zapier
- 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 Integrations
- Email Dropbox
- Workbooks Exchange Server Sync
- Workbooks Outlook Connector
-
Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
- Outreach
- Scribe/Workbooks Connector
- People & Organisations
- Reporting
- Dashboards
- Transaction Documents
- Auditing
-
Configuration
- Introduction to System Administration
- Users & Security
- Database
- Accounting
- Email & Integration
- Customisation
- Automation
- PDF Configuration
- Contact Support
-
Releases & Roadmap
- Roadmap
- December 2020 Release
- September 2020 Release
- April 2020 Release
- 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
Pie Charts
To generate a Pie Chart you will first need to create a report that can be broken down into segments easily, such as the Template Report, Template - Sales - Total Performance, which shows monthly or individual Sales performance from won Opportunities.
Once you have run the report you will have the option to Chart this View, selecting this will generate a new window.
From this window you can select the type of chart you wish to create, to create a Pie Chart select the Create a pie chart option.
Data series
Data column - Select the column from the report that you are going to be segmenting.
Advanced
3D - Display the pie chart as three dimensional rather than two.
Donut - Turn the pie chart into a ring donut instead.
Show grand total - Creates a box that displays the total of all the data in the chart, which is positioned under the horizontal axis. The Grand Total displays the total of what is visible on the chart, so if filters are applied the Grand Total will change accordingly.
Show actual and visible values - If you have the Grand Total shown on the chart and want to display what the overall total is at all times regardless of the filters applied then this setting needs to be enabled.
Category
Label column - Choose the column from the report that will be used to segment the data column, this will most likely be your Grouping Column; this is the column that will appear in the legend once the chart is generated.
Advanced
Show text label - This changes whether each of the segments in the pie are labelled from around the edge allowing you to see exactly which value segment is which.
Show % alongside label - If the text label is enabled then it can also be accompanied with the percentage value of the chart that it possesses. If a filter is applied in the legend to remove segments, the percentage value will change accordingly.
Show value alongside label - If the text label is enabled then it can also be accompanied with the actual value that is generated by the report column.
Legend
Show legend - Enabling the legend creates a box on the chart informing you what each coloured column represents from the report. The legend can also be used to hide segments from the chart for more detailed comparisons.
Position - The legend can be placed around the the chart; by default this will be set to be positioned under the chart but can be moved to either be above or to the left or right of the Chart instead.
Layout - The legend can either be wrapped so that all of the values appear in the chart window, however this may mean that values appear over multiple lines, reducing the size of the chart. Alternatively, they can be set to a single row and you will have the ability to scroll offscreen to find the required value.
Styling
Palette - Choose from a number of colour palettes, this will determine the colour in which the bars will appear in.
Reverse the palette - Bars will be coloured in order of the palette; if you do not want to use the first colour you can reverse the palette and use the final colour instead.