9 Replies Latest reply: Oct 18, 2017 12:02 AM by Rajesh Thakur RSS

    dual function, avg by numeric value, display text string?

    Brayden Ashdown

      Sorry for multiple questions – I have spent a long time looking for answers to these before posting.  Thanks in advance for you time and patience.

       

      I have below a section of a larger nested if() statement that I'm using as a measure on a line graph.  What I am trying to do is to use the dual() function assign a text and numeric value to each average.  I would like to plot my graph according to the numeric value, but have the labels show the text string.  Is this possible?

       

      if(avg([Diff Value])<11.6 and avg([Diff Value])>=11.4,dual('5.11b', 11.4),

        if(avg([Diff Value])<11.8 and avg([Diff Value])>=11.6,dual('5.11c',11.6),

           if(avg([Diff Value])<12 and avg([Diff Value])>=11.8,dual('5.11d',11.8),

                dual('5.12a',12.2)

              )

            )

         )

       

      Thanks again,

       

      Brayden