How to create a dynamic filter to find logged time for the currently logged-in user using the Reports and Timesheets app.

Owned by Priyal Jaiswal, created
Last updated: Sept 28, 2023 by Amith Mathur
2 min read

This article helps to display a report to find logged time for the currently logged-in user in the bar chart view.

 Instructions

How to create a Calculated Field to find the currently logged-in user

  1. Navigate to My Area > My calculated Fields > Create New Field.



     

  2. Specify the Name and Description as per the choice.

  3. Select Category as None.

  4. Drag and drop Function → Logical → Equals().

  5. Drag and drop Field for value 1: Time entry: User AccountId.

  6. Drag and drop Function for value 2: String → LOGGED USER: AccountId().

  7. Validate the Expression.

  8. Save the calculated field.

  9. Refer to the below screenshot and GIF for the pictorial representation of the above steps:

 

How to create a dynamic filter to find logged time for the currently logged-in user

  1. Select view type as Bar Chart.

  2. Add Time entry: Date on X-Axis (Dimension) and Time Entry: Logged Time on Y-Axis (Measures).

  3. Add Filters Time Entry: User and calculated filed Is Current User.

  4. Add a rule to the field Is Current User (Is Current user equals TRUE).

     

  5. Run the report.



Â