Eclipse Community Forums: BIRT » MONTH IS NOT IN PROPER ORDER IN CHART

Help

Home

Home » Archived » BIRT » MONTH IS NOT IN PROPER ORDER IN CHART(MONTH IS NOT IN PROPER ORDER IN CHART)

Show: Today's Messages :: Show Polls :: Message Navigator

MONTH IS NOT IN PROPER ORDER IN CHART [message #698731]

Wed, 20 July 2011 05:53

jeyinul

Messages: 60
Registered: June 2011

Member

I AM USING A CHART WHICH IS HAVING MONTH IN X AXIS.
MONTH IS NOT IN PROPER ORDER. IT COMES LIKE APR,AUG,FEB LIKE THAT.

PLEASE LET ME KNOW HOW TO ORDER.

THANKS,
ABDEEN

Report message to a moderator

Re: MONTH IS NOT IN PROPER ORDER IN CHART [message #699008 is a reply to message #698731]

Wed, 20 July 2011 16:10

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

If the x-axis defined as a date or a string? If it is a string add a
computed column to the chart binding tab with an expression similar to this:

if( dataSetRow["month"] == "Jan" ){
1;
}else if(dataSetRow["month"] == "Feb"){
2;
}else if(dataSetRow["month"] == "Mar"){
3;
}
..
..

Then use this in the sort field on the x-axis.
See attached example.

Jason

On 7/20/2011 1:53 AM, jeyinul wrote:
> I AM USING A CHART WHICH IS HAVING MONTH IN X AXIS.
> MONTH IS NOT IN PROPER ORDER. IT COMES LIKE APR,AUG,FEB LIKE THAT.
>
> PLEASE LET ME KNOW HOW TO ORDER.
>
> THANKS,
> ABDEEN