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
1,400 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,030 points

Related Questions In Tableau

0 votes
1 answer

How do I add a custom login and logout page in my Tableau Server on-prem?

I don't believe it is "officially" possible ...READ MORE

answered Mar 4, 2022 in Tableau by Neha
• 9,060 points
716 views
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
992 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,240 points
894 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,240 points
1,130 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
938 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,240 points
1,441 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
1,614 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
2,688 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,030 points
14,457 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,030 points
943 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP