How to find the minimum value in tableau?

5.4k views Asked by At

How to find the minimum value, and display one employee?

enter image description here

ID         | employee  | MIN
-----------+-----------+--------------------
IM32837253 | employee1 | 10.11.2016 20:48:40
           | employee2 | 10.11.2016 20:10:40

I want to achieve that the result displays the following

ID, employee, min (time)
IM32837253, employee2, 10.11.2016 20:10:40
1

There are 1 answers

0
Fabio Fantoni On BEST ANSWER

First of all you should consider that Dates are recognized as dimensions.

That being said, to get the minimum value for a certain combination of dimensions (all in the row shelf), you just right click your date field then click measure and then minimum.

Take a look at the example using the superstore dataset with Order date as your time field.

enter image description here