Charts can be built using the datasets described below. Click on a dataset name below to see column definitions for each dataset (you must be logged into SimpleLegal to access). To see a full list of column names and their definitions for all datasets, click here.
| Dataset | Description/Notes |
| Invoice Line Item Level Spend |
Data for invoice line items in your environment ranging from general attributes for associated matters to spend-related totals. Useful for reporting on line item level to determine if billed rates are consistent with billed amounts for various task, activity, and expense codes. |
| Invoice Allocations Level Spend |
Data for invoice-level allocations in your environment ranging from general attributes for associated matters to spend-related totals. Useful for reporting on amounts allocated against accounting code sets to determine how respective allocation amounts are being tracked and utilized. This is the underlying dataset used for spend-based reports built using the Adhoc Reports Builder and the baseline dataset used in out-of-the-box spend reports provided for Enhanced Reporting (e.g., Spend Grids, Billed Matters, etc.). |
| Matters |
Data for matters in your environment ranging from Legal Entities and Vendors to important activity/billing dates. Useful for reporting back on matter attributes, both general and custom, to further break down or compare the distribution of legal entities, matter leads, and vendors across matters. |
| Vendors |
Data for vendor records in your environment, such as recent billing activity and associated Vendor Groups (if applicable). Useful for highlighting or comparing matter volume across vendors or determining distribution of matters across vendors based on location, Vendor Groups, or other attributes. |
| Timekeepers |
Data for timekeepers who bill for work on matters in your environment, including rates and spend totals. Useful for showcasing rates over time for comparison and providing better visibility into approvals vs. rejections for submission. |
| Budgets |
Data for approved budgets in your environment, including information related to budget health. Useful for providing better visibility on amounts/performance for both internal and external (if applicable) budgets at the matter or firm level. |
| SimpleReview (if applicable) |
Data recorded for AI rules in your environment, including rule performance and vendor insights. Only applies if SimpleReview is enabled for AI-driven invoice review. Useful for seeing potential savings attached to flagged line items and which rules provide the largest and smallest amounts of potential savings. |
Additional Notes
For best results when building or editing charts:
- Be familiar with the datasets available in your environment (including custom attributes)
- Know your goal and/or which insights your chart is intended to provide
- Determine which chart type is best suited to visualize your data
- Confirm whether any existing charts address your need or can be cloned/customized
Data Types
Column names available for datasets are separated into the types described below. This applies to general attributes, standard system fields, and custom attributes.
- Dates: Dates or timestamps recorded in SimpleLegal for various activities or actions, such as Invoice Received Date, Matter Opened Date, or Effective Date.
- Text: Text-based or alphanumeric values added or selected by users in SimpleLegal or automatically generated by the system, such as statuses, descriptions, or other attributes.
- Numeric: Numeric-only values for quantities, financial amounts, or system-generated IDs, such as Invoice Total, Final Spend, Billed Hours, or Matter ID.
- T/F: Refers to fields that show TRUE/FALSE values to indicate whether a feature/functionality is enabled or disabled (e.g., Accruals Enabled) or whether a field is populated or blank.
- Functions: Applies only to metrics used in out-of-the-box reports provided by SimpleLegal. These metrics cannot be used or selected when building new charts from scratch.
Custom Attributes
Custom attributes can be used to build new charts for the following datasets: Invoice Line Item Level Spend, Invoice Allocations Level Spend, Matters, Vendors, and Timekeepers.
NOTE: Which custom attributes can be used for specific charts depends on the selected dataset. For more information, please make sure to review the Datasets for Enhanced Reporting section.
Go to Administration > Custom Attributes in SimpleLegal to see the list of custom attributes in your environment and relevant information, such as field type and associated record types.
To export custom attributes as a spreadsheet for reference and further filtering, click Download XLSX above the list.
Review the following notes and other considerations about custom attributes before moving forward with chart configuration:
- New custom attributes added to SimpleLegal will not be pushed into datasets until:
- The custom attribute is present in at least one record (e.g., at least one matter)
- The 24-hour data refresh cycle for Enhanced Reporting has passed
- A custom attribute will only appear as a column option if the following applies:
- It is active in SimpleLegal
- It is scoped to at least one record type (i.e., Attribute Scope)
- It is present in at least one record (e.g., at least one matter)
- If a custom attribute used in a chart is later edited or deleted in SimpleLegal, the chart will no longer work. Make sure to edit charts accordingly when custom attributes are updated.
- Whether a custom attribute is available as a column option depends on the selected dataset.
The table below shows the naming convention for custom attributes that appear in datasets. The naming convention is driven by the Attribute Scope, which can be found under the last column under Administration > Custom Attributes and refers to the type of record(s) the custom attribute is designated for in SimpleLegal. For more information about custom attributes, click here.
| Attribute Scope | Column Naming Convention |
| Matter | Matter Attribute [Attribute-Name] (e.g., Matter Attribute Department) |
| Legal Entity | Legal Entity Attribute [Attribute-Name] (e.g., Legal Entity POC) |
| Purchase Order | Purchase Order Attribute [Attribute-Name] (e.g., Purchase Order Attribute Expense Code) |
| Invoice | Invoice Attribute [Attribute-Name] (e.g., Invoice Attribute Department) |
| Vendor | Vendor Attribute [Attribute-Name] (e.g., Vendor Attribute Region) |
If a custom attribute has more than one record type under Attribute Scope, there will be separate instances of it under the column names to help users choose the relevant option. Each one will be prefixed with the record type. For example, if a custom attribute "Project Type" is scoped for both matters and vendors, the columns would show "Matter Attribute Project Type" and "Vendor Attribute Project Type." See the image below as an example:
The list below shows which custom attributes are available for each Enhanced Reporting dataset as of July 2022:
- Invoice Line Item Level Spend: Matters, Vendors, Invoices & Purchase Orders
- Invoice Allocations Level Spend: Matters, Vendors, Invoices, Purchase Orders & Allocations
- Matters: Matters & Vendors
- Vendors: Matters & Vendors
- Budgets: None
- Timekeepers: None
Comments
0 comments
Article is closed for comments.