Skip to content

Time Series Chart

A Time Series module allows users the option to graph their data over time in a bar or line chart. Once parameters of your graph are set, a toggle swtich lets you decide between line or bar chart to be displayed.

Time Series

Module Settings

Once you add a time series module to your layout you'll enter the module settings where you can set the parameters for the data you wish to display.

Note

The most common selection for each parameter is selected by default.

General

  • Title - Give the graph a name (default is Time Series Chart)
  • Graph As - Toggle between Line or Bar (as shown in clip above)
  • Time Axis - These are time related
    • Label - Name what is being graphed along the x-axis
    • Time Series Resource - Select between:
      • Calendar Date
        • Time Series Interval (Day, Month, Year)
      • Medications/ Procedures/ Observations/ Conditions
        • Time Series Interval (Day, Month, Year)
        • Interval-Code Relation:
          • Before First Occurrence Of Code
          • Before Last Occurrence Of Code
          • After First Occurrence Of Code
          • After Last Occurrence Of Code
        • Search box - To search for the Medications/ Procedures/ Observations/ Conditions

Note

Medications, Procedures, Observations, and Conditions are useful selections if you wish to align all patients relative to a certain start date, such as when they first started participating in a clinical research study.

Calendar Date is a useful selection when looking at a specific start date, such as viewing how many patients reported depression since the Covid lockdown began.

  • Y-Axis Values

    • Label - Name what is being graphed along the y-axis.
    • Data type
      • Select from:
        • Medications
        • Procedures
        • Observations
        • Conditions
      • Search box - Click or type the name of the resource you wish to graph.
      • Property - Choose from Patient Count or Record Count.
      • Function - Choose from Count Percent or Count Total.
    • Date Filter - If you leave this blank, it will show the data collected since being recorded.
      • 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 - Here you can toggle on to Group the series by patients, meaning you can see each individual patient's data on a separate line in the same graph.

      Group Series Data

    • 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.

Note

The cohort selector in the header overrides the selection in the module settings. However, the header's cohort selecttion cannot be saved and is just a temporary view.

Style

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.

Style

Preview, Apply, and Save your new settings:

  1. Click Preview in the module settings to view it.
  2. 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.
  3. 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.

Note

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.

Viewing the Time Series Chart

Plotly graphs in the PHC have a mode bar of tools to improve the ease of viewing the displayed data (shown below).

Insights Time Plotly

The Time Series Mode bar graph tools include:

  1. Download plot as a PNG.
  2. Zoom - Zooming can be performed vertically and horizontally. If graphs are stacked, only the one you zoomed in will change. When graphs are layered, all will zoom in. Double clicking within the part you zoomed will reset the vertical.
  3. Pan - Lets you grab and drag the plot to change the date range seen.
  4. Zoom in - Lets you zoom in.
  5. Zoom out - Lets you zoom out.
  6. Reset axes - Lets up zoom to include your Axes Range, if this has been set. If it has not been set it zooms to a setting that shows all the viewable data.
  7. Toggle spike lines – When you hover, this drops a dotted line to the x and y axis to see where it lands.
  8. Show closest data on hover – Shows the one data point you are closest to.
  9. Compare data on hover – Shows all data points when you hover, if you toggle that off you’ll see the single data point that you are closest to.

You can click on a point or a selection of points, then click View Data in the bottom left of the module to see the data affiliated with it in table format. This View Data page also can be viewed full screen by clicking the icon in the top right of the window.


Last update: 2021-08-04