Bar chart isn't sorting chronologically

[#1]

Hi all.

I have a chart with 2 dimensions, one is

=month(Case_Created_Date)

the other is Cases_Category.

But when the chart shows up, the months aren't in order?

I promoted the month dimension to the top.

Case Created Date is made in the script, by this

date(floor(Date(CreatedDateNum, 'MM/DD/YYYY')))  AS Case_Created_Date

I have to floor it and date it to get 01/01 as 1/1

Any ideas to get this to sort starting from January?

[dberkesacn]

try load inline and force the sort order with that, after use sorting tab / expression in the chart properties

LOAD * INLINE [

Month,Month_NO

Jan,1

Feb,2

...

];

Then in list box of Month Go to Sort Tab>Expression write the Month_NO,

Daniel

[#3]

How do I link that back to my chart? Dimension as the new MonthNO??

[#4 · Accepted solution]

I got a temporary fix by chart sorting it by numeric value

[dberkesacn]

in the table where you have this:

"date(floor(Date(CreatedDateNum, 'MM/DD/YYYY')))  AS Case_Created_Date"

make a month field from CreatedDateNum for example Case_Created_Month and make a new table with that name plus extend it with a sort field.

TableCaseCreatedMonthForSorting

LOAD * INLINE [

Case_Created_Month,Month_NO

Jan,1

Feb,2

...

];

Daniel

[dberkesacn]

okey then you answered your question

[#7]

thanks