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, 2019 in Tableau by Banu
679 views

1 answer to this question.

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, 2019 by Cherukuri
• 33,010 points

Related Questions In Tableau

0 votes
1 answer
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 12, 2018 in Tableau by QueenBee
• 1,820 points
241 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 21, 2018 in Tableau by Atul
• 10,230 points
353 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 25, 2018 in Tableau by Atul
• 10,230 points
359 views
0 votes
1 answer

How to create a filter based on date range?

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

answered Aug 8, 2018 in Tableau by Nitish
• 630 points
388 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 10, 2018 in Tableau by Atul
• 10,230 points
870 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 15, 2018 in Tableau by AwesomeSauce
• 860 points
783 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
• 860 points
1,279 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, 2019 in Tableau by Cherukuri
• 33,010 points
11,460 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, 2019 in Tableau by Cherukuri
• 33,010 points
231 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP