Reports/Queries/Data

Find out how to extract your data from People® in various forma

Abbi Melville avatar Sheldon Walker avatar Jason Sturman avatar +1
41 articles in this collection
Written by Abbi Melville, Sheldon Walker, Jason Sturman and 1 other

Queries - Goals

Can I print Goals?
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Deleted documents

Build a report on deleted documents
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Late Report

Build a report on who has been late over a specific time period
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Reports - Staff Turnover

Discover the true level (and cost) of your company's staff turnover rate.
Sheldon Walker avatar
Written by Sheldon Walker
Updated over a week ago

Queries - Thanks

Build a report on thanks badges
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Edit Access Rights

Build a report on who had edit access rights
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Performance

Build a report on performance reviews
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Training

Build a report on training records
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Report on who hasn't opened their Performance Review.

Use V Lookup in Excel to see who has not yet started their Performance Review
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Documents

Build a report on documents added, signed etc.
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Reports - Top Facts About Our Company

Check out what the overall picture of your company looks like right now
Sheldon Walker avatar
Written by Sheldon Walker
Updated over a week ago

Queries - Leavers

Build a report on leavers
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Assignments

Build a report on Project Assignments
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Other Events

Build a report on other events
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Sickness

Build a report on Sickness
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Holidays

Build a report on employee holidays
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

People® Queries and Excel Power Bi

Load Query Data Into Excel via Power Bi
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Annual Leave Entitlement

Build a report on employee's yearly, remaining entitlement and carryover
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Timesheets

Build a report on your employee's clock in and out information
Abbi Melville avatar
Written by Abbi Melville
Updated this week

Queries - ATS Reports

Build a query on Applicant/Vacancy information
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Google Hotsheets

Sync up to 10 queries on GoogleSheets and share externally
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Build an Expense Report

Creating an expense report, exporting and printing.
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Reports

Reports overview, viewing access etc.
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Report Designer - Charts/Graphs

(Admin Only) Adding charts and graphs to your customised report.
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Report Designer - How to Create a Custom Report

(Admin Only) Create your own bright report with images and data chosen specifically by you.
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Holiday Entitlement Accrued To Date

(Admin Only) Build a report on how many days/hours entitlement pro rata.
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Historical Salary Report

Build a query on all salary changes
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - How to Create a Query

(Admin Only)
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Queries - Filters and Options

(Admin Only) An in-depth view of filters and options for creating queries
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Queries - Creating Charts

(Admin Only) Video and description detailing how to create charts within the query builder
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

(Video) Queries - Payroll extract example

(Admin Only) Learn how to build a quick query that shows changes for payroll.
Sat Sindhar avatar
Written by Sat Sindhar
Updated over a week ago

Create a Consolidated Timesheet Report in Excel

Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Printing Reports from Safari or Google Chrome

Details how to print a report opened in your safari or chrome browser
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Queries - Point in Time Head Count Report

Report on the employees in the company at a specific time
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Queries - Historical Changes Report

Build a query on changes made to an employee's record
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Opening Query Builder Files in Excel

(Admin Only) Guidance on query building files imported to Microsoft Excel
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Queries - Login Audit Report

Build a query that tells you when each employee has logged in to the system
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Indirect Reports

Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

(Video) Queries - Exporting expense claims for accounts

(Admin Only) Learn how to export expense claims from query builder for your accounting system.
Sat Sindhar avatar
Written by Sat Sindhar
Updated over a week ago

Queries - Filter by a Specific Time Frame

Using the 'Greater than' and 'Less than' options to report on information within a chosen point in time.
Abbi Melville avatar
Written by Abbi Melville
Updated over a week ago

Printing Individual Holiday and Absence Reports

How to print reports based on an employees holiday or absence
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago