Reports in the new report builder can show different numbers, rows, or column names than the legacy reports they were migrated from. This is expected. This article explains what's different, why, and how to get the result you're used to.
Find your difference
Find what you notice in the table to see the most likely reason and what to do.
| What you notice | Likely reason | What to do |
| Fewer employees or a lower headcount | The status is checked on the selected date. Limited access of the report creator can also reduce the data. | Add a timeframe filter, segment by employee status, and include the termination date column. If you still see fewer rows than in the legacy report, ask an Administrator to grant access to the missing data. |
| An employee appears under a different department, team, or position | Rows show the value from that date, not the current one. | Nothing to fix. |
| More rows than before | Time off, salary, and absence data are on separate rows. | Nothing to fix. |
| Time off types aren't in columns anymore | Each time off type is now its own row. | Filter by time off type. If you work with exports, pivot the data. |
| Duplicate rows after a transfer or name change | The attribute uses Relative to data points. | Use End of time frame instead of Relative to data points for the attribute. |
| A column has a different name | Some columns were renamed. | Update your exports and formulas to the new name. See Renamed columns. |
| Monthly numbers look different | Months show their own value, not the annual total. | Nothing to fix. The totals are the same. |
Filters work per row
The biggest difference is how filters work. The Classic Builder decided per employee. The new report builder decides per row, based on the date of that row.
| Area | Classic Builder | New report builder |
| How filters are applied | An employee is included if they matched the filter at any point in the timeframe. The report shows their current value. | A row is included only if the attribute matched the filter on that row's date. The report shows the value that matched. |
| Status equals Active | Includes everyone who was active at any point in the timeframe, including employees who left. | Includes employees who were active on the selected date. Employees who left during the timeframe aren't included automatically, so headcount can be lower. |
| Department, team, and office filters | Includes everyone who was ever in the department. The report shows their current department and all their hours. | Shows the department that matched the filter and counts only the hours worked while the employee was in it. |
| Changes before the start of the timeframe | Every change appears at its real date. | Earlier changes are combined into one starting row with a blank change date. |
Get the result you're used to
- Match the Classic Builder headcount: Add a timeframe filter, segment by employee status, and include the termination date column.
- See everyone who was ever in a department: Widen the date range or adjust the filter.
- Avoid duplicate rows after transfers or name changes: Where available, use End of time frame instead of Relative to data points for the attribute.
Values show the state on each date
Rows show the department, team, or position the employee had on that date, not their current one. If an employee changed department during the timeframe, they can appear in more than one row. For more on how this works, see Troubleshoot report data issues and understand point in time reporting.
Layout and calculation changes
- Time off: Each time off type appears as its own row instead of its own column. You can also filter by time off type. If you work with exports, you may need to pivot the data.
- Salary and absence data: They appear on separate rows, so reports have more rows than before.
- Monthly values: Each month shows that month's value instead of the annual total repeated on every row. The totals are the same.
- FTE salary: It's always calculated as paid salary divided by the employment percentage. It can be higher for part-time employees than in the Classic Builder.
Renamed columns
Some columns have new names. If you use exports or formulas that refer to the old names, update them.
| Classic Builder | New report builder |
| Effective Salary | Gross Salary (per currency) |
| Fixed Salary | Gross Salary FT |
| Hours Worked | Attendance Hours Tracked (with a status) |
For a full comparison of the attributes available in each builder, see Summary of attributes available for reporting.
Limits
The new report builder supports a maximum of 100 columns. You can't open reports with more than 100 columns in the platform. You can still export them from the report list.
Get help
If a difference isn't listed here, or you can't get the result you expect, contact our Support team and include the legacy report and the migrated report. For general report data issues, see Troubleshoot report data issues and understand point in time reporting. For the comparison steps, see The transition to the new report builder.