Ad hoc reports

Use ad hoc reports to gather information from individual subject areas or to consolidate information from multiple associated subject areas, into a single report in a custom format. For example, you can create an Opportunities report to include details from the Opportunities subject area, such as description, type, and priority, and also related details from other subject areas, such as related schedule items.

The ad hoc reporting functionality is currently only supported in Google Chrome.

Ad hoc reports are supported for the following subject areas:

• Activities
• Call Records
• Companies
• Contacts
• Deals (product opportunities)
• Documents
• Leads
• Opportunities
• Schedule Items
• Service Requests
• Tasks
• Users

Ad hoc reports display data on demand, based on the settings you define while creating the report. Ad hoc reports contain fields that may not be available in the predefined reports generated from other NexJ CRM workspaces. You can view the report along with a summary and visualization within the workspace, or export the report's summary, detail (raw data), visualization, or JSON definition to your local drive. You can search for specific reports using the available filter options.

Ad hoc reports are generated on the Reports workspace in NexJ CRM or in a standalone reporting application, depending on how ad hoc reporting is set up in your organization.

You can select a template provided by NexJ and customize it as needed, or you can create a report from scratch. An example of a template is the Scheduled activity breakdown report, which shows scheduled activities per user for a specific date range. You can keep your reports private, or you can make them available to all NexJ CRM users.

Deals templates are impacted when you select a different currency in the Currency field in the Localization tab in the User Preferences dialog. For example, the Expected Amount field of the Top 10 Open Deals template will be converted into the currency set in this dialog.

To edit the Currency setting, click User settings in the NexJ CRM toolbar, select User Preferences, and select a different value in the Currency field. After you select a different currency, you must click the Update Report button

in the Report Viewer to update the Deals report with converted values. For more information about the Report Viewer, see Report Viewer. If you are using a dashboard to view a Deals report, you must click the Update Dashboard button

in the Dashboard Viewer to view the converted currency values. For more information about the Dashboard Viewer, see Dashboard Viewer.

When you use a currency other than the default base currency, you must consider the following information for monetary values in reports:

• Shared links of a report will show monetary values based on the Currency setting in User Preferences for each user.
• Monetary conversions are based on the exchange rate when you run the report. To get the latest monetary conversions, you must rerun the report by clicking the Update Report button or Update Dashbaord button.

Your administrator must have assigned the appropriate privileges for you to view or edit ad hoc reports. Your view of data in a report is dependent on your access level, team assignment, and organizational hierarchy. It may differ from the view that other users have.

In addition to enabling custom selection and custom ordering of the report fields, ad hoc reports provide the following controls for report data and presentation:

Filters
Use search area filters to find reports, and use field filters to filter reports data. For more information about search area filters, see Reports workspace. For more information about field filters, see Report fields.

Groupings
Group data at one or more levels for your report summary.

Calculations
Select the calculations to display in your report summary.

Visualization
Choose from a variety of chart formats to visually summarize your report data.

For more information about groupings, calculations, and report visualization, see Adding groupings and calculations to the report summary and Visualizing reports.

Once you have built your reports or other users have shared their reports with you, you can set up customized dashboards with the summary, visualization, and detail from any of your reports as components.

The ad hoc reporting functionality includes the ability to schedule reports for a specific time in the future or at regular intervals, and the ability to use an existing report definition to build another report.

Reports workspace

The Reports workspace lists all the ad hoc reports you have access to, and all the dashboards that you created. Use this workspace to view, add, edit, or delete reports and dashboards.

The Reports workspace consists of the following:

• The My Reports, All Reports, My Dashboards, and All Dashboards tabs. The My Reports tab displays the reports that you created, while the All Reports tab displays all the reports that you can view, including those shared by other users. The My Dashboards tab displays the dashboards that you created. The All Dashboards tab displays all the dashboards that you can view, including those shared by other users.

  

  Report templates display as reports that can be run in All Reports. You cannot edit or delete them but you can run or clone them. Dashboard templates are also available from All Dashboards. You can clone dashboard templates to create new dashboards. Dashboard templates can only reference report templates by name, which means that dashboard templates cannot reference reports that you create on your own without using templates.

• Use predefined filters, available in the My Reports and All Reports tabs, to view reports associated with specific subject areas. Predefined filters are search filters that are provided by default on a NexJ CRM workspace. For example, click the Opportunities filter to view all reports associated with the Opportunities subject area.

  • Use the text search field to search for items using the full item name or a part of the item name. The text search field supports the * and ? wildcard characters. The * wildcard is a placeholder for a string of text of any length, including spaces, while the ? wildcard represents a single alphanumeric character.

  • Use filter chips to add search criteria or fields in combination with an existing filter. You can filter by created date, description, and last edited date. The search area includes predefined filters, text search field, and filter chips, which enable you to locate specific items. You can use these filters to find specific items within the My Reports, All Reports, My Dashboards, and All Dashboards tabs.

  • To show or hide filter chips, add filter chips, or reset filters, click the Filter options button

    

    beside the text search field.

• The data tables display a list of reports or dashboards that match your filter criteria. The Reports data table, available in the My Reports and All Reports tabs, displays reports you have access to, and the Dashboards data table, available in the My Dashboards and All Dashboards tabs, displays dashboards you have access to. You can do the following in the data tables:
  
  • Click the Add button

    

    to add a report or a dashboard.
  • Click a column header or use the Sort by button

    

    to sort the displayed results.
  • Click the Select Columns button

    

    to choose the columns to display in the data table.
  • Hover over a report or dashboard to reveal action buttons to:
    • Edit the report or dashboard

      

    • Delete the report or dashboard

      

    • Perform more actions

      

      , such as viewing the report

      

      , exporting the report definition

      

      , and cloning the report or dashboard definition

      

      

      You can edit or delete reports that you created. You can only view, export, or clone reports created by other users.

  • Use the Items per page drop-down to limit the number of items displayed per page.
  • Use the chevron buttons

    

    

    to navigate between pages to view additional items.

Example: Running a report provided by NexJ

The following video shows an example of how to run a report based on the Scheduled Activity by User template that is provided by NexJ, and use the visualization and Summary tab to retrieve detailed information.

Report Builder

Use the Report Builder to define or edit a report. Launch the Report Builder by clicking the Add Report button

The report preview only displays a subset of the report data. The report preview displays a subset of the report data. To view full report data, you must save the report, open it in the view mode, and execute the report by clicking the Update Report button

.

The Report Builder consists of the following:

• A banner with the name, description, and security setting for the report. The security setting determines whether the report is private or public.
• A report settings pane on the left-hand side with the following tabs:
  • Details
    Select the fields you want to add to your reports.
  • Summary
    Define your report summary by adding groupings and calculations.
  • Filters
    Refine your report data by applying filters to one or more of your selected fields.
• A report data pane with the following tabs:
  
  • Summary
    Displays a preview of the summary of significant report data based on the groupings and calculations you defined.
  • Visualization
    Displays a graphical preview of your data. The fields and calculations in this tab can be different from the Summary tab, depending on the settings you use.
  • Live Detail
    Displays a preview of the raw report data. It refreshes in real time as you modify your report settings. Sort the data by clicking the column headers and display additional columns using the chevron buttons

    

    

    . In Contacts, Opportunities, and Deals reports, double-click a row to view the associated record on the applicable NexJ CRM workspace. Some collections provide links to associated records on the applicable NexJ CRM workspace. For more information about collections, see Viewing fields of a collection.
    

  You can view both the summary and the visualization in full size by clicking the Expand button

  

  . This no longer applies to reports but to dashboards. May reinsert it when documenting dashboards.

• An action button to save the report

  

  , and when editing an existing report, an additional action button to revert your changes

  

  .

The following reporting actions increase operational complexity, and are expected to result in longer report execution times:

• Adding fields from associated classes
• Grouping on fields from associated classes
• Filtering on unindexed fields
• Sorting on unindexed fields

Report Viewer

The Report Viewer displays existing ad hoc reports. While the Report Builder displays a preview of your report data, the Report Viewer displays the full data as of the last executed time of the report. Launch the Report Viewer by double-clicking a report or clicking the View Report button

A report executes when the Update Report button

for the report or the Update Dashboard button

for a dashboard containing the report is clicked. It also executes when a report runs at its scheduled time.

For more information about dashboards, see Working with dashboards. For more information about scheduled reports, see Scheduling reports.

Viewing existing reports

Report fields

Fields are the basic building block of ad hoc reports. Each field represents an attribute that you want to view in the report.

You can select fields in the Details tab in the Report Builder. Conduct a direct search for fields by entering the field name in the Add Fields text search field, or click the Select button

The following filters are available for selection in the Add Fields dialog:

• String: Displays attributes with text-based values. For example, last name.
• Number: Displays attributes with numeric values. For example, expected revenue from an opportunity.
• Date: Displays attributes with date values. For example, date of birth.
• Object: Displays attributes containing sub-attributes. For example, related opportunities.

If a sub-attribute of an object is a string, the object also shows under the String filter.

By default, all attribute types are selected in the Add Fields dialog. To view attributes of a specific type, clear the checkboxes associated with other attribute types.

If you select a collection field in the Add fields dialog (for example, the Activities field for a Contacts report), and expand the field to select related fields (for example, Activity End Time or Activity Start Time), the report displays the fields of the collection grouped by the subject area (for example, the interactions grouped by contacts). In reports, collection fields can be identified by their default fields. The default field is displayed in reports to represent the selected collection whether the default field is selected or not (for example, the default field for the Activities collection is the Description field). 

Another example of a collection is the Mobile Phone field that can be expanded to select Entity, Extension, and Number. NexJ CRM enables you to enter a description and an extension with every mobile number, in addition to the number itself.

Selected fields and default fields of selected collections display as columns in the Live Detail tab. The columns refresh in real time as you add, remove, or modify fields. You reorder the fields using drag-and-drop in Selected Fields in the Details tab. If you export a report, the columns of the exported report have the fields in the order set in Selected Fields in the Details tab. However, for the columns in the Live Detail tab, selected fields are grouped to display non-collection fields first and then the default fields of selected collections. The fields in each group display in the order set in Selected Fields in the Details tab.

Fields that you can group your report summary by are available for selection in the Summary tab in the report settings pane. Fields that you can add calculations to are available in the Field drop-down in the Calculations section.

All collection fields that are numeric can be used for calculations, except those from associated subject areas.

After you add a field, you can apply filters to include or exclude specific records from the report. For some fields, multiple selection dialogs are available, where you can select specific values to include or exclude. For other fields, you can use operators, such as equals, contains, greater than, less than, between, unspecified, and so on, to define the filter. For more information about multiple selection dialogs, see Multiple selection dialogs. For information about operators supported in NexJ CRM, see Using operators.You can also apply additional, temporary filters when viewing an existing report . These filters apply only to the current view instance. They are not saved for future views of the report. When you open a report, freportilter chips for the first five columns in the report display by default. If necessary, you can add additional filter fields by clicking the Filter Options button

The maximum number of fields that you can add to a report is 200.

Viewing existing reports

To view a report, hover over the report in the Reports data table, click the More Actions button

The data in the Live Detail tab of a report automatically refreshes each time you open a report. However, you may need to click the Update Report button

When viewing a report, you can:

• Show or hide filters.
• Add temporary filters for the current report view.
• Reset any temporary filters that you added.

• Update the report to reflect the latest changes to NexJ CRM data.
• Sort the report summary and report details.
• Transpose rows to columns and columns to rows in the report summary.
• Export the report's raw data, summary, visualization, and JSON definition.
• Open details pages in NexJ CRM by clicking on links for associated objects in the Live Detail tab that have detail data (for example, people, companies, service requests, deals (and other opportunities)). For example, when you are viewing a deals report that uses the Owner field, you can click on an owner's name in the Live Detail tab to open the owner's detail page on the Contacts workspace.
• Display the report definition version, subject area name, last executed time, and if applicable, the next scheduled run time of the report in the About tab.
• Schedule reports and send reports by email to a distribution list in the About tab.

• Click the links for collections 

  

   in the Live Detail tab to see the included fields of the collection together with the default collection field. 
  

  Collections can be identified by their default fields in reports. The default field is displayed in reports to represent the selected collection whether the default field is selected or not (for example, the default field for the Activities collection is the Description field). 

For more information about how to perform these tasks, see Report fields, Modifying reports, Exporting reports, and Scheduling reports.

Viewing fields of a collection

In the Live Detail tab, the collections icon 

Some collections contain fields that have details data in NexJ CRM. These collections provide links from the Live Detail tab to the associated record on the applicable NexJ CRM workspace. For example, the following collections provide links:

• Service Requests
• Coverage Children
• Related Opportunities
• Assign To
• For
• Employees

The following screenshot shows a list of collections in the Live Detail tab for when only fields of the Products collection are selected. In the first data table row shown below, the contact has multiple products. When you click on the row, you will see a list of all of the products assigned to the contact. For the rest of the rows, the contact has one product. The Products field can contain Advisory collections, which are created based on data from contacts who have been assigned the Advisory product.

Contacts can be assigned the Advisory product in the Advisory Services type of products on the Opportunities workspace or in the Opportunities tab for a contact. Mutual fund and mortgage products are also assigned on the Opportunities workspace or in the Opportunities tab for a contact. For more information about the Opportunities workspace and Opportunities tab, see Creating and managing opportunities.

For when the Products collection is selected, you can click a collection name link to view which contact the collection is associated with, and which products, and the default field for the collection, which is Name. The following screenshot shows the dialog that displays when you click a link of the collection name. In this example, the contact has multiple products, which display in the Products data table.

Creating new reports

The Report Builder takes you through the steps needed to create a report. Select the attributes you want to view, add any filters to limit the report data, group the data and add calculations to the report summary, and define the visualization settings for the report.

You can either start with a report template provided by NexJ and customize it to your requirements, or create a blank report. You can also import a JSON file containing a report definition to view or edit as needed.

Report templates are only available for some NexJ CRM subject areas.

This procedure focuses on how to create a basic report by selecting attributes and adding filters. Further sections on this page provide information about configuring groupings, calculations, and report visualization.

To create a basic report:

1. In the My Reports or All Reports tab, click the Add Report button

   

   at the top right of the Reports data table.
2. Choose the subject area you want to generate a report for.
3. Do one of the following:
   • To use a report template, select a template.
   • To build your report from scratch, select a blank report.
   • To import a JSON file with a report definition, click the Select button

     

     next to Import Report Definition from JSON, select the file, and click Open.
4. If you selected a template or imported a JSON file, the report data is populated immediately. Skip the remaining steps in this procedure and edit the report parameters as needed. For more information, see Modifying reports.
5. Enter a meaningful name for the report, and, optionally, provide a description.
6. Optional: If you want to make your report available to all NexJ CRM users, clear the Private Report (Only for you) checkbox.

7. In the report settings pane below the Name field, in the Details tab, click the Select button, and select the attributes you want to add.

   

   If you know the names of the attributes you want to add, you can directly enter the field name in the Add Fields text search field. A similar search field is available within the Add Fields dialog. For more information about searching for attributes, see Report fields.

8. Optional: In the Filters tab, select the filters you want to apply:
   
   1. Click the field you want to filter.
   2. In the Enter Filter dialog, do one of the following:
      1. If you see a list of values you can select from, select the values you want to include.

      2. If you see fields for an operator and a text or numeric field value, select the operator and specify the values.

         

         Available operators vary based on the attribute type.

   3. Click Save.
   The fields to which you applied filters are highlighted in green.

9. Optional: In the Sorting section of the Filters tab, select the field that will apply the sorting to the report. Click the Select button

   

   and select the required fields.

   1. To limit the results set, enter the number of item rows that you want to display in the Count field.

   2. To change the sort order of the selected field to ascending or descending, click Order.

      

      When a field is chosen for sorting the report, you cannot sort the columns in the data table in the Live Detail tab.

10. Click the Save Report button

    

    .

The report opens. In the Summary and Visualization tabs, you may see a message that the report has not been executed. Click the Update Report button

If you want to schedule the report to run at a future time, change the schedule frequency as desired. For more information, see Scheduling reports.

After you execute a report by clicking the Update report button

, the report data can be viewed for 30 days before you must rerun the report for the latest data. To save report data for a specific instance in time beyond 30 days, you must export the report within 30 days. The 30-day limit is the default design-time configuration.

When you view data for a report, click the Update report button

to see the latest data.

If you notice data is not showing anymore, the data has expired, and you must click the Update report button

to generate new report data.

Adding groupings and calculations to the report summary

The report summary, displayed in the Summary tab in the Report Builder and Report Viewer, is a pivot table representation of significant statistics in a report. Groupings define the attributes you want to group the report summary by, and calculations define the aggregated statistics displayed for the attributes.

When you select a subject area and add fields to your report, NexJ CRM dynamically generates a report summary with default calculations for all aggregatable fields in the report. At minimum, the count of all items in the subject area is displayed. You can customize these calculations and group the summary data at one or more levels to improve the usefulness of your report summary.

Available calculations vary based on data type. For example, for all deals or all clients, the only available operator is count. For expected revenue, you can select between sum, average, maximum, and minimum.

You can use groupings either as rows or columns in your pivot table. If you use them as rows, calculations are the columns, and if you use them as columns, calculations are the rows.

If you add multiple groupings, you can expand the first grouping in the report summary to view additional groupings.

At any time, you can:

• Remove a grouping or calculation by clicking the Clear button

  

  on the grouping or calculation.
• Reorder the groupings through drag-and-drop to the desired location.
• Sort the report summary by clicking the column or row header containing the name of the calculation.
• Transpose data from rows to columns and columns to rows by clicking the Flip button

  

  .

This section assumes you have the report open in the edit mode. If it is open in the view mode, the Edit Report button

is displayed on the top right side, next to the Update Report button

.

As you update your groupings and calculations, the preview in the Summary tab refreshes to reflect your changes.

To add groupings and calculations to your report summary:

1. In the report settings pane on the left side of the Report Builder, select the Summary tab.

2. In the Groupings section, click the Select button

   

   , and select the fields you want to group by, or you can enter the names of the fields directly in the Add Groupings text search field.
   

   To group the report summary, you must first add fields. If the Add Groupings dialog does not display any fields, click the Details tab to add fields. You can only add single-value fields, and not collection-type fields, as groupings.

3. Click OK to close the Add Groupings dialog.
4. Optional: Repeat steps 1 to 4 as needed for additional groupings.
5. Optional: For date attributes, you can select the date view you want to use for the summary. To select the date view:
   1. Click the date attribute that you added as a grouping.
   2. In the Date Grouping dialog, select from Day, Week, Month, Quarter, and Year views.

6. In the Calculations section, in the Field drop-down, select the field you want to add a calculation for. For example, Expected Revenue.

   

   All numeric fields that you added to the report will be available for selection, except collection-type fields from associated subject areas.

7. In the Operator field, select the aggregate operator you want to use for the calculation. Choose from the following operators:
   • Average
     Returns the average of all non-null values from the selected attribute.
   • Count
     Counts the number of instances of the selected attribute.
   • Maximum
     Returns the maximum value from all non-null values of the specified expression.
   • Minimum
     Returns the minimum value from all non-null values of the specified expression.
   • Sum
     Creates totals for selected attributes.

8. Click Add Calculation.

   

   You can add only one calculation for each attribute. If you select a field that already has a calculation, an error is displayed when you click Add Calculation.

9. Optional: Repeat steps 7 to 10 as needed for additional calculations.

You have now added groupings and calculations to your report. If you want to change the display name of a calculation, you can do so by clicking the calculation and entering the desired display name in the Caption field.

Visualizing reports

The Visualization tab on the Reports workspace provides a graphical, at-a-glance view of your report data. You can select from a variety of column, bar, area, pie, line, scatter, and funnel charts.

In the visualization, each axis represents either a field that you selected or a calculation you defined. The type of data each axis represents depends on the graph type you select. For example, if you selected a column chart with deal priority on X-axis and deal count on Y-axis, when you switch to a bar chart, the deal count automatically moves to X-axis and priority to Y-axis.

Groupings do not automatically apply to visualizations. However, you can choose to include one of your groupings in the visualization. Data shown in the Visualization tab can be different from that shown in the Summary tab because the fields you choose to include in your graph can be different from the fields you select as groupings.

When you add a new field, grouping, or calculation to your report, it becomes available in the Visualization tab immediately. However, if you have already generated a visualization, for the graph to change, you must select the newly added field, grouping, or calculation in the relevant drop-down in the Visualization tab.

A legend displays to the right of the graph indicating the color coding used in the graph.

To visualize your data on the Reports workspace:

1. In the Report Builder, click the Visualization tab.
2. Do one of the following:
   1. If you do not already see a graph, select a chart type for the graph.
   2. If you see a graph and want to change the graph type, click the Chart Mode button

      

      on the top right of the graph and select a chart type.
3. Using the X-axis and Y-axis drop-downs , select the statistics you want to display on the two axes. The graph refreshes to display data based on your selections.

4. Optional: To add or remove groupings or additional calculations, do one of the following:

   1. To add a calculation, click Add X-axis or Add Y-axis, whichever is available.
   2. To remove a calculation, click the Clear button

      

      on the additional axis.
   3. To add groupings, select the Add Grouping checkbox, and select an attribute in the Grouping drop-down.
   4. To remove groupings, clear the Add Grouping checkbox.
   

   A graph can include either groupings or additional calculations, but not both. If you include groupings, the Add X-axis or Add Y-axis button is disabled. If the graph already includes more than one calculation, the Add Grouping checkbox is disabled.

5. Optional: If your visualization includes a date field, you can toggle between day, week, month, and year views for those attributes using the date view panel in the top right corner of the visualization canvas.

   

   Any date view you select only applies to the current view instance. The next time you view the report, the view reverts to the default selection.

6. Optional: To view more details on the data in a chart, click the graphical elements of the visualization. A table is displayed with more information on the data. 

   

   The collections icon

   

    on a data table indicates that the field is a collection. You click the links of a collection field to see the included fields from the collection.

7. Optional: In the Visualization tab, some fields (for example, Stage) have reorder buttons (the 

   

    Reorder Category button, the 

   

    Reorder Y-Axis button, and the 

   

    Reorder X-Axis button) that are displayed when you select those fields for Category, X-Axis, or Y-Axis. To reorder the values of the field in the visualization, click the button and drag-and-drop the values to set the order.
   
   For example, you set the Category to Stage in the Visualization tab for a funnel chart in the Deal Pipeline by stage (next 90 days) report (see the templates for Deals to find this report). To reorder the values in the funnel chart, click the

   

    Reorder Category button, and drag-and-drop the stages to adjust the order of values displayed in the funnel chart.
   

   The 

   

    Reorder Category button, the

   

    Reorder Y-Axis button, and the 

   

    Reorder X-Axis button are visible for only certain fields (for example, Stage), and the label of the button depends on the chart selected.

Scheduling reports

You can schedule your report to run once, at a future date and time, or periodically.

You can set up the report schedule in the Schedule section in the About tab in the Report Viewer. The default frequency is None, which runs the report immediately. If you want a report to run only once, but at a future time, select Once, and specify the desired date and time. If you want it to run periodically, select Daily, Weekly, or Monthly, and specify the start date and time. The report runs for the first time at the start date and time, and will continue running periodically as specified in the schedule. To automatically send a report's details to a distribution list, enter the recipients' email addresses in the Email Address Targets field.

By default, you can provide a maximum of 10 email addresses in the Email Address Targets field.

If your administrator has enabled your environment to support sending summaries and visualizations, you will also be able to send them. Click Set Schedule to save your schedule.

The raw data of a report, accessible from the Live Detail tab of the report, updates each time you open the report. The data in the Summary and Visualization tabs, however, only updates when you click the Update Report button

or when an update occurs automatically based on the schedule. Therefore, whenever you view a report, we recommend that you click the Update Report button to bring your report summary and visualization current with your report detail.

Each time a report runs as per schedule, you will receive a notification, which you can view in the Notification sidebar. In addition, the Last Updated timestamp gets updated, in the Reports data table and in the About tab of the report. The About tab also shows the next scheduled time for the report.

If a report fails to run at the scheduled time, an error displays in the Summary, Visualization, or Live Detail tab of the report, depending on where the issue occurred. If you see an error, try re-running the report by clicking the Update Report button

Report schedules are user specific. When a user runs a report, the report data is not updated for other users of the same report. Each user of a shared report must run the report individually to view any report data by clicking the Update Report button

Modifying reports

You can modify your reports by clicking the Edit Report button

• In the Reports data table, by hovering over the report.
• When viewing a report, next to the Update Report button

  

  on the top right.

Depending on your privileges, you may only be able to edit reports that you created. If you want to customize a report that you can view but not edit, clone the report and edit the clone instead. For more information, see Cloning reports.

The following table shows the changes you can save to a report, and where in the Report Builder you can make those changes.

Modification	How to modify
Edit report name	In the report banner, enter the new Name.
Add or edit report description	In the report banner, enter or edit the Description.
Make a report available to all NexJ CRM users	In the report banner, clear the Private Report (Only for you) checkbox. The icon displayed for the report in the Reports data table changes, indicating the report is no longer private.
Add fields	In the Details tab, click the Select button . You can also use the Add Fields text search field to search for specific fields and add them to your report.
Remove fields	In the Details tab, click the Clear button on the field you want to remove.
Reorder report columns	In the Details tab, drag and drop the fields to the desired position.
Apply filters on fields	In the Filters tab, click a field, and select the filter values. For some fields, you will need to select an operator and specify the values to work in conjunction with it.
Edit filters	In the Filters tab, click a filtered field, and edit the filter selection.
Remove filters	In the Filters tab, click the Clear button on the field you want to remove the filter from. To remove all filters, click the Clear Filters button above the fields list.
Add groupings	In the Summary tab, and the Groupings section, click the Select button. You can also use the Add Groupings text search field to search for specific fields to add as groupings.
Remove groupings	In the Details tab, click the Clear button on the field you no longer want to group by.
Edit grouping order	In the Summary tab, and the Groupings section, drag and drop the groupings to the desired position.
Change date grouping	In the Summary tab, and the Groupings section, click a date field to select the day, week, month, quarter, or year view.
Add or edit calculations	In the Summary tab, and the Calculations section, select the fields you want to aggregate and the operators you want to use for the calculation. To change a calculation's display name, click the calculation and enter the desired name in the Caption field.
Remove calculations	In the Details tab, click the Clear button on the calculation you want to remove.
Sort report summary	In the Summary tab above the Details data table, click the name of the calculation you want to sort by. Calculations may show as either rows or columns in your report summary. Click the row or column header associated with the calculation to sort the summary.
Sort report details	In the Details data table, click the column header associated with the attribute you want to sort by.
Transpose rows to columns and columns to rows in the report summary	In the Summary tab above the Details data table, click the Flip button .
Clear all filters	In the Filters tab, click the Clear Filters button .
Specify the attribute and primary calculation to be displayed in the visualization	In the Visualization tab, select the attribute in the X-axis drop-down and the calculation in the Y-axis drop-down.
Include additional calculations in the visualization	In the Visualization tab, click Add X-axis or Add Y-axis, whichever is available. In the new drop-down that displays, select the desired calculation. Additional calculations are supported if the visualization does not include groupings.
Include groupings in the visualization	In the Visualization tab, select the Add Grouping checkbox. In the Grouping drop-down, select the grouping you want to add to the graph. Groupings are supported if the visualization includes only one calculation.
Change graph type	In the Visualization tab, click the Chart Mode button .

After making your changes, click the Save Report button

You can also make some changes to reports in the view mode. Changes made in view mode only apply to the current view session and are not automatically applied the next time you view the report.

The following table shows changes you can make in the view mode.

Modification	How to modify
Update the report to reflect the latest data	Click the Update Report button. The time taken for a report to update depends on the amount of data in the report. You will receive a notification once the update is complete.
Sort report details	In the Details data table, click the column header associated with the attribute you want to sort by.
Sort report summary	In the Summary tab above the Details data table, click the name of the calculation you want to sort by.
Transpose rows to columns and columns to rows in the report summary	In the Summary tab above the Details data table, click the Flip button.
Change the date view	In the Visualization tab, in the Date view panel at the top right of the graph, select from the available options, which are Day, Week, Month, and Year. The date view panel is only visible if a date field is on one of the axes in your graph. It is not visible if a date field is only included as a grouping.

Sharing reports

You can share a report's URL to enable other users to easily access the report.

Before sharing a report's URL, you will need to make the report public by clearing the Private Report (Only for you) checkbox. Then, open the report, and click the Share Report button

U sers you share the report with can view the report, export the report's components, and update the report to display the latest NexJ CRM data. They cannot edit the report. However, depending on their privileges, they may be able to clone the report and edit the clone by locating the report in the All Reports tab of their reports data table. For more information, see Cloning reports .

The data displayed in the report to other users may be different from the data displayed to you, depending on their access level, team assignment, and organizational hierarchy.

Exporting reports

You can export a report's raw data in CSV format, summary in XLSX format, and visualization in PNG format. You can also export a report's definition in JSON format to share it with specific users.

You must run a report before you can export the report. Exporting the report does not refresh the data in the report. The exported report uses the data from the last time you clicked the Update report button

or when the report ran as a scheduled report.

To export a report:

1. Open the report in view mode. See Viewing existing reports.
2. Click the Export Report button

   

   .

3. Do one of the following:

   1. To export the report definition, select Export Definition.
   2. To export the report summary, select Export Summary.
   3. To export the report visualization, select Export Chart.

   4. To export the raw data, select Export Detail.

      

      For Export Detail, when a report has a collection and is exported to a CSV file, the fields of the report are repeated in columns for each related collection value listed.
      

      Export Detail can export the fields of only one collection. The first field of a collection in Selected Fields in the Details tab sets that collection as the collection to be exported. To set a different collection for export, reorder the fields in Selected Fields in the Details tab.

   5. To export the report and email the exported results to a distribution list, select Share By Email. In the Send Email Results dialog, enter the list of email addresses for recipients separated by semicolons. By default, you can provide a maximum of 10 email addresses.
      Attachments and links to files for summaries, visualizations, and details are available through the email sent. The maximum file size for an attachment is 5 MB. The links to files are available on the server for 30 days before expiring.

      

      You can also export a report definition by clicking the More Options button

      

      for the report in the reports data table.

4. Specify the location for the exported file.

The file is saved to the specified location. The default file name is in the following format: <reportName>_<typeOfExport> (for example, <reportName>_summary.xlsx ). The column order in the CSV and XLS files is the same as when viewing the report.

The default maximum limit for an exported CSV file is 10,000 rows.

Cloning reports

You can clone a report as a base to build another report. You can use this feature, for example, to build the same report with two different summary or visualization representations.

To clone a report:

1. Hover over the report in the reports data table or open the report to view.
2. Under the More options button

   

   , select Clone Definition.

The new report opens. It will have the same name as the original report but preceded by "CLONE -". If you want the report to reflect the latest data, click the Update Report button

If a report has multiple clones with similar names, you can use the Created timestamp in the reports data table to identify the most recent clone.

Dashboard Viewer

The Dashboard Viewer displays existing dashboards. While the Dashboard Builder displays a preview of your dashboard, the Dashboard Viewer displays the full data as of the last executed time of the reports on the dashboard. Launch the Dashboard Viewer by clicking a dashboard.

For more information about the actions you can perform in the Dashboard Viewer, see Working with dashboards.

Working with dashboards

Dashboards enable you to view data from multiple reports simultaneously, on a single canvas. By organizing components from related reports into a single dashboard, you can get a high-level summary that provides quick and helpful insights into the data contained in the reports. The components could be summary, visualization, or detailed data from any of the reports that you have access to. You can control the size of a dashboard as well as its individual components. Using drag-and-drop, you can reposition the components to suit your needs.

NexJ also provides dashboard templates in the All Dashboards tab, for example, the Deal Management Dashboard.

To create a dashboard:

1. In the My Dashboards tab or All Dashboards tab, click the Add Dashboard button

   

   at the top right of the Dashboards data table.
2. Enter a meaningful name for the dashboard, and, optionally, provide a description.

3. Optional: To edit the row height and the number of columns in the dashboard, click the Settings button

   

   .
   

   The row height effectively represents the height of individual components in a dashboard, and the number of columns determines the number of components displayed in each row. Adjust the row height and the number of columns as necessary for an optimal view.

4. Click the Add Dashboard Item button to add the first component of the dashboard. Adding a component involves:

   1. Optionally, adding a caption title for the component.
   2. Optionally, adding a description for the component.
   3. Selecting the report.
   4. Choosing between the report summary, visualization, or detail.

   5. Optionally, setting the number of rows and columns the component should occupy on the dashboard. The default selection is 1 row and 1 column. The maximum number of columns is the limit you set for the dashboard (see step 3).

5. Repeat the previous step as needed for additional components.

   

   If a dashboard component displays a message that the report has not been executed yet, click the Update Dashboard button

   

   after saving your changes . This executes all the reports in the dashboards so they reflect the latest data. For dashboards that contain report summaries or visualizations, we recommend executing the reports periodically to ensure latest data. If a component displays no data even after executing the report, check the report settings and confirm there is matching data.

6. Optional: Use drag-and-drop to resize or reorder the dashboard components as desired. As you resize a component through drag-and-drop, the values in the Rows and Columns fields in the component settings (accessible by clicking the Settings button) update to reflect the new size.

The dashboard is created. You can access it at any time by double-clicking it in the Dashboards data table. If the components of a dashboard are from a single subject area, you can filter your dashboard data by clicking the Filter Options button

To edit or delete a dashboard, click the Edit button

Example: Creating a dashboard

The following video shows an example of how to create a dashboard with three dashboard components, and how to resize a component by changing the Rows field's value and using drag-and-drop.

Cloning dashboards

You can clone a dashboard as a base to build another dashboard.

To clone a dashboard, hover over the dashboard in the dashboards data table and click the Clone Definition button

If a dashboard has multiple clones with similar names, you can use the Created timestamp in the dashboards data table to identify the most recent clone.

Example: Tracking activities through ad hoc reports

Lucas, a branch manager, needs to regularly track the progress of activities assigned to his branch staff. His team's activity backlog has increased in size over the past two quarters. He wants to get the backlog under control while also ensuring the team's current activities are not affected. To prioritize work assignments and to monitor his team's performance on an ongoing basis, Lucas creates the following reports:

Overdue Tasks

Lucas uses a report shared by another manager as the base for his team's overdue tasks report. After cloning the report and renaming it, Lucas customizes the report, ensuring the following:

• The Description, Priority, Due Date, Status, and Assign to fields are selected.
• Filters are applied on the Due Date and Status fields so that completed and canceled activities are excluded, and only activities due today or before are included.
• The Status field is added as a grouping.
• The Column Stacked chart type is selected for the visualization, with the X-Axis set to Assign To and with the Status grouping added.

The following video shows how Lucas clones the report, edits it to rename it, adds the missing Priority field, changes the operator for the Due Date filter, excludes completed and canceled activities, adds the grouping, and saves it before running it.

Upcoming Activities

To track the activities starting in the next 30 days, Lucas uses the Scheduled activity breakdown report template, which already includes most of the fields he needs in the report. He edits the number of days in the report description to 30, and also renames the report. He removes the End Time field and adds the Start Time field. He sets the Start Time filter to in the next 30 days and sets the Status filter to exclude canceled activities (completed activities are already excluded in the template). He adds the Start Time field as a grouping. He selects the Summary tab in the report data pane to show the live feedback when he modifies the Start Time grouping. He sets the Start Time grouping to be done by week. He moves this grouping to the top of the list, so that the summary is broken down by the start time first and can be expanded to view other groupings. He wants the visualization to show activities broken down per user per activity, so he verifies that Assign To is selected for the X-Axis and adds the Type grouping to the visualization. He retains the Stacked Column chart type, which was preset in the template, and saves the report before running it. He selects the Summary tab in the Report Viewer and expands some of the items to show resultant groupings.

The following videos shows how Lucas creates the upcoming activities report.

Priority Breakdown

Lucas needs to ensure that high-priority activities are completed as scheduled. An at-a-glance view of upcoming activites by priority level would help him keep track of such activities. He clones the Upcoming Activities report that he set up earlier, adding the Priority field. He changes the X-Axis to Priority and selects Pie Donut as the chart mode.

Completed Activities

An important performance metric for Lucas' team are completed activities, so he wants to keep track of the total activities completed by each of his team members in the last 30 days. For this, he could use a Completed activities breakdown report template, but since he only needed a simple report with the overall numbers per agent, he decides to create an activity report with just three fields - Assign To, Activity End Time, and Status. He sets filters on the Status and Activity End Time fields so that only activities that were "completed" and in the previous 30 days are included. He configures the visualization as a Bar chart with no groupings added and saves the report.

The following video shows how Lucas creates the completed activities report.

After creating the reports, he proceeds to clone and edit the Activity Management Dashboard, selecting the relevant components from his reports, and reordering and resizing the components as needed. The following image shows how the dashboard looks once he puts it together. For more information about cloning a dashboard, see Cloning dashboards.