I'm a little stuck for how to create a trend in ProcessBook.
We ship a number of trucks per day. Each truck is recorded in our production database as it leaves the facility. What I want to do is be able to trend each truck as it is recorded into the database - in other words, to have a live updating, stair step type of trend line that steps up when each truck ships (set to query every hour, usually about 12 trucks ship per day). I can't quite seem to figure out the correct syntax for this query to be able to express this data (bear with me, I'm a little nooby with queries). Am I even on the right track here? Is this enough information to point me towards an answer? The closest I can get is a trend that looks like this:
For what it's worth, here is the query I put together:
SELECT tblTrucking.dteReportDate, Count(tblTrucking.tmeTimeOut) FROM tblTrucking where tblTrucking.dteReportDate > ? and tblTrucking.dteReportDate < ?
GROUP BY tblTrucking.dteReportDate
Any thoughts would be much appreciated.