Login - Logout time

0 votes
Hi, I want to find the time worked by teachers on a daily basis and average working hours per teachers. I have logged out and login information of multiple teachers along with their id in different sheet in excel file.

Can someone help?
Apr 25 in Tableau by Banu
15 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi Banu,

1. First, join both the sheets using ID field.
2. Drag and drop the Id field into sheet.
3. Create a calculated field as below
    difference =
    IF Table1.[ID] = Table2.[ID] THEN LAST(logout) - FIRST(login)
    END

4. Now Click Ok.
5. Drop the calculated field into the shelf next to it, log in and logout field to observe the difference.
6. To get the average time for every teacher, calculate the average of the created field for a month.

Hope it helps you.
answered Apr 25 by CHERUKURI
• 13,940 points

Related Questions In Tableau

0 votes
1 answer

Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

answered Apr 11, 2018 in Tableau by QueenBee
• 1,810 points
13 views
+1 vote
1 answer

Creating a Gantt Chart over time with summed bar

The trick with Gantt charts in Tableau ...READ MORE

answered Jul 20, 2018 in Tableau by Atul
• 10,200 points
28 views
+1 vote
1 answer

How can I find the time difference between two columns

Based on the data you showed, I'm ...READ MORE

answered Jul 24, 2018 in Tableau by Atul
• 10,200 points
22 views
0 votes
1 answer
0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
27 views
0 votes
1 answer

How can I convert week into Date(mm/dd/yyyy)?

Right click on your date field, you'll ...READ MORE

answered Aug 9, 2018 in Tableau by Atul
• 10,200 points
51 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 830 points
29 views
0 votes
1 answer

How to merge Year ,Month and date in Order Date in Tableau?

Hi, you can simply drag the Order ...READ MORE

answered Aug 24, 2018 in Tableau by AwesomeSauce
• 830 points
46 views
0 votes
1 answer

Split date and time from datetime field.

Hi,  Follow these steps to divide field into ...READ MORE

answered Apr 1 in Tableau by CHERUKURI
• 13,940 points
52 views
0 votes
1 answer

How to calculate work done for a given date or period of time?

Hi, Follow these steps: As per you question since ...READ MORE

answered Apr 1 in Tableau by CHERUKURI
• 13,940 points
10 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.