How to find total number of records assigned to user on a particular day

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sujithraalink
    Member
    • Oct 2018
    • 94

    How to find total number of records assigned to user on a particular day

    How to find total number of records assigned to user on a particular day. Please help me to resolve the issue.







  • Maximus
    Senior Member
    • Nov 2018
    • 2731

    #2
    Hello.
    If you want to count all records assigned to a user on a particular day you should:
    1. Create a new field in the demanded entity of a Date type (e.g. assignDate);
    2. Add this formula: ifThen(entity\isAttributeChanged('assignedUserId') , assignDate = datetime\today());
    3. Create a report of a grid type where set GROUP BY -> Assigned User, DAY: AssignDate; COLUMNS -> COUNT
    Last edited by Maximus; 05-09-2019, 09:32 AM.

    Comment

    Working...