Difference between revisions of "Analytics Analysis (Crosstabs)"
| Line 13: | Line 13: | ||
1) Once you have your Crosstab setup, right-click in '''Data Fields''' and select '''Set up Data Fields'''. | 1) Once you have your Crosstab setup, right-click in '''Data Fields''' and select '''Set up Data Fields'''. | ||
:::[[Image:Analytics - Distinct Patients 01.jpg]] | :::[[Image:Analytics - Distinct Patients 01.jpg]] | ||
| + | |||
2) Select the '''Expressions''' tab, and click '''Add New...''' | 2) Select the '''Expressions''' tab, and click '''Add New...''' | ||
:::[[Image:Analytics - Distinct Patients 02.jpg]] | :::[[Image:Analytics - Distinct Patients 02.jpg]] | ||
| + | |||
3) When you are prompted to use existing fields, select '''No''' | 3) When you are prompted to use existing fields, select '''No''' | ||
:::[[Image:Analytics - Distinct Patients 03.jpg]] | :::[[Image:Analytics - Distinct Patients 03.jpg]] | ||
| + | |||
4) Create a new expression as "count distinct ( patient.id ) " | 4) Create a new expression as "count distinct ( patient.id ) " | ||
:::[[Image:Analytics - Distinct Patients 04.jpg]] | :::[[Image:Analytics - Distinct Patients 04.jpg]] | ||
| + | |||
5) Name the field, click '''Parse''' and then click '''OK''' | 5) Name the field, click '''Parse''' and then click '''OK''' | ||
| + | |||
6) When you run the Crosstab again, you will see your distinct patient count | 6) When you run the Crosstab again, you will see your distinct patient count | ||
:::[[Image:Analytics - Distinct Patients 05.jpg]] | :::[[Image:Analytics - Distinct Patients 05.jpg]] | ||
Revision as of 15:31, 27 April 2011
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.
2) Select the Expressions tab, and click Add New...
3) When you are prompted to use existing fields, select No
4) Create a new expression as "count distinct ( patient.id ) "
5) Name the field, click Parse and then click OK
6) When you run the Crosstab again, you will see your distinct patient count
