Skip to main content

How to Create Calculations Between Narrative Data Points

K
Written by Kay Chen

CoAuthor has introduced a powerful new feature: the ability to compute between two data points. Creating calculations between narrative data points can significantly enhance your ability to derive insights and tell compelling stories. This guide will walk you through the process step-by-step.

Prerequisites

Before you begin, ensure you have:

Step 1: Identify Your Data Points

First, identify the specific data points within your narrative that you want to compute between. These could be numerical values, dates, or any other quantifiable data embedded in your narrative.

Step 2: Access the Calculated Fields Feature

Navigate to the desired section of the narrative document to add calculated fields.

Step 3: Define Your Calculation

  1. Select Data Points: Choose the two data points you want to compute between.

  2. Choose Calculation Type: Decide on the type of calculation you need (e.g., difference, sum, average).

  3. Input Formula: Enter the formula for your calculation. For example, if you are calculating the difference between two dates, your formula might look like END DATE - START DATE .

Step 4: Apply the Calculation

Once your formula is set, apply the calculation. CoAuthor will automatically compute the result and display it within your narrative.

Step 5: Integrate the Results

Incorporate the computed results into your narrative. Use the insights gained from these calculations to enhance your storytelling, providing deeper context and analysis.

Example

Let's say you have two data points: the start date and end date of a project. You want to calculate the duration of the project.

  1. Log in to CoAuthor

  2. In the Projects Workspace, click on a Project

  3. In the Documents Tab, click to launch your Narrative Document

  4. In Word, click on the CoAuthor add-in in the toolbar to load the Add-In

  5. Click on the Data Sections Tab

  6. Click on the 'Create Section' button

  7. In the Create Section modal, enter a Name

  8. Select a Table

  9. Select the Subject Id Column

  10. Click 'Create'

  11. In the newly created AE Days Data Section Workspace, click on the 'Actions' button

  12. In the Actions modal, click to select 'Insert Field'

  13. In the Insert Field modal, click on the box next to the column you'd like to add

  14. Click 'Create'

  15. Enter additional text into the Word Document after the field. For this example, we will enter "experienced the following SAE"

  16. Click on the 'Actions' button

  17. In the Actions modal, click to select 'Insert Field'

  18. In the Insert Field modal, for this example, we will select the column for the adverse event term

  19. Click 'Create'

  20. Add additional text to the document

  21. Click on the 'Actions' button

  22. In the Actions modal, click 'Calculated Field'

  23. In the Calculated Field modal, enter a Name

    Note: Name can contain only letters and underscores

  24. Select the end date from the 'column' menu

  25. Select an operator from the menu

  26. Select the start date for the Value field

  27. Click 'Save'

  28. Click on the COG

  29. In the Field Settings modal, click to select 'Insert Text'

  30. In the field under TEXT TO BE INSERTED, enter days

  31. Click Save

  32. Click on the 'Preview' Tab

  33. Select an option from the 'All Subjects' menu

  34. Click on the View button for any of the listed options

Tips for Effective Use

  • Consistency: Ensure your data points are consistently formatted to avoid errors in calculations.

  • Relevance: Only compute between data points that add value to your narrative.

  • Clarity: Clearly explain the significance of the computed results within your narrative.

By following these steps, you can effectively compute between narrative data points, adding depth and precision to your writing. This capability is especially important for writers who need to analyze trends, measure impacts, or provide detailed reports based on their data.

Did this answer your question?