Only Owner can manage custom report columns.

• You can easily customize report items using our provided report columns and apply the formula you want.
  
• You can easily check your custom report columns in the report.

---

Web

Set Up Custom Report Columns

To set up custom report columns, go to Company Settings - Report and enable the ‘Use Custom Report Columns Feature’ option. Then, click the Manage Custom Report Columns button at the bottom.

You can create your own report formulas to set up custom report columns, which can be viewed in the report page.

Manage Custom Report Columns

You can customize your own report columns using the report items we provide.
Please refer to the help below to add and manage custom report columns.

• Name : Enter a name for your custom column.
  
• Description : Enter a description of your column.
  
• Formula : Enter a formula to calculate the item. For detailed instructions on how to write formulas, refer to the table below.
  
• Shift Type : Choose whether to calculate for ‘all shift types’ or only for ‘specific shift types’ when aggregating this custom report column.
  
• Platforms : Select the platforms where this column can be viewed.

Writing Formulas for Custom Columns

You can write formulas for your custom report columns by referring to the input values below for each report item.
For example:

• Calculate by combining report columns : ( Contractual working days - Worked days ) * 8 + Worked Paid Hours
  

➔ ( contractual_working_days - worked_days ) * 8 + worked_paid_hours

• Include time in report columns : Paid leave hours + 3hrs
  

➔ paid_leave_hours + 180

• Writing formulas using ‘custom column’ you have created : (as the image above) ‘enter the name of the custom column’ + desired formula
  

➔ WorkFromHome + 30

Report Column Input Value

Report Column	Input Value
Contractual Working Days	contractual_working_days
Scheduled Days	scheduled_days
Worked Days	worked_days
Paid Leave Days	paid_leave_days
Contractual Working Hours	contractual_working_hours
Scheduled Hours	scheduled_hours
Scheduled Paid Hours	scheduled_paid_hours
Worked Hours	worked_hours
Worked Paid Hours	worked_paid_hours
Standardized Hours	standardized_hours
Paid Leave Hours	paid_leave_hours
Average Scheduled Hours Per Day	average_scheduled_hours_per_day
Average Worked Hours Per Day	average_worked_hours_per_day
Average Scheduled Paid Hours Per Day	average_scheduled_paid_hours_per_day
Average Scheduled Hours Per Week	average_scheduled_hours_per_week
Average Worked Hours Per Week	average_worked_hours_per_week
Average Scheduled Paid Hours Per Week	average_scheduled_paid_hours_per_week
Average Worked Paid Hours Per Week	average_worked_paid_hours_per_week
Scheduled Overtime Hours	scheduled_overtime_hours
Worked Overtime Hours	worked_overtime_hours
Standardized Overtime Hours	standardized_overtime_hours
Scheduled Overtime Paid Hours	scheduled_overtime_paid_hours
Worked Overtime Paid Hours	worked_overtime_paid_hours
Scheduled Remaining Hours	scheduled_remaining_hours
Worked Remaining Hours	worked_remaining_hours
Scheduled Remaining Paid Hours	scheduled_remaining_paid_hours
Worked Remaining Paid Hours	worked_remaining_paid_hours
Scheduled Remaining Maximum Overtime Hours	scheduled_remaining_maximum_overtime_hours
Worked Remaining Maximum Overtime Hours	worked_remaining_maximum_overtime_hours
Scheduled Remaining Maximum Overtime Paid Hours	scheduled_remaining_maximum_overtime_paid_hours
Worked Remaining Maximum Overtime Paid Hours	worked_remaining_maximum_overtime_paid_hours
Scheduled Overtime Hours Per Day	scheduled_overtime_hours_per_day
Scheduled Overtime Paid Hours Per Day	scheduled_overtime_paid_hours_per_day
Scheduled Weekday Overtime Hours	scheduled_weekday_overtime_hours
Scheduled Weekday Overtime Paid Hours	scheduled_weekday_overtime_paid_hours
Scheduled Offday Overtime Hours Per Day	scheduled_offday_overtime_hours_per_day
Scheduled Offday Overtime Paid Hours Per Day	scheduled_offday_overtime_paid_hours_per_day
Scheduled Holiday Overtime Hours	scheduled_holiday_overtime_hours
Scheduled Holiday Overtime Hours	scheduled_holiday_overtime_hours
Scheduled Overtime Shift Hours	scheduled_overtime_shift_hours
Scheduled Weekday Overtime Shift Hours	scheduled_weekday_overtime_shift_hours
Scheduled Offday Overtime Shift Hours	scheduled_offday_overtime_shift_hours
Scheduled Holiday Overtime Shift Hours	scheduled_holiday_overtime_shift_hours
Scheduled Weekday Non Premium Overtime Hours	scheduled_weekday_non_premium_overtime_hours
Scheduled Weekday Premium Overtime Hours	scheduled_weekday_premium_overtime_hours
Scheduled Weekday Non Premium Overtime Paid Hours	scheduled_weekday_non_premium_overtime_paid_hours
Scheduled Weekday Premium Overtime Paid Hours	scheduled_weekday_premium_overtime_paid_hours
Scheduled Night Hours	scheduled_night_hours
Worked Night Hours	worked_night_hours
Standardized Night Hours	standardized_night_hours
Scheduled Weekday Night Hours Per Day	scheduled_weekday_night_hours_per_day
Scheduled Weekday Night Paid Hours Per Day	scheduled_weekday_night_paid_hours_per_day
Scheduled Offday Night Hours Per Day	scheduled_offday_night_hours_per_day
Scheduled Offday Night Paid Hours Per Day	scheduled_offday_night_paid_hours_per_day
Scheduled Holiday Night Hours Per Day	scheduled_holiday_night_hours_per_day
Scheduled Holiday Night Paid Hours Per Day	scheduled_holiday_night_paid_hours_per_day
Scheduled Holiday Hours	scheduled_holiday_hours
Worked Holiday Hours	worked_holiday_hours
Standardized Holiday Hours	standardized_holiday_hours
Scheduled Additional Working Hours	scheduled_additional_working_hours
Worked Additional Working Hours	worked_additional_working_hours
Scheduled Additional Working Paid Hours	scheduled_additional_working_paid_hours
Scheduled Additional Working Hours Per Day	scheduled_additional_working_hours_per_day
Scheduled Remaining Maximum Working Hours	scheduled_remaining_maximum_working_hours
Worked Remaining Maximum Working Hours	worked_remaining_maximum_working_hours
Scheduled Remaining Maximum Working Paid Hours	scheduled_remaining_maximum_working_paid_hours
Worked Remaining Maximum Working Paid Hours	worked_remaining_maximum_working_paid_hours
Deemed Working Days	deemed_working_days
Deemed Working Hours	deemed_working_hours
Leave Days	leave_days
Leave Deducted Days	leave_deducted_days
Tardiness Days	tardiness_days
Early Clock Out Days	early_clock_out_days
Absence Days	absence_days
Missing Clock Out Days	missing_clock_out_days
Report Days	report_days

View Custom Report Columns

You can view saved custom report column directly from the report menu.
Easily check and manage spcific data using the custom report column feature.