Document Count at 30, 60, 90 Days for #LoggedInUserClientID#

Description

A chart that displays the total number of documents loaded into a workspace at the 30, 60 and 90 day mark for the workspaces existence.  This data is presented for all workspaces for a given client artifact ID.  This chart can automatically adapt to the Relativity client artifact ID for the user viewing the chart by using the #LoggedInUserClientID# token.

This script will iterate through each workspace associated with the client ID of the user who is currently logged into Relativity and get the total document count at the time intervals of 30, 60 and 90 days since the workspace was created.  If there are no documents for that workspace it will return 0 for all values.  

This script can be modified to return the data for a specific Client ID be replacing the #LoggedInUserClientID# token with a specific client artifact ID.

The following example shows a bar chart with one workspace that had 2500 documents loaded into it immediately after creation.  This chart is useful to visually see the growth of a workspace in terms of document loading over the first 30 months of creation.

Example

Chart Types

 This SQL script is compatible with the following chart types:

• Bar Chart
• Table Chart

Where to Use

This script should only be used in the admin level Broadcast tab.

How to Use

This chart is usable out of the box.  Save the attached script and copy and paste it into either a bar or table chart in the admin level Broadcast tab.

Relativity Versions Tested On

• 9.2.X - 9.2.363.2
• 9.3.X - 9.3.452.1

Learn more about the full functionality of Broadcast and Reporting Packs at Milyli.com, or contact sales@milyli.com to see Broadcast in action.

Current Broadcast customers: Contact support@milyli.com to schedule your upgrade now. 

If you'd like to learn more about our other Relativity applications, visit our Products page. Looking for a custom Relativity solution? We can help with that! Visit our Relativity Services page to learn how.