Time sort issue

[#1]

hi all,

i'm looking for help, for the damn sort time in my chart !! i tried everything, nothing works.

Below, my chart and my script.

thanks

load

DATE_ID,

date(floor(DATE_ID)) as DATES_SHORT,

floor(DATE_ID) as DATES_NUM,

Month(DATE_ID) as Months,

num(Month(DATE_ID)) as MonthNum,

MonthName(DATE_ID) as MonthName,

Year(DATE_ID) as Years,

WeekName(DATE_ID) as Weeks,

WeekName(DATE_ID) as WeekName,

Day(DATE_ID) as Days,

Time(DATE_ID,'HH:mm') as Times,

Hour(DATE_ID) as Hour,

Minute(DATE_ID) as Minutes,

Second(DATE_ID) as Seconds

Resident $(_Table);

[MK_QSL]

Change below

Time(DATE_ID,'HH:mm') as Times,

to

Time(DATE_ID,'hh:mm') as Times,

[tresesco · Accepted solution]

Redefine your time field like:

Time(Frac(DATE_ID),'hh:mm') as Times,

[#4]

what the difference Manish ?

[MK_QSL]

As tresesco said... true... I missed... use as below

Time(Frac(DATE_ID),'hh:mm') as Times,

[Michiel_QV_Fan]

Alternative to formatting the time field:

Order your facts according as needed (date asc, time asc ) and select load order original.

You might need to resident load facts to accomplish this.

[#7]

it works well

thanks you gays

[Michiel_QV_Fan]

thanks you gays??

That's bad english

thank you guys.....

[#9]

oups, sorry