How does the 'Employee Hour Balances' dashboard work?
General Function
The Employee Hour Balances dashboard displays all hour balances of your employees and all registered hours of the active fiscal year. You can adjust the displayed data by filtering on department/employee and/or period.
Target Audience
- Controllers
- Management
Where in MKG?
- Open the module My Company.
- If the dashboard is not shown immediately: click the hamburger menu at the top right of the toolbar and select the option 'Forms' » 'Dashboard'.
- Click the Views button and select Employee Hour Balances (8012).
Main Components
- Overview of total hour balances per employee.
- Analysis of the composition of hour balances per operation.
- Insight into opening balance, overtime, undertime, and corrections.
- Filters on period, department, and employee.
- Comparison of totals and underlying changes.
Display and Usage
The selected fiscal year is displayed at the top. Additionally, you can filter by period, department, and employee. The dashboard contains an overview of total hour balances per employee and a detailed view showing the composition of these balances per operation. This allows you to quickly see how an employee's hour balance is composed.
Technical Explanation
Primary Data Source
- Hour Balance (
t_employee_hours_balance)
Indirectly Consulted Data Sources
- Employees (
medw), Departments (afdl), Operations (bwrk), Periods (peri)
Dashboard Filters
- Filter on period via calculated field
Period. - Filter on department via calculated field
Department. - Filter on employee via field
_desc_medw_num. - The period selection shows only values for which
Periodis not empty.
Calculated Fields
Spacer: used as a separator field in the pivot table view.
Calculation: contains an empty text value.Department: shows the employee's department.
Calculation: usesmedw_num.afdl_num.afdl_naamand shows a default text when no department is present.Period: shows the period description.
Calculation: usesperi_omsand shows "Year corrections" whenperi_num= 14.Operation: determines the sort order of operations.
Calculation: uses the absolute value ofbwrk_num.MKGDataDashboardTitle: contains a dashboard title.
Calculation: contains an empty text value.
Adding to 'My Dashboards'
Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. This way, you create your own cockpit from the data in your database. How to add dashboards is explained in How to set up 'My Dashboards'
- Published:29 Oct 2026 14:48
- Latest update:29 Oct 2026 15:48
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar