Analytics Analysis (Crosstabs)

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 15:31, 27 April 2011 by Mike.Dow (talk | contribs)
Jump to navigation Jump to search

Analysis, also know as Crosstabs, allows you to aggregate data with Analytics.

There are two types of Analysis Crosstabs - regular Crosstabs and Link Group Crosstabs.

Regular Crosstabs allow you to aggregate and explore data sets. For example, if you wanted to look at prescribing habits of the organization, you might have a Crosstab that includes the following. Medication, Prescribe Action (Record, Print, Retail, etc), Prescriber, Drug Therapy Class, Pharmacy, Patient State/City, and so on. You would be able to show the number of prescriptions by provider. Then filter out Recorded prescriptions and look at counts by year. You could then include all prescriptions and see the pharmacies that you send most of your prescriptions to. Crosstabs allow you to take a large data set and explore the information.

Link Group Crosstabs allow you to compare multiple data sets. For example, we could show, by provider, the number of patients on their panel (where they are the PCP), the number of diabetics in another column, the number of diabetics without an AIC in the past year in another, and the number of overdue tasks for that provider. With Link Group Crosstabs, we can show summary information on a common dimension for various types of data.

Distinct Counts

When using Crosstabs, you may want to pull in distinct counts for items like patients. To do this, we need to setup an Expression to calculate the distinct values. Here's an example of how to count distinct patients.

1) Once you have your Crosstab setup, right-click in Data Fields and select Set up Data Fields.

Analytics - Distinct Patients 01.jpg

2) Select the Expressions tab, and click Add New...

Analytics - Distinct Patients 02.jpg

3) When you are prompted to use existing fields, select No

Analytics - Distinct Patients 03.jpg

4) Create a new expression as "count distinct ( ) "

Analytics - Distinct Patients 04.jpg

5) Name the field, click Parse and then click OK

6) When you run the Crosstab again, you will see your distinct patient count

Analytics - Distinct Patients 05.jpg