I have a layer in QGIS which comes from a CSV with almost a million points. One of the columns of this csv is a datetime.
I would like the color of the points to be on a gradient depending on this datetime (e.g. oldest points in blue, newest in red, continuous gradient). I'm new to QGIS but know about the "Categorized" marker type, which allows me to have different markers depending on a field. Unfortunately I can only choose numerical fields there, and not text or datetime fields.
Is there a way to do this?
Alternatively, I could sort the source CSV by date. Is there a way to then use the "line number" to do the color gradient?
My CSV data looks like this:
Accuracy,Altitude,Bearing,Date Time,Date(GMT),Description,Distance,Latitude,Longitude,Name,Speed,_FileNames,Location,NAME_0,NAME_1,NAME_2,NAME_3,NAME_4,NAME_5,REGION,UID,Time elapsed 13.0,3089.800049,12.0,2013-03-16 18:03:00,,,24156.0,-13.322358,-72.049927,,10.5268,C:/Users/Alexis/Dropbox/Location/Aggregated.csv,Null,Peru,Cusco,Urubamba,Huayllabamba,,,,135966.0,0.0 26.0,2941.199951,17.20000076,2013-03-16 18:03:00,,,24156.0,-13.321477,-72.049874,,2.5,C:/Users/Alexis/Dropbox/Location/Aggregated.csv,Null,Peru,Cusco,Urubamba,Huayllabamba,,,,135966.0,0.0
Note that I have changed in the layer's properties-->fields, I have changed the field type to datetime, according to the datetime format in my data.