Line charts show you values over time.
To create your Line Chart:¶
- If you are not already in Edit Layout mode, enter it by clicking the Edit Layout icon in the blue header.
- Click the Add Module button at the bottom right of the screen.
- Select Line Chart.
In the window that opens, three tabs are available to customize your Line Chart: General, Style, and Advanced.
Module settings used to create the above chart are in parentheses in the settings below.
- Title - Name your Line Chart (for instance, Avg. Weight Trend in the Population)
Label - Give your x-axis a descriptive label
Time Series Interval - (such as day) Day, Month, or Year
Time Series Resource - (such as Observations) Observations, Medications, Procedures, or Conditions
Interval Code Relation (such as After First Occurrence of Code):
- After First Occurrence of Code (most commonly used option) - This selection sets everyone to the same day 0. This might be used if you are running a 12 week program and have individuals starting on different start dates. This allows you to evaluate their progress over 12 weeks regardless of their start date.
- Before Last Occurrence of Code
- Before First Occurrence of Code
- After Last Occurrence of Code - such as after the last biopsy
Time Series Code - What do we want to measure? (such as body weight)
Label - Give the y-axis a descriptive label
Aggregation Resource - (such as Observations) Medications, Procedures, Genes, Conditions, Observations, or Patients
- Aggregation Property - (such as Value Quantity) Value Quantity, Value String, Observation, or Patient
- Aggregation Filter Code - (such as body weight) Only one selection allowed. Choose the same Filter Code you chose in the X-Axis Filter Code.
- Aggregation Function - (for instance, Average - shows average body weight of all patients in project on one line as it changes daily over time) Standard Deviation, Average, Count, Minimum, Maximum, First Quartile, Second Quartile, Median, or Third Quartile
Graph with Standard Deviation checkbox - Select this to see the standard deviation (available only for Observations).
- Date Filter
- Start Date (type or click calendar to set date) - Clicking the checkbox beside Relative will change this to a box where you can specify the the number of days (After Days Ago from today - For example, a week ago would be 7 in the After Days Ago box and 0 in the Before Days Ago box)
- End Date (type or click calendar to set date) - Clicking the checkbox beside Relative will change this to a box where you can specify the the number of days (Before Days Ago from today)
Group Series Data toggle - Toggling this on will graph your data using multiple colored lines, each representing a different subject. A key for the chart will be on the right of the module and includes the subject id and correlating line color.
Series Data Grouping Resource - (such as Patients) Medications, Procedures, Observations, Conditions, or Patients
Cohort Comparision - Select up to four cohorts to compare (if cohorts have been created for the project). The bars of your chart split to represent the different cohorts in the given module.
The Style tab allows you to adjust the colors of your bar chart and select the margin size of your module. You can also load a palette for more color options.
Preview, Apply, and Save your new settings:
- Click Preview in the module settings to view it.
- If everything looks good, click Apply to apply the new settings. This will NOT save the module. If you click away, you will lose this module.
- To save this module and its settings to the layout, click the Save Changes icon found in the blue header at the top of the page. Or if you need to make changes, click the Edit icon in the top right corner of the module.
Clicking Apply will create your chart. It does not save the layout. To save the layout, you must click the Save Changes icon(found in the blue header). Navigating away from this page before clicking the icon will cause you to lose all changes since your last save.
Hiding an Individual Subject from the Line Chart - On the right side of the line graph is a key that shows which colored line goes with each subject id. If you click one of those lines within the key, it will hide that individual's data. This is useful if one person erroneously entered their data using the wrong measurement and skewed the graph.