Home » Categories » CHARTrunner

CR: Charting counted incidents

Customers often need to chart Excel data that is the result of a database query. The database might be a customer relationship management system (CRM) or it might be a hospital wide patient management system. In either case a query is performed, the results are put into Excel, and the Excel sheet is handed to an analyst who is tasked with creating a chart or quality improvement visual based on the results.

When faced with 2,000 rows of data, in the basic form shown below, a CHARTrunner user might conclude the data cannot be charted:

IncidentDate

 Department

1/1/08

 ER Triage

1/1/08

 ER Treatment

1/1/08

 Outpatient Surgery

1/2/08

 Inpatient Surgery

Etc…

In this case each row represents a Patient Fall incident on the date and in the department shown. This could represent other incident types. For example, it could be Infections data or it could be some type of Medication Error data. The pattern is that we have a date and some indication that an incident occurred within a department.

The attached Using-CHARTrunner-to-chart-counted-incidents.pdf file discusses how to use CHARTrunner with this type of data.

The attached ChartingCountedIncidents.zip contains several CHARTrunner 3.6 chart definitions plus some sample data in an Excel workbook. You can download the zip file, extract the files, put them into a folder, and set this as your working folder in CHARTRunner 3.6. This will allow you to see and experiment with the various solutions presented in the attached PDF file.

Attachments (2) Attachments
Related Articles RSS Feed
CR: A custom query for Length of Stay data
Viewed 2539 times since Fri, Nov 9, 2007
CR: Changing the chart type will change the Default Chart Style to missing
Viewed 2121 times since Fri, Nov 9, 2007
CR: Chart [the name of the chart] failed with one or more errors
Viewed 2084 times since Fri, Nov 9, 2007
CR: Too many decimal places in the chart data grid for an Excel column that is calculated by a formula
Viewed 3718 times since Fri, Nov 9, 2007
CR: Making a chart transportable
Viewed 2128 times since Fri, Nov 9, 2007
CR: CHARTrunner and SharePoint
Viewed 4000 times since Fri, Mar 9, 2012
CR: Background on out-of-control test rules
Viewed 2309 times since Fri, Nov 9, 2007
CR: CR1.1 - Notes and Causes Problem
Viewed 2102 times since Fri, Nov 9, 2007
CR: Charts not working on a new PC
Viewed 2021 times since Fri, Nov 9, 2007
CR: The out-of-control (OOC) test may fail on the last sample with valid data
Viewed 2105 times since Fri, Nov 9, 2007