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; } } }

x-axis string sort

Prashanty03

Hi, I want to sort the x-axis of a chart report.The x-axis is a string which shows week no - week start date,eg. week1 - 8th July 2013 week2 - 16th july 2013 week3 - 24th july 2013 week4 - 2 aug 2013 and so on.This goes well till week9 - some date, but then it puts week10 - x 2013 between week1 and week2.I have attached the screen shot of the report generated. I m stuck here n i dont know how to proceed.Thanks in advance. Regards,
 
<a class='bbc_url' href='http://www.birt-exchange.org/articles.html/_/articles/x-axis-string-sort-r38'>This post has been promoted to an article</a>

Find more posts tagged with

Comments

kclark

Instead of using a string in your x-axis you could use the date from your db. If it comes through as shown in the screenshot above you'll need to create a computed column. Then you could rename the x-axis labels doing something like this<pre class="_prettyXprint">weekCounter = 1;function beforeDrawAxisLabel( axis, label, context ) {importPackage(Packages.java.lang);importPackage(Packages.java.util);importPackage(Packages.org.eclipse.birt.chart.model.attribute);if (axis.getType() == AxisType.TEXT_LITERAL){ newLabel = "Week" + weekCounter + " " label.getCaption.getValue(); weekCounter++; label.getCaption().setValue(newLabel); axis.setLabel(label);}} </pre>

Prashanty03

Hi Kclark, Thanks for ur reply.I changed my proc to return the date on the x-axis. and i added the on render method to the chart.the chart shows the xaxis label, but now i m just able to get 1st week data, 2nd week data and the rest data in the 3rd week. As in the output chart always shows 3 weeks, irrespective of the number of weeks i generate report for.<div><div> </div><div> </div></div>Thanks

Prashanty03

Also i need to append that week 1,2,3 and so on in the crosstab column no. 1 Weeks OPEN CLOSED REOPEN[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]week1 - 8th July 2013 15 10 2[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]week2 - 16th july 2013 10 5 0[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]week3 - 24th july 2013 14 [/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] 5 0[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] [/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]week4 - 2 aug 2013 [/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] 5 0[/color][color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;] 1[/color]
 
<a class='bbc_url' href='http://www.birt-exchange.org/articles.html/_/articles/x-axis-string-sort-r39'>This post has been promoted to an article</a>