Search results: Queries/Reporting

I'm creating an 'Upcoming Absences' query to compile absences across multiple teams. It would be great to have the option to select 'all' for some filters and 'any of the filters' for others. This would save time and avoid the need for separate qu...

Currently, if you run a report on sickness in the previous month, it will not include the long term cases that have not commenced in the previous month but are still ongoing during that month. The only workaround is to complete separate queries fo...

We run monthly reports for staff off sick the previous month, but it doesn't pick up staff that have been off sick ongoing - so if their first day off was the month before the 'last month' query, they will not show on the last month report. Please...

Be able to build a filter job effective date does not equal start date or start date is less than (before) job effective date (for example) so when building queries that look at job title changes you can exclude job title updates related to a new ...

We want to be able to report on current items without manually amending a specific date field each time. We want the business to be able to pull latest data (especially current salaries excluding post dated ones) on the hotsheets without having to...

Be able to filter easily between two dates

It would be incredibly useful if you could edit the headcount turnover tool to only pull information for specific businesses. We are a group of 8 businesses, and so the tool currently pulls information for all, and we can filter on the spreadsheet...

Ability to duplicate existing built reports to easily ammend for different services/departments. Say I wanted to see DBS record for department A, and then for department B on seperate sheets. Rather than having to keep changing the filter I would ...

This will enable filtering and data sorting in chronological order. At the moment, every time I need to sort by date, I need to frist change the formatting of the whole column.

Currently when reports are marked as a favourite you have to search to view and download. I would like to be able to filter all reports and the filters to remain on, each time I pull a report I have to scroll up to the top of the page or search th...