3 Replies Latest reply on Aug 23, 2018 2:58 AM by an.dy

    Find MIN and MAX for the date of particular resource on particular project to show in Tooltip

    an.dy

      Hello!

       

      I have a visualization of employee assignments to the projects (attached).

       

      I need to show in a Tooltip (on mouse over the colored box) date of fist book of this employee to the project and date of last book as well.

       

      In excel I need to find MIN/MAX of column (dimension) START in relation to the particular employee and particular project.

       

      For example, Start date for resource "Name7" on project "Name5" would be 9th of July, and End date would be 26th of August. And it should be shown in tooltip in each of the "green" days of this project/resource.

       

      How can I do it in Tableau?

       

      Thanks!

       

      Capture2.JPG