Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I got a temporary fix by chart sorting it by numeric value
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
How do I link that back to my chart? Dimension as the new MonthNO??
I got a temporary fix by chart sorting it by numeric value
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
okey then you answered your question
thanks