On another chart I was able to just sort the table asc instead of desc but this time the table isn't the same. In the other table the time was able to adjust on the SQL query because using SQL tables but this table is in Informix and SQL isn't as programmable. So I have incremental time for 30min matching on two tables 0:00 0:30 1:00 .... 23:00 23:30 etc. and I only need 7 hours prior to the current time. When I loop 0 to 14 it will always start at 0 and if i do 14 to 0 it'll always start at 7:00 (i think). So instead of writing out code to allow to find the time and so on can I just reverse the chart?
Thanks.
Thanks.