4 Replies Latest reply on Feb 13, 2017 6:58 AM by Lior Gil

    Calculated field - aggregate and non-aggregate

    Lior Gil

      Hello All,

       

      for the table attached I'd like to have a Bar chart

      in the X axis - have the different department

      in the Y axis would like to have the calculate number of:

      amount of people per department * working hours

      for example - for department A the following calculation is required = 1*1 + 1*0.8 = 1.8

        

      DepartmentWorker_Nameworking_hours
      APO1
      BKZ0.75
      CVB0.60
      DDC0.25
      ESY0.10
      ART0.80
      BLQ0.90
      CEM0.50

       

      to calculate sum of people per department I use: COUNTD(Worker_Name)

      but when I try to multiply it with working_hours

      tableau return an errors says : cannot mix aggregate and non-aggregate

       

       

      How can calculated in a way tableau will understand?

       

       

      Thanks in advanced,

      Lior