Sort by date and then by time

[Anonymous]

Hi everyone,

I am struggling to sort my data in a graph.

What I need:

1. Sort the data by date:

11.11.2017

12.11.2017

13.11.2017

2. In the same day, sort the data by time:

11.11.2017

• 6:12:10
• 7:14:45
• 13:01:01

12.11.2017

• 5:02:02
• 17:02:00

13.11.2017

etc....

Could you please support on this?

thanks

Mat

[YoussefBelloum]

Hi,

can you attach a sample data ?  to see the structure of the table you have

[el_aprendiz111]

Hi Clement

Can you share a sample with an example ?

1-option

[MarcoWedel]

Using timestamps (i.e. date and time part) this should come naturally.

[Anonymous]

Hi!

please find attached the excel file with data

hope it helps

I would like to be able to sort it also correctly in the graph

[YoussefBelloum]

there is no attached files

[Anonymous]

[Anonymous]

I cannot find the way to attach the excel file

[shraddha_g]

Refer Uploading a Sample

[Anonymous]

thanks