Customize Tooltip

[Jesús]

Hi there!!

 

Im working with Bullet Graphs, and i trying to customize the tooltip because I want to show the date.

 

First, I have a query to get the information, and then i would like to integrate the date like in liner charts.

 

I share my source code i hope that you can help me...

 

 

<?php

$qAnio_Ind = $qAnio."-*";

$qAnioA_Ind = $qAnioA."-*";

$strXML="<chart

caption='ATM Nacional'

subcaption='Días record'

showValue='1'

showBorder='0'

chartTopMargin='50'

plotFillColor='CC0000'

targetThickness='7'

>";

 

$strMin = "SELECT TXTOT AS TXNS

FROM `tbpdata`

WHERE FECHA REGEXP '$qAnio_Ind'

AND PROD = 'ATM'

AND AMBT = 'NACI'

ORDER BY TXNS ASC

LIMIT 1";

$resultMin = mysql_query($strMin) or die(mysql_error());

$datoMin = mysql_fetch_array($resultMin);

$Min = $datoMin['TXNS'];

mysql_free_result($resultMin);

 

$strValue = "SELECT DATE_FORMAT(FECHA,'%d-%b-%Y') AS FECHA, TXTOT AS TXNS

FROM `tbpdata`

WHERE FECHA REGEXP '$qAnio_Ind'

AND PROD = 'ATM'

AND AMBT = 'NACI'

ORDER BY TXNS DESC

LIMIT 1";

$resultValue = mysql_query($strValue) or die(mysql_error());

$datoValue = mysql_fetch_array($resultValue);

$value = $datoValue['TXNS'];

mysql_free_result($resultValue);

 

$strTarget = "SELECT DATE_FORMAT(FECHA,'%d-%b-%Y') AS FECHA, TXTOT AS TXNS

FROM `tbpdata`

WHERE FECHA REGEXP '$qAnioA_Ind'

AND PROD = 'ATM'

AND AMBT = 'NACI'

ORDER BY TXNS DESC

LIMIT 1";

$resultTarget = mysql_query($strTarget) or die(mysql_error());

$datoTarget = mysql_fetch_array($resultTarget);

$target = $datoTarget['TXNS'];

mysql_free_result($resultTarget);

 

$Max = $value + 500000;

 

$strXML.="<colorRange>

<color minValue='".$Min."' maxValue='".$target."' code='A6A6A6'/>

<color minValue='".$target."' maxValue='".$Max."' code='E1E1E1'/>

</colorRange>

<value>".$value."</value>

<target>".$target."</target>

<styles>

<definition>

<style name='CFontStyle' type='font' font='Calibri' size='13' color='000000' bold='1'/>

<style name='SCFontStyle' type='font' font='Calibri' size='11' color='000000' bold='1'/>

</definition>

<application>

<apply toObject='caption' styles='CFontStyle' />

<apply toObject='subcaption' styles='SCFontStyle' />

</application>

</styles>

</chart>";

?>

<span align="center" style="display:inline-block;">

<?php echo renderChart("charts/VBullet.swf", "", $strXML, "chart06", "130", "400", "0", "0" );?>

</span>

[Guest Bindhu]

Hi,

 

I am afraid, Bullet graphs do not support customized toolTips.

 

Hope this helps!

[Jesús]

Hi Bindhu!!

 

Thanks for answer, do you have any alternative to show the date?? Because this is important info to analyze the bullet chart.

 

Thanks for your help.

 

 

 

  On 10/24/2012 at 12:11 PM, Bindhu said:

Hi,

 

I am afraid, Bullet graphs do not support customized toolTips.

 

Hope this helps!

 

 

 

[Guest Bindhu]

Hi,

 

I am afraid, there is no known work around for the same, as of now.