How to calculate the number of hours worked in Tableau

Question

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]))

Answer 1

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