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