1 Reply Latest reply on Aug 6, 2014 5:56 AM by pooja.gandhi

    How to get a line Chart for a Calculated field

    vijaykumar.h

      Hello all,

       

      I have a Calculated field "bucket_tnrx " like this

       

      IF SUM([T Pts])>=1 and SUM([Transaction Points])<=500 then "1-501 Tnx "

      elseif SUM([T Pts])>=501 and SUM([Transaction Points])<=1000 then "501-1000 Trnx "

      elseif SUM([T Pts])>=1001 and SUM([Transaction Points])<=5000 then "1001-5000 Trnx "

      else ">5k Pts"

      end

       

      When i drag this calculated field to color i get like this

       

      111.PNG

      How do i change my calculated field so that i get different lines(not in one line)

       

      Thanks.