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>

Advertisements

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


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Entries and comments feeds.

%d bloggers like this: