Apex Flash Chart Tooltip Madness

You can include a lot of data in Apex 4 chart tooltips. Want to know what data items are available?

Cut and paste the keywords below into your tooltip’s CDATA tag and see what comes back.

Tooltip based on the scott emp table.

Code to paste in the the Custom XML of the Apex Chart:

[sourcecode language=”xml”]
<tooltip_settings enabled="true" >
<format><![CDATA[
Point Keywords:
YValue {%YValue} YPercentOfCategory {%YPercentOfCategory} YPercentOfSeries {%YPercentOfSeries} YPercentOfTotal {%YPercentOfTotal}
High {%High} Low {%Low} Open {%Open} Close {%Close} XValue {%XValue} XPercentOfSeries {%XPercentOfSeries}
XPercentOfTotal {%XPercentOfTotal} BubbleSize {%BubbleSize} BubbleSizePercentOfCategory {%BubbleSizePercentOfCategory}
BubbleSizePercentOfSeries {%BubbleSizePercentOfSeries} BubbleSizePercentOfTotal {%BubbleSizePercentOfTotal}
Index {%Index} RangeStart {%RangeStart} RangeEnd {%RangeEnd}

Series Keywords
SeriesName: {%SeriesName} SeriesFirstXValue: {%SeriesFirstXValue} SeriesFirstYValue: {%SeriesFirstYValue} SeriesLastXValue: {%SeriesLastXValue} SeriesLastYValue: {%SeriesLastYValue}
SeriesYSum: {%SeriesYSum} SeriesXSum: {%SeriesXSum} SeriesBubbleSizeSum: {%SeriesBubbleSizeSum} SeriesYMax: {%SeriesYMax} SeriesYMin: {%SeriesYMin}
SeriesXMax: {%SeriesXMax} SeriesXMin: {%SeriesXMin} SeriesBubbleMaxSize: {%SeriesBubbleMaxSize} SeriesBubbleMinSize: {%SeriesBubbleMinSize}
SeriesYAverage: {%SeriesYAverage} SeriesXAverage: {%SeriesXAverage} SeriesBubbleSizeAverage: {%SeriesBubbleSizeAverage} SeriesYMedian: {%SeriesYMedian}
SeriesXMedian: {%SeriesXMedian} SeriesBubbleSizeMedian: {%SeriesBubbleSizeMedian} SeriesYMode: {%SeriesYMode} SeriesXMode: {%SeriesXMode}
SeriesBubbleSizeMode: {%SeriesBubbleSizeMode} SeriesPointCount: {%SeriesPointCount} SeriesYAxisName: {%SeriesYAxisName} SeriesXAxisName: {%SeriesXAxisName}
SeriesYRangeMax: {%SeriesYRangeMax} SeriesYRangeMin: {%SeriesYRangeMin} SeriesYRangeSum: {%SeriesYRangeSum}
Category
CategoryYPercentOfTotal: {%CategoryYPercentOfTotal} CategoryYSum: {%CategoryYSum} CategoryYAverage: {%CategoryYAverage} CategoryYMedian: {%CategoryYMedian}
CategoryYMode: {%CategoryYMode} CategoryName: {%CategoryName} CategoryYRangeMax: {%CategoryYRangeMax} CategoryYRangeMin: {%CategoryYRangeMin} CategoryYRangeSum: {%CategoryYRangeSum}

Data Plot
DataPlotYSum: {%DataPlotYSum} DataPlotXSum: {%DataPlotXSum} DataPlotBubbleSizeSum: {%DataPlotBubbleSizeSum} DataPlotYMax: {%DataPlotYMax}
DataPlotYMin: {%DataPlotYMin} DataPlotXMax: {%DataPlotXMax} DataPlotXMin: {%DataPlotXMin} DataPlotBubbleMaxSize: {%DataPlotBubbleMaxSize} DataPlotBubbleMinSize: {%DataPlotBubbleMinSize}
DataPlotXAverage: {%DataPlotXAverage} DataPlotYAverage: {%DataPlotYAverage} DataPlotBubbleSizeAverage: {%DataPlotBubbleSizeAverage} DataPlotMaxYValuePointName: {%DataPlotMaxYValuePointName} DataPlotMinYValuePointName: {%DataPlotMinYValuePointName}
DataPlotMaxYValuePointSeriesName: {%DataPlotMaxYValuePointSeriesName} DataPlotMinYValuePointSeriesName: {%DataPlotMinYValuePointSeriesName} DataPlotMaxYSumSeriesName: {%DataPlotMaxYSumSeriesName} DataPlotMinYSumSeriesName: {%DataPlotMinYSumSeriesName}
DataPlotYRangeMax: {%DataPlotYRangeMax} DataPlotYRangeMin: {%DataPlotYRangeMin} DataPlotYRangeSum: {%DataPlotYRangeSum} DataPlotPointCount: {%DataPlotPointCount} DataPlotSeriesCount: {%DataPlotSeriesCount}

Y-Axis
YAxisSum: {%YAxisSum} YAxisBubbleSizeSum: {%YAxisBubbleSizeSum} YAxisMax: {%YAxisMax} YAxisMin: {%YAxisMin} YAxisScaleMax: {%YAxisScaleMax}
YAxisScaleMin: {%YAxisScaleMin} YAxisBubbleSizeMax: {%YAxisBubbleSizeMax} YAxisBubbleSizeMin: {%YAxisBubbleSizeMin} YAxisAverage: {%YAxisAverage} YAxisMedian: {%YAxisMedian}
YAxisMode: {%YAxisMode} YAxisName: {%YAxisName}
X-Axis
XAxisSum: {%XAxisSum} XAxisBubbleSizeSum: {%XAxisBubbleSizeSum} XAxisMax: {%XAxisMax} XAxisMin: {%XAxisMin} XAxisScaleMax: {%XAxisScaleMax}
XAxisScaleMin: {%XAxisScaleMin} XAxisBubbleSizeMax: {%XAxisBubbleSizeMax} XAxisBubbleSizeMin: {%XAxisBubbleSizeMin} XAxisAverage: {%XAxisAverage} XAxisMedian: {%XAxisMedian}
XAxisMode: {%XAxisMode} XAxisName: {%XAxisName} ]]></format>
<font family="Tahoma" size="10" color="0x" />
<position anchor="Float" valign="Top" padding="10" />
</tooltip_settings>

[/sourcecode]

One thought on “Apex Flash Chart Tooltip Madness

  • August 13, 2012 at 11:17 am
    Permalink

    Hi ,

    I need you help on making a column called reason as the tool tip .

    I tried the following . It will be great help .

    I have a column called reasons .. and i want to include that column as tool tip , but as you know that sql syntax for the chart is .. select null link , name , value from table order by value .

    I am unable to include the column reason in this , hence i thought of including the reason as

    select null link, reason||Ename name , evalue value from emp_dummy;

    but now i want to display ename as the axis namings and reason as the tool tip , to do this , i think i should call JavaScript in the CDATA but , when i m trying to write java script code its treating everything as the data itself … unable to do this functionality

    Regards,
    Nandini Thakur

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *