Knowledgebase articles
- Welcome to the Knowledge Base
- Introduction
- Training
- Getting Started
- Preferences
- Activities
- Cases
- Importing Data
- Leads
- Marketing
- Introduction to Marketing
- Marketing Campaigns
- Mailing Lists
- Products
- Mailshots
- Upload Library
- Templates
- Event Management
- Compliance Records
- Spotler Integration
- What is Spotler?
- Navigating your Spotler homepage
- GatorMail
- GatorLeads / Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- 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?
- GatorSurvey
- GatorWorkflow
- GatorPopup
- Opportunities
- Projects
- 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
- RevenueGrid Intelligence and Engage
- Event & Webinar Integration Tools
- GoToWebinar
- ON24
- Microsoft Office
- Outreach
- Installation
- Outreach Authentication
- Sync People to Outreach Prospects
- Sync Organisations to Outreach Accounts
- Sync Workbooks Opportunities to Outreach
- Sync Tasks/Activities from Workbooks to Outreach
- Sync Outreach Sequences to Workbooks
- Sync Outreach Sequence States to Workbooks
- Sync Outreach Sequence Step Numbers to Workbooks
- Sync Prospects/Accounts/Opportunities from Outreach to Workbooks
- Sync Outreach Tasks/Calls/Meetings to Workbooks
- Scribe/Workbooks Connector
- RingCentral
- Auditing
- Comments
- People & Organisations
- Reporting
- Introduction to Reporting
- Using Reports
- Introduction to Charts
- Exporting Reports
- Advanced Reporting
- Report Snapshots
- Dashboards
- Transaction Documents
- Introduction to Transaction Documents
- Displaying & Adding Transaction Documents
- Copying Transaction Documents
- Transaction Documents Fields Help
- Transaction Documents Line Items Help
- Printing & Sending Transaction Documents
- Managing Transaction Document Currencies
- Managing Transaction Document Statuses
- Setting a Blank Default Currency on Transaction Documents
- Credit Notes
- Customer Orders
- Invoices
- Quotations
- Supplier Orders
- Contract Management
- Sagelink
- Introduction to Transaction Documents
- Auditing
- Configuration
- Introduction to System Administration
- Users & Security
- Database
- Accounting
- Email & Integration
- Customisation
- Creating & Modifying Picklists
- Theme
- Record Types
- Creating Custom Fields
- Report-based Custom Fields
- Linked Fields & Reference Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- Custom Records
- Sign In Customisation
- Automation
- Contact Support
- Releases & Roadmap
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 can Chart this View, selecting this will generate a new window.
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.