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
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
