Queries/Reporting

In our annual report and other MI reporting, we are asked to report on the avg LOS. We currently have to run the report then manually work it out.

Please can queries extract into excel/csv in the column order that you sort it on PeopleHR. It is really annoying when doing reports that you have to sort the columns in the order you need them outside the system. It would be so much easier to be ...

building hot sheets etc

Would be good to be able to run a query where you can clearly see how attrition rate is calculated and run for the last day of each month.

It would be really handy if the results of a query at any given time could be exported to Excel automatically and that report then sent in an email via ripple.

I want to be able to run a query that shows the hours absent each day, not the total for the absence. As an example, if someone is absent from 10 to 14 February, I'd like to see a line of data with the number of hours for each day (Monday 10th - 7...

Need to do a report on FTE and have been told this isn't possible. Would be great to have custom date range as an option for any query

Add the other events according to leave / working other events to the impact insights in the email sent for approval, event if all the employees only on Other events and no-one is on holiday.

Given that our calculations are based on hourly metrics, having the capability to generate a report displaying the hourly cost of absences would be highly advantageous.

If an employee is sick during a public holiday (ie they are subscribed to a public holiday pattern) the sick report does not pull through accurately as it does not take into account the public holiday as it sees it as a non-working day. This is no...