​⚠​ This is an archived version​ of our Community Check Box help documentation.

Please find our most up to date documentation at Community Check Box ​​​​Help.​

​

​​​​​​​Graphs​
​A key challenge in evaluating comprehensive community health initiatives is how to document and illustrate the unfolding of the intervention; that is, the multiple changes in the environment that can lead to widespread behavior change and improvement in population-level outcomes. Using online graphs, community and research partners can examine the rate of community/system changes over time, or allow for systematic reflection on the proportion of changes occurring in different sectors.​

 

ccb2-leftnav-graphs.png

To begin, click on the Graphs link in the left navigation bar. 

You will notice a Help documentation link to Graph Help in the upper right. That link will open a new window that takes you directly to this documentation.

As graphs are added to the site, they will appear in an alphabetized list on the graphs page. The graphs will feature an icon representing the graph type, along with the assigned title, created or modified date, and the date range of the graph. 

Click Filter Graphs if you want to select graphs by title, created or modified date, or created or modified by name. 

Click on any folder or graph to open and view it.


  


Graph Overview

Before you create a graph you need to have the following information.

  • ​Graph Name: ​Assign a descriptive name to your graph, e.g. "Services Provided May 2019." Each graph name must be unique. Note: No special characters (other than a dash or underscore) can be used in graph names.
  • Date Range: Adjust the range of data displayed by changing the date​s shown.  You can type the dates in, or use the calendar that appears when you click within the box. Note: the Date Range defaults to the current calendar year.
  • Date Display: ​For a broader or narrower view of the data points throughout the designated date range, you can change the Date Display to reflect data points by Day, Month, Quarter or Year.
  • Labels Dis​play: Display or hide data labels on the graph to help identify the values shown in each data point of the data series.  If using a pie graph, the option will exist to Show Percentage.
  • ​Graph Type: ​If you would like to view varying presentations of the data, you can modify the graph type by selecting from the Graph Type icons.

When you create a new graph, it will be created using the most appropriate graph type for the data you are graphing. Depending on the graph type, you may have an option to change the graph type after it is created. 

Icon_LineGraph.png 
​
Line Graph:​ Line graphs are used to track changes over periods of time or cumulative changes.
​

Icon_PieChart.png ​Pie Chart: ​Pie charts are best to use when you are trying to compare parts of a whole or show a distribution of categories.
​
Icon_BarGraph.png ​Bar Graph: Bar graphs are used to compare data between different groups or to track changes over time. When trying to measure change over time, bar graphs are best when the changes are larger.​

​​

View Graphs  ​

  1. ​Click the Graphs button on the Dashboard, or Graphs in the left navigation bar. You will see a display of all existing folders and graphs. Folders and Graphs are displayed in alphabetical order.

    ccb208-graphs-view-rev2.png
  2. Click Filter Graphs if you want to select graphs by title, created or modified date, or created or modified by name. 
  3. Click on any folder or graph to open and view it.

Create a Graph​​

  1. Click on + New Graph at the top of the Graphs page
  2. ​Select the appropriate option from the Create new graph dropdown menus 
  3. Select from the What data type do you want to graph? dropdown menu. Your options are Accomplishments, Participants Description, Indicators and Create Graph from Template.

    ccb2018-graph-create.png
  4. ​ ​​Click Create Graph. You should see the following display, with blanks for the Title and Date Range.

    ccb2-graph-create.png
  5. Assign a descriptive title to your graph. ​
    ​NOTE: Every graph must have a unique title. If you have multiple graphs called Accomplishment Graphs, you will need to rename them.
  6. Adjust the Date Range by changing the default dates shown.  You can type the dates in, or select dates from the calendar icon on the right. Note: the Date Range defaults to the current calendar year.
  7. Adjust the Date Display if needed.
  8. Adjust the Labels Display if needed. If using a pie graph, a Show Percentage option will also be displayed.​
  9. Adjust the graph type if needed.
  10. Click Apply to save these changes.
  11. Click Edit to select options for the data you want to graph.

Options available after you create a graph

When you create a new graph, or open an existing graph, you will see the following options.

graph-edit.png           
Select the appropriate option:
  • Edit to make changes to the existing graph.
  • Delete if the graph is no longer needed.
  • Download to save a copy of the graph for use in presentations or other tools offline.
  • Save as Template to make the graph available when graphing similar data in the future.
  • Reflection Questions encourage documenters to think carefully about, better understand, and communicate the meaning of their data. A default set of reflection questions are displayed based on the graph type. Please talk with your site owner, or the KU researchers supporting your efforts, if you need to add custom reflection questions. 
  • Supports for Improvement provides helpful guidance and links for solving problems and dilemmas documenters may be encountering in their work.​ This section displays live content from the Community Tool Box Troubleshooting Guide to assist you. ​
  • Move Graph to Folder allows you to move graphs around as needed.

Edit Graph​

When you click the Edit Graph button, a new window will open with options to Edit Basic Information, Edit Data Accomplishments, Add Additional Data, Format Graph and Add Comparison Graph.  Click the category you want to edit, and then type in the new information.

ccb2018-graph-basic.png 

 

Edit Basic Information

  1. Title: Update the title of the graph.​
  2. Date Range: Adjust the range of data displayed by changing the dates shown. Note: the Date Range defaults to the current calendar year.
  3. Date Display: To review a broader or narrower view of the dat​a points throughout the designated date range, you can change the Date Display to reflect data points by Day, Month, Quarter or Year.
  4. X and Y Axis Label: Update the label for the X Axis and Y Axis as needed.
  5. Labels Display: Click Show # to display the data labels on the graph, or Hide to keep them hidden.
  6. Series Display: Click Stacked or Clustered depending on how you want to view your data.
  7. Graph Type: If you would like to view varying presentations of the data, you can modify the graph type by selecting from the Graph Type icons.
  8. When you are done making changes on this page click:
    1. ​​Update Graph if you want to save and stay on this page.
    2. Save & Go to Graph if you want to save and go back to the graph.
    3. Return to Graph if you do not want to save changes.

ccb2018-graph-label2.png

Edit Data​ Accomplishments

  1. Legend Label: Will default to the name of the data being graphed (e.g., Accomplishments, but you can change if needed. Legend field names should not be more than 30 characters to display correctly on the graph. 
  2. Data Source: This is the source of your data (e.g., Accomplishments, Indicators, etc.)
  3. Observer: Select this if you want to select data from a particular observer.
    1. Observer 1: Primary Data
    2. Observer 2: Reliability Scorer Data
    3. Observer 3: Calibration Scorer Data
  4. ​​​Select Sites: If you have multiple CCB sites, select the site(s) you want to graph.
  5. Form: If you have multiple CCB forms, select the form you want to graph.
  6. ​What specific information do you want to graph? Select the question you want to graph.
  7. Values to graph: If you select Code in the previous field, then you can select which codes to include in this field.
  8. Filter Accomplishments: If you want to apply filters, then select them here. If you don't see a question available to filter, please enable Apply Filter on the form under Administration.
  9. When you are done making changes on this page click:
    1. ​Update Graph if you want to save and stay on this page.
    2. Save & Go to Graph if you want to save and go back to the graph.
    3. Return to Graph if you do not want to save changes

      ccb2018-graph-edit-data.png

     

Add Additional Data

You can select from the data sources on your site to include additional data in your graph.

  1. Legend Label: Will default to the name of the data being graphed (e.g., Accomplishments, but you can change if needed. Legend field names should not be more than 30 characters to display correctly on the graph. 
  2. What data type do you want to graph? Select the data type you want to graph.
  3. ​Select Sites: If you have multiple CCB sites, select the site(s) you want to graph.
  4. Form: If you have multiple CCB forms, select the form you want to graph.
  5. ​What specific information do you want to graph? Select the question you want to graph.
  6. When you are done making changes on this page click:
    1. ​ Update Graph if you want to save and stay on this page.
    2. Save & Go to Graph if you want to save and go back to the graph.
    3. Return to Graph if you do not want to save changes.​
      
Add Comparison Graph

You also have the option to add a comparison graph. For instance, if you want to compare Accomplishments from this year to the previous year, you can choose last year's graph from the Select Comparison Graph drop-down menu and hit Save & Go to Graph. This will return you to the graph display, and you will see both graphs on the same page.

​

Create​ Graph​ Template​

During the graph creation process, you may find that you periodically create graphs with the same set of criteria.  To help save time during this process, you can create a template from a graph.

  1. Open the existing graph that you want to use to create a template.
  2. Click Save as Template.
  3. Your template graph will be saved in the Manage Templates folder. 
  4. When you need to use this template to create a graph, you will be given an option to Create Graph from Template.
​