Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

I am working on building a Tableau dashboard and just recently learned about the new Level-of-Detail calculations released in Tableau v9. The raw data is structured as follows:

User      Workflow Step      Time Spent in Workflow Step

1         a                  12

1         b                  9

1         c                  2

2         a                  7

2         b                  16

2         c                  4

3         a                  23

3         b                  1

3         c                  7

I am building a Tableau Text Table. For each user (User Dimension is placed in the Rows section) I want to display the workflow step with the maximum time spent by the user (User 1 = a, User 2 = b, etc). I am new to LoD calculations and can't figure out how to get this to work.

I have tried the following LoD calculation:

If [Time Spent in Workflow Step] = {Max([Time Spent in Workflow Step])} THEN 1 ELSE 0 END 

When I pull in workflow step as a dimension and use the calculation above as a filter (set equal to 1), I only get the single user with the longest time spent.

How do I make this calculation on a per-user level? 

1 Answer

0 votes
by (47.2k points)
  • You just need to modify your calculation in this way:

[Time Spent in Workflow Step] = { FIXED [User]: MAX([Time Spent in Workflow Step])}

  • You need to specify the actual level of detail, in this case, it is [User].

  • You do not need the IF statement additionally. The above calculation will return a Boolean result (True/False). Now, place that in the filter card and set to TRUE.

enter image description here

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.5k questions

29.9k answers


99.1k users

Browse Categories