June 12, 2014
Recently I was looking to put a report together that would track the total number of cases that are open on a daily basis, and graph that as a trend. This is fairly tricky to do with baseline data. It would be easier if I had a query that ran every night and simply recorded the total number of open cases at that point in time. All I need is the count, not the actual data. Then I would have a set of records that I could build a report with. My first thought was to create a simple script that would run the query, then set this up as a Scheduled Task to run nightly. Then I could store the results somewhere in the database. Then I realized that this all sounded familiar – this is Trend Tracker. Trends…
Charting case trends
June 12, 2014
Recently I was looking to put a report together that would track the total number of cases that are open on a daily basis, and graph that as a trend. This is fairly tricky to do with baseline data. It would be easier if I had a query that ran every night and simply recorded the total number of open cases at that point in time. All I need is the count, not the actual data. Then I would have a set of records that I could build a report with. My first thought was to create a simple script that would run the query, then set this up as a Scheduled Task to run nightly. Then I could store the results somewhere in the database. Then I realized that this all sounded familiar – this is Trend Tracker. Trends…