AnsweredAssumed Answered

Create dynamic trend from ODBC query

Question asked by jasongogal on Nov 22, 2015
Latest reply on Nov 23, 2015 by pthivierge

Hi all,


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.