Reports - Trending Reports & Graphs

Reports - Trending Reports & Graphs

This help page describes how to download data from Safari to create trending reports and graphs using Microsoft Excel.  You can build these trending reports to show trends by Type, Subtype, Entity, or any data you chose for sorting.
Video Tutorial (recording of our live training session about this topic on 11/30/2022 - 17 minutes):
The example below is how to create a trending report of new matters, organized by Type.  You can also generate similar reports using different dates, such as the Matter Closed Date, Portal Opened Date, etc.
1.  In Safari, run the All Data report (first report in the Reports list).
2.  If you want to limit the report results to a certain criteria or date range, use the filter icon  at the top of the applicable column.  For example, if you want to limit the report to matters created this year, use the filter icon for the Date Received column, then in the pop-up window click the Dates button, and choose the Between option:


3.  Export the data to a CSV file.


4.  Open the CSV file in Microsoft Excel.  (Note: If you click on the file in the download section of your browser, it should automatically open the file with Excel.  If it doesn't, go to your download folder, and right click on the file, and choose "Open with... Excel".)

The next instructions apply to Microsoft Excel.  Excel has slightly different interfaces and buttons depending on the version and whether you have a PC or an Apple computer.  So, the instructions and images might not match what you see.

5.  On the Home tab of Excel, click "Format as Table" button.


6. You'll be asked to pick a format.  Any format is fine; our preference is with minimal colors.


7.  Excel then asks you to confirm the cells to include in the table.  The cells should automatically fill in.  Make sure that "My table has headers" is checked, then click OK.

When reviewing the cell range, ignore the "$".  In the example above, the table data is contained in cells A1 through P86.

8.  Excel should put you on the "Table" tab (if not, click on the Table tab).  Then click the Summarize with PivotTable button.


9.  In the Create PivotTable window, leave the settings as shown below and click "OK."


10.  In the "PivotTable Fields" on the right, (i) click and drag the applicable date field (in this case the "Date Received) into the "Rows" box, (ii) click and drag Safari ID into the "Values" box, and (iii) click and drag Type (or you might want SubType) into the "Columns" box.  In the table on the left, click on the + to the left of the years to expand, then click on the + to the left of the quarter to see all the data.  


11.  If you don't want the quarters showing, then in the PivotTable Fields on the right click and drag "Quarters" out of the Rows box.  Then click on the "PivotChart" icon in the Excel headers to see a graph of the data (see example below).


Is there a question we haven't answeredPlease send it to us at support@safarilaw.com.
    • Related Articles

    • Reports - Creating Custom Reports

      Find Your Custom Reports The Reports List shows all reports--both Safari's "Standard" reports and your custom reports. The Standard reports are shown first (alphabetically), and then your custom reports (alphabetically). Save a New Custom Report ...
    • Reports - Standard Reports & Fields

      Data Sets and Use Cases Below is a list of the standard reports in Safari, the source of the data for each report, and common use cases. Report Data Set Matter Types Included Description / Use Case All Data Matters All Types DESCRIPTION: This report ...
    • Reports - Basics

      Safari offers you flexible, built-in reporting and data exports. This help page gives you an overview of the basic functionality. VIDEO TUTORIAL (6 minutes) - Reports - General Training Reports Standard Reports and Custom Reports Safari has a list of ...
    • Reports - FAQs

      What is the All Data Export, and when should I use that rather than the Preconfigured Reports? To download all data quickly to a spreadsheet, the All Data Export is generally the fastest way. That's because it doesn't pre-load the data into your ...
    • Reports - Export CSV Data

      Overview Safari enables you to view and export a CSV (Comma-Separated Values) file to keep tabs on when, how much, and by whom the system is being used. Such data exports are useful for recordkeeping review and for assessing security risks from ...