Knowledgebase articles
- Welcome to the Knowledge Base
- Introduction
- Our Approach to Accessibility
- Getting Started
- Preferences
- Activities
- Cases
- Introduction to Cases
- Displaying & Adding Cases
- Managing Cases
- Using the Case Portal
- Email
- Importing Data
- Leads
- Marketing
- Introduction to Marketing
- Event Management
- Compliance Records
- Force24
- Spotler Integration
- What is Spotler?
- Navigating your Spotler homepage
- Introduction to GatorMail
- GatorMail Configuration
- Sending Emails in GatorMail
- Advanced Features
- 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
- GatorPopup
- Integrations
- SFTP/FTP Processes
- Mapping
- DocuSign Functionality
- DocuSign – Worked Examples
- DocuSign – Reporting
- Adobe Sign Integration
- Zapier
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
- 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
- Survey Monkey responses to Tasks
- Multistep Zaps
- Email Integrations
- Microsoft Office
- Auditing
- Comments
- People & Organisations
- Introduction to People & Organisations
- Using Postcode Lookup
- Data Enrichment
- Reporting
- Using Reports
- Advanced Reporting
- 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
- Sagelink
- Configuration
- Contact Support
- Releases & Roadmap
Types of Split Columns
Last updated : 10th June 2022
Workbooks reporting allows you to split your results using Split Columns. When combined with Group by, you can create reports that look similar to tables you might see in other software, such as Excel.
In order to create a Split Column, you will need to create a summary view and click ‘Add value column’ -> ‘Split column’.
There are several types of Split Column to choose from:
- All Picklist values – Pulls all the possible values from the selected column and displays them regardless of any other factors.
- All values in the parent view – Pulls all the values from the parent view. This is useful for when you want to grab all the picklist values but you want to apply the criteria from the parent view to this list, thereby reducing it.
- Only valid values from the parent view – This works the same as the previous type but now also applies the criteria from this view, further reducing the number of columns in your split.
- Just these values starting with – Allows you to list the values the exact values you need. These need to be comma separated and uses the ‘Starting with’ criteria. If you were to list ‘created’ you might get both ‘created at’ and ‘created by’, so it might be worthwhile to list the full name of the column if there is any potential for overlap.
Was this content useful?