Sign in to follow this  
Jesús

Customize Tooltip

Recommended Posts

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>

Share this post


Link to post
Share on other sites
Guest Bindhu

Hi,

 

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

 

Hope this helps!

Share this post


Link to post
Share on other sites

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.

 

 

 

Hi,

 

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

 

Hope this helps!

 

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this