I’m in the visual dashboard and we’ll
use the Lyme disease project to find out how
many people had an onset of Lyme disease for
each month in 2010. I'll click Set data source,
I'll choose an Epi Info 7 Project and it's
Lyme disease and then the Lyme project, I'll
click Case Report and then OK. And now if
you'll look at the top of the page you'll
see that I have 1,159 records in this dataset.
We said that we wanted to only use the data
from 2010 so we’ll have to set a filter
for that year. I’ll go to the right side
of the canvas, and hover over the Data Filters
tab. The field name we are filtering on is
OnsetDate and the operator is In Between.
I’ll have to type in January 1, 2010 here
and December 31, 2010 here. Then click Add
filter. Look at the top of the page and you’ll
see that Epi Info 7 tells us the filter is
in effect and we now have 539 records. Now
we’ll run a Line List gadget to see the
variables. I’ll right-click, navigate to
the Line List and select OnsetDate. I’ll
hold down the Control key and choose Race,
Sex, and State just as samples of variables
for this Line List. And now we can see all
the columns for each of the variables. Now
I’ll need to create a new defined variable
with a formatted value. I’ll go to the left
side of the canvas and hover over the Defined
Variables tab. Select New Variable with Formatted
Value. The Source field is OnsetDate, the
Destination field, I’ll type in my new format
of OnsetMonth and the Format type is The Month
Name. And in the preview box, you’ll see
the current month. And I’ll click OK. Now
I can go back to the Line List and add the
new variable of OnsetMonth. I’ll Go to the
Configuration panel, find Onset month, hold
down the Control key select it and click Generate
Line List. Now I can see the line list with
my new variable. So I’m ready to do either
a Frequency or Chart gadget. I’m going to
do a chart. So I’ll navigate to the chart
analysis gadget and I’ll choose Column chart.
The main variable is Onset Month. And then
we set a display options to make it easier
to see the month names. I’ll click display
options and I’ll go to the X-axis angle
and change it to -45. Then I’ll click Run.
Now it’s easy to see the graphed data and
the corresponding month. Thanks for watching,
and look for more user support videos coming
soon.
