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.