nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Change color gantt chart comparing two dates

Bordihn

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.
 
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:
 
function beforeDrawMarker( marker, dph, icsc ) 
{ 
 if (BirtDateTime.diffDay ( row["defaultBaseplan.endDate"], row["endDate"] )<0 ) 
 {marker.setFill(0,255,0);} 
 
 if (BirtDateTime.diffDay ( row["defaultBaseplan.endDate"], row["endDate"] )>0 ) 
 {marker.setFill(0,255,0);} 
}
 
Best regards

Find more posts tagged with

Comments

mwilliams

Inside your chart script you'll have to use DPH to grab the data from the data point. If you could provide a flat file (.csv) or data and a design that uses it so I could actually test on it, I could help more.

Bordihn

Hi Michael,
 
first off sorry for the delay. Thanks to your input I found a way to visualize the two different dates,
for a successor report I have now some new challenges:

mwilliams

For 1, why specify a y, m, and d? If you just do new Date(), you get the current date. For 2 and 3, we might be able to use the data point labels to get what you're wanting to show.

Bordihn

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="135573" data-time="1429544654">
For 1, why specify a y, m, and d? If you just do new Date(), you get the current date. 
For 2 and 3, we might be able to use the data point labels to get what you're wanting to show.
</blockquote>
 
Hi Michael, 
 
that was ... awkward. Thanks to your input it works right now, for 2 and 3 I found a solution even without scripting: 
 
2. In Select Data within your chart you can define your Task Label like this : BirtDateTime.diffDay(row["date1"], row["date2"]) 
In Format Chart / Series you can activate the function Show Series Labels and add the label value Task Label (which we defined before). The Insets (Points) moves the displayed divergence if necessary. 
 
3. Same way like before, just activate Show Series Labels and add the Value endDate (or whatever you need).
 

Thanks for your help Michael, hopefully some others can use some of this stuff. 
 
Best regards.

mwilliams

Great! Glad everything is working properly, now!

Let us know whenever you have questions!