Apex Flash Chart Tooltip Madness

June 14, 2012 at 11:35 am | Posted in Oracle Application Express (Apex), Oracle Developement | 1 Comment
Tags: , , , ,

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:

 <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>

1 Comment »

RSS feed for comments on this post. TrackBack URI

  1. 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

    Comment by Oracle APEX Consultant— August 13, 2012 #

    Reply

Leave a comment


Entries and comments feeds.