Using ColorGrid 3d with time as X axis
Posted: Wed Oct 08, 2008 9:00 am
My goal is to show the the state (ON-green, OFF-red, Unknown-yellow) of 10 devices during specified time on a ColorGrid 3D. This should look similar to Gantt Chart with time on X axis and 10 coloured bars horizontally.
I have TimeFrom and TimeTo as DateTime variables with 1 second resolution (say TimeFrom is 2008-10-08 08:12:34 and TimeTo is 2008-10-08 09:02:03, so they are not "round")
and an array
Status(10,200) as integer
where I have status values for 200 interpolated timestamps between TimeFrom and TimeTo for my 10 devices.
When I pack this array into ColorGrid 3D using integer values (1-200) as X index, everything looks OK, but I want to have time (From-To), not integer values on the X axis. I tried many options to select X axis as time, but it seems to work only for 1-day resolution (integer value of DateTime), not for 1-second resolution.
I have TimeFrom and TimeTo as DateTime variables with 1 second resolution (say TimeFrom is 2008-10-08 08:12:34 and TimeTo is 2008-10-08 09:02:03, so they are not "round")
and an array
Status(10,200) as integer
where I have status values for 200 interpolated timestamps between TimeFrom and TimeTo for my 10 devices.
When I pack this array into ColorGrid 3D using integer values (1-200) as X index, everything looks OK, but I want to have time (From-To), not integer values on the X axis. I tried many options to select X axis as time, but it seems to work only for 1-day resolution (integer value of DateTime), not for 1-second resolution.