2 Replies Latest reply on Nov 14, 2012 1:52 PM by Bob Lambert

    reference line defined as the value of a field

    Bob Lambert

      I have a calculated field, Threshold, defined as "if [type]='PCP' then 20 else 10 end".  Is there a way to have the value of this result be the axis reference line?  Data are:

      Physician,type,ytd,last_mnth

      "Dr A",PCP,50,2

      "Dr B",SCP,21,15

      "Dr C",PCP,17,4

      "Dr D",SCP,5,1

       

      In the image below I want a reference line for each pane (i.e. - each Physician).

      thx,

      Bob

      refLineDummyDataImage.JPG