Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Thanks for looking at and reading my question.
I have created a line chart that has x-axis value as timestamp format. I already tried the following option however its not sorting properly.
I want the data to be sorted till minute precision.
Properties -> Sort -> Expression ->
//date(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi')
//BEGIN_INTERVAL_TIME
//=num(date(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi'))
//(Date(Date#(Left([BEGIN_INTERVAL_TIME],10),'MM/DD/YYYY'),'MM/DD/YYYY'))
//Time#(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi')
//time(frac(BEGIN_INTERVAL_TIME))
Please suggest what should I use to get the correct sort order.
Regards,
Thanks for the hint. I tried following to load and its working now.
date(BEGIN_INTERVAL_TIME, 'MM/DD/YY hh:mm:ss') as BEGIN_INTERVAL_TIME