1 Reply Latest reply: Aug 10, 2018 12:15 PM by Sunny Talwar RSS

    Show Average Productivity from Empoyees

    Le-Hao Nguyen

      Hi Qlik-Community,

       

      i got stuck on a Problem several hours now and cant find a way to solve it. I got a table like this:

      UserIdWorkingDurationWorkDateType AType B
      107:00:002018-01-01990
      208:12:002018-01-01054
      17:49:002018-01-021190
      306:31:002018-02-02061
      45:41:002018-02-01570
      39:01:012018-03-02074

      Type A and Type B are two products some workers create Type A's and some create Type B's now i want to calculate the productivity of each Type. The Workers with UserId 1 and 4 work on Type A so the productivity is their Workduration/sum of TypeA.

      The Workers with UserId 2 and 3 are working on Type B so their Productivity is their Workduration/sum of Type B.

      Now i want to create a KPI for the Productivity of Type A and but when i do SUM(TypeA)/Sum(WorkDuration) i always get the Workingdurations from user 2 and 3 in it as well so it doesnt show the right productivity of the Type A. Any elegant solutions to fix it?