Forum Discussion
Need Formula Help
I have a table of phone activity for agents that I need to create charts from. I have another table for a chart to extract Log In and Log Out times for each day. I don't know what formula to use th...
Attached is a sample of the report, if I attach the whole thing it will be too big. I am trying to pull each agent into their own table so I can track what time they log in and out, among other things. I am having a hard time getting a formula to work to pull the time Agent 1 logged in the first time in the morning, and logged out at night each day.
Below is a sample of a table for one agent I am trying to put together so I can build charts for their dashboard.
You can use GROUPBY to aggregate the data:
=GROUPBY(DemoTbl,,,,0,,(DemoTbl[S]="S/In")+(DemoTbl[S]="S/Out"))
