Facts & Issues

Location: Analysis->Facts & Issues


The Facts & Issues feature is used to create and edit facts, issues, and dynamic timelines specific to a case. Facts may be associated with one or more issues. Each fact may link to one or more underlying documents which support the fact. Facts with dates automatically display in dynamic timelines.  Facts are document specific not email specific, meaning that a fact will not propagate across all documents in an email family. The Facts & Issues page is divided into several parts as discussed below.  


Instructional Video:

For video instruction on crafting facts and issues in LEP, follow this link.


View Current Issues.  The Issues window displays a Microsoft Explorer tree view of all the issues that have been created in a particular case. Click on an issue to make it the Current Issue, as well as display all facts in the fact table associated with the issue.

Create New Issue.  Click the Create New Issue button in the lower left portion of Facts & Issues screen (below Issues window). 

The New Issue will appear in the Yellow Highlighted Portion of the Facts & Issues Screen. To input the title of the Issue and a brief explanation (optional), click Edit.

Click Update to save changes made to the newly created Issue.

Edit an Issue.  Click Edit and then Update to save changes.

Delete an Issue.  Click on an issue to select it. Then click Delete at the top of the main table.  After clicking Delete, a new window will display the following message:

Select OK to delete the selected Issue. 


Create New Fact
.  To create a Fact in connection with an issue, 
click the Create New Fact button. A new window will open to allow edits to the Fact as detailed below. 
Title. Enter the substance of the fact in the Title field. Facts are easier to work with when the Title refers to one fact and not several facts or a compound fact.
Task Date Start and End. The Start field indicates the start date for a fact and the End field, the end date. If the fact occurs on a single date, enter that date in both the Start and End columns. 
Doc/Page. Allows the user to associate a fact to a specific page of one document. 
Contested. The Contested field allows the user to indicate whether a fact is contested or uncontested and if contested, by whom. 
Material. The Material field indicates whether a fact is material, not material, or undecided.
Assign Docs to Fact. The documents field allows the user to associate one or more documents with a fact and allows the user to track a fact to its source or sources to prove up.
Assign Custodians to Fact. This field allows the user to associate one or more custodians with a fact. 
Assign Facts to Issues. This allows the user to associate facts with one or more Issues of the case. 
Update or Cancel. When the user has entered the fact, click Update to save or Cancel to undo.
Need to Sometimes Scroll Down Page. If there are a large number of facts and the user wants to add a new fact, sometimes the user must scroll down the page to find the new fact entry area. 

The user may keep track of all key facts from the feature Show Fields. This action will display selected columns on the main table, listing specific information related to the Facts.

Edit a Fact.  Click Edit. 

Delete a Fact.  To delete a Fact, select the box next to the fact.  Click Delete->Delete Selected Facts on the left side of the window. Note: The user might choose to download all facts to Excel as a backup before deleting any Facts.

Assign Existing Facts to a Selected Issue

Existing Facts can be assigned to one or more issues. To select an issue, click on the desired issue (upper left of the screen).

Keyword Search 

Narrow a search by typing information from one field to find a specific fact. This feature looks for matching facts and issues that contain one or more words specified by the user (e.g. NationsBank). 

View Issues and Associated Facts

To view a particular issue and its assigned facts, click on the issue folder in the Issues window. Every issue will display all assigned facts and a corresponding timeline. Click any of the column headings to re-sort the timeline by that field. Click on the Title/Start/End/ bar to sort Facts in ascending order.  Click again to sort facts in descending order.  For example, clicking the Start Date heading places all the Facts in time order and clicking the Title heading places them in alphabetic order. The user may also view the full content of the fact Title through a popup window by placing the mouse over the fact icon.

Timeline View

The timeline header (upper right) shows the time scale and is automatically generated from the facts in the view. Each red bar shows the amount of time from start to end for the particular fact.
Export to Pivot (Sorting Facts by Issues)

Admin Users have the Export to Pivot button available in the lower left of the screen within the Facts & Issues page. This option will export the facts in a "flattened" format.  

The Export to Pivot button exports all facts to Excel, with facts repeated, one row per fact. This allows the user to easily create Pivot tables in Excel of the Facts data. In Excel, select all the exported data and click Create Pivot Table from the Insert menu. Insert the table in a new sheet. In the newly created pivot table, add Issues to the Report Filter area then Add Fact Title and Doc Title to the Row Labels. Before exporting Facts to an Excel spreadsheet, the columns Issues and Documents must both be checked under the Show Fields section.  In the main table, select all facts and then click on the Export->Export to Pivot button.

More information about Excel Pivots may be found in Excel help pages.

Export to Briefcase

The Export to Briefcase button allows the user to copy some or all Facts & Issues from a case onto a local computer or network in a zip file. To complete this function, click on the Export to Briefcase button. 

Import from Excel Sheet

The user may import new Facts to the case or edit existing ones (files must be in Excel 2007, 2010 or 2013 formats with an extension of .xls or .xlsx).  

Open the Facts & Issues page.
Filter on the Issue to modify if you are editing existing Facts.
Select the columns (fields) to be modified from the Fields->Show Fields section (see list below): 

Fact Id- The unique identification number that the Lexbe eDiscovery Platform (LEP) will use to associate metadata to the respective Facts & Issue to process an update. If editing existing Facts, this column must be retainedFor new Facts, just leave the rows under the column blank. 

Fact Title: Create new facts or edit existing ones.
Date Start: MM/DD/YYYY.  If no time is referenced, Excel will, by design, default to 12:00:00 AM.  To remove the default time reference, perform a 'Find and Replace' wiithin Excel.  I.e. Find 12:00:00 AM and replace with empty text.
Date EndMM/DD/YYYY.  
If no time is referenced, Excel will, by design, default to 12:00:00 AM.  To remove the default time reference, perform a 'Find and Replace' wiithin Excel.  I.e. Find 12:00:00 AM and replace with empty text.
ContestedYes (by us, by them), No, Prospective or Unsure.
Material: Yes, No or Unsure.
DocsLink the facts to specific documents and pages in the case. Use single quotation marks format (e.g. 'Document Title' (p.01)). If the user would like to include more than one document, use commas to separate the titles. (e.g. 'Document Title 01' (p.03), 'Document Title 03' (p.8)).
Custodians: The user may only edit existing Custodians.  The export of Custodians must also have the single quotation marks format. See Custodians for more information.
Issue: Create new issues or edit issue statements of fact which are being put to the test. Use the single quotation marks format. (e.g. 'New Issue').
Go to the Export section.  Click on the Export Log to Excel button.
Save the Excel sheet to local computer
Click on the Choose File button and select the Excel spreadsheet prepared from LEP.
Click the Import button. Allow a couple of minutes for the facts to be processed and populated.
Refresh the page to see the newly imported Facts.

Import Facts From CaseMap

The Import feature has the ability to import facts from the CaseMap management system, with the exception of the Custodian field which is not part of the import load file.  On the Facts & Issues page, the user may assign Custodians, Documents, Issues and Task Date Start/ End to a Fact, after importing it to LEP by clicking on the Edit link.

Add Documents to an Existing Fact from the Facts & Issues Page

From the main table click the Edit hyperlink to open a specific fact to be linked to one or more documents.

The hyperlink will open the Fact table. Under the section Assign Docs To Fact type or paste the title of one or more documents to be added to the selected fact, and click on Update
. Copy by the title of any document from the Browse, Search or Document Viewer pages.

The main table in the Facts & Issues page will update automatically.

Add Documents to an Existing Fact from the Document Viewer

Open any file in LEP by right-clicking the title from the Browse or Search pages or click the title under the Docs field from the Facts & Issues page. The user will be redirected to the Document Viewer page.  Create facts and assign documents under the Facts tab as shown below:

To assign to an existing fact to the current document, hover the mouse over the drop-down list under the Add Doc to Existing Fact section.

Create List Of Documents Related to Facts/Issues/Custodians

To create a list of documents related to Facts, select the fact or facts.  Click Export->Export to Excel from the bottom-left menu.
To create a list of documents related to an Issue, select the issue from the top-left menu.  Click Export->Export to Excel from the bottom-left menu.
To obtain a list of documents related to a specific Custodian, select the custodian from the left filter menu.  Click Export->Export to Excel from the bottom-left menu.
To download a document related to particular facts, issues or custodians, go through the above steps and select Export->Export to Briefcase.