8 Replies Latest reply: Jul 23, 2015 2:33 PM by Krishna Nagulapally RSS

    Set Analysis Using Available Values

    Justin Kelly

      Hi everybody,

       

      Is there a way to use set analysis (or something) on the available values in a field, not just what the user has selected? I'm trying to make a scorecard where the user will select an employee and see their productivity and compare that to everyone who has worked at that stations for the given time frame. For example, I want to select Employee1 and see how many hours that employee has logged (76). In this case, Employee1 has worked only on Station 2. I need a way to then see the hours for only Station 2 with the user necessarily selecting it.

       

      Is something like this even possible?

       

      Thanks,

       

      Justin

       

      EmployeeStationDateHours
      Employee1207/20/20154
      Employee1207/21/20154
      Employee1207/22/20158
      Employee1207/23/20154
      Employee1207/24/20154
      Employee1207/25/20158
      Employee1207/26/20155
      Employee2107/20/20156
      Employee2107/21/20155
      Employee2107/22/20154
      Employee3207/23/20158
      Employee3207/24/20157
      Employee3207/25/20155
      Employee4307/26/20155
      Employee2107/20/20156
      Employee3107/21/20157
      Employee3207/22/20157
      Employee3207/23/20157
      Employee3307/24/20158
      Employee3307/25/20158
      Employee3207/26/20155