Timesheet widget for Multilevel View
KB Article #:
99068
Summary:
Timesheet widget for Multilevel View
Description:
How can users see time sheets through a multilevel view widget?
Resolution:
Follow this steps to create a widget with the desired information.
In Ajera:
  1. Enter Edit Mode through the Hammer and Wrench symbol
  2. Select the dashboard where the widget will be seen
  3. Select Add Widget
  4. Select Table
  5. Choose Timesheet base
  6. Click OK
  7. Add necessary columns such as:
    • Employee and Timesheet Date.
  8. Select Add Formula:
    • Then copy the following into the Formula box:
      Select EmpSupervisor From Employee where empkey = [Supervisor Key]
  9. Add another formula with the following: 
    Case when [Supervisor Key] = {CurrentUser} Then 1 
    When [Formula] = {CurrentUser} Then 1 
    End
  10. Click OK to bring the columns into the widget
  11. Under Add Columns: 
    • Select the second formula
  12. Under Filters:
    • set the Operator to =Equal and the Value to 1
  13. Hide both formula columns by clicking the Eye symbol 
 
Note: These formulas can be added to an existing timesheet based widget, remove any filters for Current User from the Employee Key column. 
 
Details  
 
To view full details, log in with your Deltek Support Center account.
Print