2 Replies Latest reply on Jul 19, 2016 1:26 PM by Derrick Austin

    hrs used

    tableau gstl

      Hi All,

       

      I am facing the below issue

       

      For a week any user who has hours used greater than 40 and the status as WD we need to count them

      and in the same condition we need to check for user having status as HD and hours greater than 20

       

      Currently I was able to convert the hrsused field to mins

       

      Mins

      (DATEPART('hour',[HRS USED]) * 3600 + DATEPART('minute',[HRS USED])*60)/60

       

      To know usage in a week for user with usage > than 40 hrs

       

      sum of user mins in a week greater

      if  sum([Mins]) > 2400 THEN

      1 else 0 END

       

      I am not able to add the condition status as it is giving agg and disagg error

       

      if [Status] = "WD" and sum([Mins]) >2400  or [Status] = "HD" and sum([Mins]) >1200

      then 1 else 0

      END

       

      Also can i show only user name and the usage details in the view using LOD

       

      Thank in advance