I forget to add I need to know which agents were logging in/out into skill during last month to check witch agent account is active, so I need one report for all skills showing agent login/logout activity during last month.
Since you want this for all skills, you don't actually need to use SPLIT as an input.
I have an Agent Audit report:
SELECT UNIQUE haglog.LOGID, min(haglog.LOGIN), max(haglog.LOGOUT) FROM haglog Where ACD = [ACD:] GROUP BY haglog.LOGID
Depends on what components of CMS you have purchased/have access to. Assuming you have report designer access...
Commands > Report Wizard > Next >
Historicalaily > Next >
GridLayout > Next >
Agent > Agent login/Logout > No Pre-Selection > Next >
Add: Agent Name, Login Time, Logout Time > Next >
Fill Table by Row > Next >
Leave Input prompts > Next > Next > Next >
Edit Report in Report Designer > Finished >
From Report Designer, Edit > Queries > Query0 (EDIT)
Highlight LOGIN on right side panel, click edit and change to MIN(LOGIN)
Highlight LOGOUT on right side panel, click edit and change to MAX(LOGOUT)
Click WHERE
Delete the "and SPLIT = [Skill:] and ROW_DATE = [Dates:]" section from the Where panel at the bottom. Add "Group by LOGID" at the end of the where statement.
OK
Remove the Date and Skill fields from the report page.
Edit > Inputs. Remove both inputs.
Report > Save As
Report > Run (test the report).
You'll probably need to make some modifications to the date/time format in the resulting table.
Report > Design
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.