This content has been marked as final. Show 2 replies
Hello Zhou,1 person found this helpful
I believe that you want to view the users that have logged into the system in the present week. This is my understanding of the requirement.
Please do the following:
1. Create a report in the Usage Tracking Subject Area.
2. Pull up the fields in the report that you want to display.
3. Please pull the last sign id field in the last.
4. Apply the formula, WEEK_OF_YEAR(Employee."Last Sign-in") in the column function (fx part)
5. After the function has been applied then apply the filter on the same column. The filter should be applied as SQL Expression, and the value in the expression should be WEEK_OF_YEAR(NOW()). In case you are finding difficulties to apply SQL Expression, please send an email to firstname.lastname@example.org and I would help you with screen shots.
6. You can hide the last column
You will get the report on users who have logged in the present week.
Let me know if this works or you still are facing issues.
Paul, thanks for your reply. We have a KPI for users that the user at least logins to system 4 days a week(7days). not 4 times; use this to track if the user update/create data in time. so the ideal report looks like the following;
user_name, week1, week2, week3, week4.
aaaa, 5days, 4 days, 3days, 1 days;
bbbb, 2days, 4days, 3days, 2days;
we will run this report at the end of month ir the early next month to see the last month logins;