14 Replies Latest reply on Jun 21, 2016 12:17 PM by zibal jafri

    Use Table data to create new Calculated Fileds

    zibal jafri

      Hello Everyone,

       

      I have three fields Name, Category and Hours. I have created a table in tableau as shown below:

       

       

      Now I want to create Calculated Fields showing how many productive hours have been spent over each category using formula as below:

       

      For eg,  I want a calculated filed "Eating Percent time" for Chris, Formula :   Eating/ (Total Time - DO Nothing) ===> 3/(25-1)==>3/24===>1/8 or 0.125.

       

      And if I want to know "Do Nothing Percent Time" for Chris, Formula : DO Nothing/Total Time====>1/25===>.04

       

      Can anyone please help me with this ? I am also attaching my file.

       

      Regards,

      Zibal