Hello everyone,
I'm really stuck on this one. I have a database which tracks status of fleet, and hours spent on each "Event". I want to use the data to show a chart, or a planner in a "tape" fashion and show each event in blocks of time. It's kind of hard to explain so I will include screenshots.
Here is my main screen:
When you "Update Status", it opens a new event, adds a start timestamp and closes previous event, also ads closed timestamp.
Below is a sample of data table:
With data above, I'd like to show a time block (possibly with some details such as "Cause" field) and plot the hours on to the chart portion of the main screen:
Notice the yellow box is the current day. It shows the current day with all events that belong to this day. Some events may begin on a previous day, in that case all blocks would be shaded and if the event didn't end, the block would terminate at the current time. I've manually altered the chart to show what I mean:
What in the world do I need to do to make this work?
By the way, I've included a .zip file with database if anyone wants to have a look.
Thanks!
I'm really stuck on this one. I have a database which tracks status of fleet, and hours spent on each "Event". I want to use the data to show a chart, or a planner in a "tape" fashion and show each event in blocks of time. It's kind of hard to explain so I will include screenshots.
Here is my main screen:
When you "Update Status", it opens a new event, adds a start timestamp and closes previous event, also ads closed timestamp.
Below is a sample of data table:
With data above, I'd like to show a time block (possibly with some details such as "Cause" field) and plot the hours on to the chart portion of the main screen:
Notice the yellow box is the current day. It shows the current day with all events that belong to this day. Some events may begin on a previous day, in that case all blocks would be shaded and if the event didn't end, the block would terminate at the current time. I've manually altered the chart to show what I mean:
What in the world do I need to do to make this work?
By the way, I've included a .zip file with database if anyone wants to have a look.
Thanks!