Feb 28 2019 06:01 AM
Feb 28 2019 08:31 AM
Mar 01 2019 12:05 AM
Mar 01 2019 12:22 AM - edited Mar 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?
Mar 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
Mar 01 2019 01:19 AMSolution