4 Replies Latest reply: Feb 6, 2018 3:16 AM by Stefan Wühl RSS

    Aggr Dual as Dimension

    Cassandra Baqir

      I am trying to stratify vBuildResourceCount into buckets using:

       

      =Aggr(
      If(count(vBuildResourceCount) = 0, Dual(0, 0),
      If(count(vBuildResourceCount) = 1, Dual('1', 1),
      If(count(vBuildResourceCount) = 2, Dual('2-3', 2),
      If(count(vBuildResourceCount)< 5, Dual('4-5', 4),
      If(count(vBuildResourceCount) > 5  Dual('5 or more', 5)))))),
      DEFECT_ID)

      Clearly Jan 2018 has some in  with Build resource count of 1, 2 o3 3 but I only see a bar for 2-3? Help! What's wrong with my Dual statement?

      2-5-2018 12-22-33 PM.jpg