Hello all
I try to display a table in a chart and i need some help.
My table is formatted like that :
{table}
Date|Duration|Duration(s)|Start|End
2009.06.16|00:05:22|322|20:11:50|20:17:12
2009.06.18|00:05:12|312|20:11:50|20:17:02
2009.06.19|00:05:32|332|20:11:50|20:17:22
2009.06.25|00:05:52|352|20:11:50|20:17:42
{table}
The idea is to have on the x-axis the dates in the first column, on the y-axis the duration values that are in the 2nd column (i have to force the range, i don't know how to specify a full column for the source)
I inputed that in a wiki page :
#set($pattern='yyyy.MM.dd')
#set($periodStart="2009.06.16")
#set($periodEnd="2009.06.25")
#set($dtf=$xwiki.jodatime.getDateTimeFormatterForPattern($pattern))
<div style="text-align:center;">
{chart:type=time|renderer=xy_line_3d|source=type:table;doc:${doc.space}.STATS-${doc.name};table_number:0;ignore_alpha:true;range:A1-B4|date_format=type:custom;pattern:$pattern|height=250|width=550|domain_axis_date_format_override=type:custom;pattern:dd|domain_axis_lower_date=value:$periodStart;type:custom;pattern:$pattern|domain_axis_upper_date=value:$periodEnd;type:custom;pattern:$pattern|domain_axis_date_tick_unit=unit:day;count:3|domain_axis_tick_mark_position:ende|title=Statistics for batch ${batchName}}
</div>
The result is not what i would like. Duration values are changed from "aa:bb:cc" to an integer with the value "aabbcc"
Is there a way to tell him how to format the values titles of the y-axis ?
Also is there a full documentation of this macro to know all possible parameters that can be provided in ?
Christophe Périnaud
Windows Server 2003 SP2 in a VMWare instance
Oracle 10g
Java 1.6.0_12
Xwiki 1.8 from the pack Jetty/HSQL
--------------------------------------------------------------------------------
This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies.
While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection.
KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1
