How to calculate the number of hours worked in Tableau

+1 vote

I have a fixed Number of hours(8) multiplied by the number of distinct days a user has worked.

What I want?

I need this number as text to insert into a title on a dashboard.

However, I need to separate this number by the User filter from another worksheet. When I apply this, I just get the total number of distinct days (not per user).

This is what I have done so far in the calculated field:

countd(DATETRUNC('day',[_StartDate]))

Aug 4, 2018 in Tableau by Atul
• 10,240 points
1,391 views

1 answer to this question.

0 votes

Try using this LOD expression {fixed user : countd(DATETRUNC('day',[_StartDate]))}

answered Aug 4, 2018 by ffdfd
• 5,550 points

Related Questions In Tableau

0 votes
1 answer

How can I calculate the median of sales price using 3 variables in Tableau

First let me clarify things for you. ...READ MORE

answered Apr 12, 2018 in Tableau by xyz
• 1,560 points
6,919 views
0 votes
1 answer

How to add grand totals of the bar in Stacked Bar in Tableau

Hi Grim, As you have used reference line ...READ MORE

answered Sep 24, 2018 in Tableau by Machdata
• 340 points
5,254 views
0 votes
1 answer

How to make number of equally sized bins in tableau?

You can simply right click on the ...READ MORE

answered Aug 16, 2018 in Tableau by Naruto
• 710 points
1,793 views
0 votes
1 answer

In Tableau, How to sum the last 7 days of the value?

It can be achieved easily by creating ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
17,044 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,759 views
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,534 views
+2 votes
1 answer
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
3,939 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 9, 2018 in Tableau by ffdfd
• 5,550 points
4,732 views
+2 votes
1 answer
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