Trying to make an internal time card and am stuck on reporting
I have an internal timecard with SSO authentication. The survey has 1 question asking if they are clocking in or clocking out. I need the report to have a table with columns for name, whether they clocked in or out, and the date and time the response was recorded. I am having issues creating a report like this. Recorded date only wants to display the date without the time. Additionally the report wants to group responses with the same name together, but I would like to keep them separate. Any ideas for how to accomplish this?
+1
You will probably have to download the data and use a third party tool to do the reports. If you have API, you could implement the whole thing in a tool like R. Then you can parse the data so that a true weekly time card can be constructed per user.
Leave a Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.