0 Replies Latest reply: Oct 9, 2012 10:26 AM by 864145 RSS

    Dial chart dynamic color range

    864145
      Hi

      I am trying to dynamically change range of the scalebar color.
      I see that I can give Apex a low and high value exactly for this reason.
          Invalid Dial chart query, use the following syntax:
      
           SELECT VALUE, MAX [, LOW, HIGH] VALUE FROM ... 
      
          VALUE      Numeric column that defines dial value.
          MAX      Numeric column that defines Maximum dial value.
          LOW (optional)      Numeric column that defines the low value of a range to display on the dial. If this value is defined, a HIGH value is required.
          HIGH (optional)      Numeric column that defines the high value of a range to display on the dial. If this value is defined, a LOW value is required.
          This query should return one row.
      I would hope for Apex to use those value in the #SCALE_DATA# in the Chart XML.
      <axis start_angle="90" sweep_angle="180" >
      #SCALE_DATA#
              <labels enabled="true" align="Inside" text_align="Near" rotation="0" >
                    <format><![CDATA[{%Value}{numDecimals:0,decimalSeparator:\,,thousandsSeparator: }%]]></format>
                <font family="Tahoma" size="10" color="#000000" />
              </labels>
      </axis>
      But it does not seems to work.

      I only need to add those lines
      <scale_bar enabled="false" />
      <color_ranges>
         <color_range start="0" end="25" color="Red" />
         <color_range start="25" end="90" color="Green" />
         <color_range start="90" end="100" color="Red" />
      </color_ranges>
      25 being the #LOW# value and 90 the #HIGH# value.

      I do not want to use custom XML everywhere.

      ANy iadea if I can modify the default XML or modify the behavior of the #SCALE_DATA# ?

      Thanks a lot

      Sebastien