Sorting Expression

[#1]

Hello All,

I am unable to sort the table below:

Name	Login	Logout
Sanchez	08:50:00	17:00:00
Laurent	09:02:00	18:00:00
Francis	08:05:00	17:01:00
Theo	08:55:00	18:05:00
Olivier	07:59:00	16:59:00

I tried using all the options in the sorting tab but nothing is working. I set the login first.

I need the login to sort in ascending order. Is there an expression which i can use.

Thanks,

Hasvine

[tamilarasu]

Hi Hasvine,

Make sure to promote the Login field to top and try this as sort expression.

=Time#(Login,'hh:mm:ss')

[rido1421]

Hi Hasvine

Have you got "Login" 1st on your sort Priority?

See attachments...

[Anonymous]

Hi,

if you are using straight table,

in sort tab

select our filed login and promote that filed in to top

then

sort by

numerical order-ascending

then you will get our output.

[#5]

Hello All,

Thanks for the reply.

It is straight table.

I tried all the tips provided but it does not work.

See below:

Thanks,

Hasvine

[Anonymous]

Hi hasvine,

From this Your  are used descending ,you have to use ascending to get what you want,

and

i think you have some additional filed like date in your table. sort by the date filed also ascending order.

[#7]

Hello All,

Nothing is actually working. I put the login first, in ascending and descending but the value does not change.

I have 2 dimensions, Date and Name

and I have 2 Expressions, Login and Logout.

I tried putting the date first and login second but no luck there either.

Any idea?

Thanks,

Hasvine

[tamilarasu]

Hasvine,

Please attach your application.

[#9 · Accepted solution]

Hello All,

I found the issue.

Actually in the table i was using an expression to make 1 line white and 1 line grey as below:

=if(mod(rowno(TOTAL), 2) = 1,  white(), rgb(212,212,212))

Once i removed the expression, it worked well.

Thanks everyone for your help.

Kind Regards,

Hasvine