4 Replies Latest reply: Sep 4, 2014 5:21 AM by Gysbert Wassenaar RSS

    Calculation in Expression outside the selection

      Hi.,

       

      I have a problem where I want to show the allocation of resource based on the project they are assigned to

      My dataset contains a list of project, component, status and assignee

      I have also got another sheet which breakdown the timing for each component per status

      Another sheet has total availability for assignee/resource

      Ex:

      Projects

      ComponentStatusAssigneeProject Key
      ABCOpenUser 1111
      ABCTestUser 1112
      XYZOpenUser 2113
      XXXTestUser 1114

       

      Duration:

      ComponentStatusDuration(in days)
      ABCOpen1
      ABCTest2
      ABCImplement1
      XYZOpen1
      XYZTest2
      XYZImplement3
      XXXOpen1
      XXXTest1
      XXXImplement1

      Capacity:

      AssigneeCapacity(in days)
      User 12
      User 22

       

      Based on the above dataset, I want to show a bar chart per user -

      User 1 -

      Capacity:2

      Allocation:

           Component: ABC - Status: Open count 1 = Duration =1 --> 1*1=1 day

           Component: ABC - Status: Test count 1 = Duration 2 --> 1*2 = 2 days

           Component: XYZ - Status: Open count 1 = Duration 1--> 1*1 = 1 day

       

      So total capacity = 2 and Allocation = 4

      The bar chart should have these two as expression