Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Change color gantt chart comparing two dates
Migrateduser
<p>Hi, I would like to change the color of a marker in my gantt chart for a BIRT report. The color schould rely to the result of a substraction operation of two end dates. So, if endDate1 minus endDate2 = <0, I want the marker to turn red (event ends later). If endDate1 minus endDate2 = >0, I want the marker to turn green (event ends earlier). The idea is to compare two dates and visualize, if a date differ to a earlier (default) date. In the chart you will see then always the default date marker in black and the actual date (result of the substraction operation) in green or red.</p>
<p> </p>
<p>I tried different versions of scripting, but get no useful results. So, any ideas about that? Thanks a lot in advance, here is a base version I try to modify to my needs:</p>
<p> </p>
<p>function beforeDrawMarker( marker, dph, icsc )<br>
{ <br>
if (BirtDateTime.diffDay ( row["defaultBaseplan.endDate"], row["endDate"] )<0 )<br>
{marker.setFill(0,255,0);}<br>
<br>
if (BirtDateTime.diffDay ( row["defaultBaseplan.endDate"], row["endDate"] )>0 )<br>
{marker.setFill(0,255,0);}<br><br>
}</p>
<p> </p>
<p>Best regards</p>
Find more posts tagged with
Comments
There are no comments yet