10 Replies Latest reply: Mar 3, 2016 10:47 AM by Cassandra Baqir RSS

    Dual Replace Class Labels

    Cassandra Baqir

      My current dimension is:

       

      =Dual(If(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),
      If(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))

      and it gives me these labels:

      3-3-2016 7-44-23 AM.jpg

       

      My customer wants the labels to display (and then sort the same way) more simply:

       

      <60

      60-120

      >120

       

      I've been playing with the Dual Replace function in the dimension but can't get it to work correctly.

       

      Thanks.