11 Replies Latest reply on Apr 29, 2018 6:00 PM by Okechukwu Ossai

    Change Measures based on conditions

    NAYANA MADHEKAR

      Hello,

       

      Firstly I'd like to thank you for all the help earlier.. Your responses really make things easier for me & It motivates me to work even more on Tableau & is a great learning platform.

       

      So currently I am facing a dilemma in Tableau-

      1. I have one data set with employee information and the hours he has worked on a specific project.

      2. I have another data set with Project Start Date and End Date.

       

      I need to calculate hours worked.. but only in that 'Project Date Range'

      For example:

      For all the hours worked.. When I calculate for hours worked under Project A: it should only calculate for hours built between that date range.

      1.PNG

      The end result.. for Project A(project date range 1/1/2017-1/1/2018) : Hours worked should only be 6+7+5 .... and it should ignore the hours built in year 2015,2016. (not in that date range).. Also the project date range is different for different projects.. Therefore I just cannot put a filter for each project respectively.. It has to be a calculation with some conditions i guess..

       

      Please refer the workbook for you reference..

      Also please let me know if anything else is needed from my end.

       

      Thank you.