02-28-2019 06:01 AM
02-28-2019 08:31 AM
03-01-2019 12:05 AM
03-01-2019 12:22 AM - edited 03-01-2019 12:38 AM
Its always easier if you can provide the actual data or an example, what format is the "weeks" column in, is it a timestamp, a week number etc....
Would my datatable look like this?
03-01-2019 12:57 AM
How about this?
The screenshot really helped, however you could have pasted the query and a line of data into this message as text, to save anybody having to re-type it, copy & paste is easier :) This just helps us to help you faster, especially on a complex query or dataset. I often add a line at the end of a test query "| limit 1", I can then copy the results of one line and column headings
03-01-2019 01:19 AMSolution