Back

Custom Views

Contents

Introduction

Build a Custom View

Step 1: Create a Bulk Report

Step 2: Create a Saved Search

Step 3: Create a Custom View

Step 4: Filter and Sort the Results

Step 5: Export the Data to a Spreadsheet

Customize a Custom View

Update a Custom View with New Data

Copy a Custom View

Update Custom View Grouping

Delete a Custom View

Customize the Custom Views Page

Maximize Your Work Area

Sort a Column in a Custom View

Clear a Column Filter

Save Custom View Display Settings

 

Introduction

Custom Views combine the filtering of saved searches and reporting of bulk reports to give you powerful data mining capabilities. They allow you to run bulk reports based on saved searches and then filter the bulk reports directly on your screen. Flexible grouping and aggregation options allow you to narrow the data further. Finally, you can export the data to a spreadsheet, if needed.

You can use saved searches to drill down to actionable details—for example, you could look at all accounts holding a security that is maturing in the next 30 days. You can then sort and group the results further, if needed.

With all these customization options, Custom Views allow you to easily find and access the data in the way that is most useful to you.

Build a Custom View

The simple process of creating a custom view is as follows: 

  1. Create a bulk report

  2. Create a saved search

  3. Create your custom view

  4. Filter and sort the results as needed

  5. Export the data, if needed

The following sections will go through the process of creating a custom view.

Step 1: Create a Bulk Report

Bulk reports allow you to create reports based on the data parameters you set. First, you select the report type to determine what information you want to include in the report—for example, the Account Information bulk report displays account details—and then customize which columns of data you want to include in that bulk report.

For more thorough information on creating a bulk report, see Create, Edit, and Delete Bulk Reports.

For details on the bulk report types you can create, see Bulk Report Descriptions.

Step 2: Create a Saved Search

Saved searches allow you to add filters to your data. You can use data filters such as Tax Status and Account Type to narrow your results. You can also nest your saved search filters with filter sets to further narrow your results and make your results more precise. You'll be applying these filters to your bulk reports to narrow down the data in your custom view.

For more thorough information on creating a saved search, see Create, Edit, and Delete Saved Searches.

For details on the search filters you can use to create your saved searches, see Search Filters.

Step 3: Create a Custom View

After you've created a bulk report and saved search, create a custom view using these steps: 

  1. On the Reports menu, under Global Reports, click Custom Views.

  2. Click Create New.

  3. Type a name for the custom view in the Name box. Other employees in your firm will see this name, so it's recommended you use a name that's specific and easy to understand.

  4. Select the bulk report you want to use in the Bulk report list. This choice determines the columns that will be visible on your screen. The bulk report you choose should be limited to 20 columns or fewer.

  5. Select the saved search you want to use in the Saved search list. Only accounts or securities that meet the criteria of the saved search will appear on the custom view.

  6. Optional: select any of these items that might apply: 

  7. Click Save or Save & Generate. Save & Generate generates the data for you. This may take some time depending on the amount of data you've selected.

Step 4: Filter and Sort the Results

Once you've created a custom view, you can now filter and aggregate the data on your custom view to further drill down and find the data you need.

Steps to Filter and Sort Results

To filter and aggregate the data in your custom view, follow these steps: 

  1. Select the custom view you've created in the Custom view list.

  2. In the View list, filter the results by the listed account sets, if needed. Use All Accounts to see all accounts.

  3. Click . This opens the Configure Grouping and Aggregation dialog box where you'll see the columns found in your bulk report.

  4. Select an option in the Action column to determine which columns will be shown and how they'll be shown. These are your options: 

  5. Optional: set additional filter options in the Filter column. This lets you filter data by either pre-aggregated or post-aggregated values.

  6. Optional: select or clear the Show grand totals check box. This determines whether totals will display for the values of all the groups.

  7. Click Save & Apply.

You'll see the columns you selected, grouped, and aggregated to provide a summary view.

Example

You want to view account values for accounts assigned to a particular advisor. To do this, you first create the Account Information bulk report so that it contains columns such as Rebalancing Account Value and Total Account Value. Then, you create a saved search to specify a particular advisor, and use these to create your custom view.

Once you've created this view, you can select the Show grand totals check box to see the totals for numeric columns, such as Total Account Value.

In addition, you can group by other columns included in your bulk report, such as the model assigned to each account, or the tax status of each account.

Step 5: Export the Data to a Spreadsheet

After you've created your custom view and customized the filtering and sorting, you can export the data to Excel or your spreadsheet program.

To export a custom view to Microsoft Excel, click Export Data at the top of the page.

Export Data filenames use the view name and include the date and time so you can easily identify your exported files.

Customize a Custom View

Once you've created your custom view, you can customize the view and the Custom View page in the following ways.

Update a Custom View with New Data

Once you've created your custom view, follow these steps to update the view with new accounts or securities that meet the saved search criteria.

  1. On the Reports menu, click Custom Views.

  2. Select the custom view you want to update in the Custom view list.

  3. Click Regenerate.

Copy a Custom View

If an existing custom view is close to what you want to set up, you can clone it and create a variation of the original custom view.

To copy a custom view, follow these steps:

  1. Click Custom Views on the Reports menu.

  2. In the View list, select the accounts this view will use.

  3. In the Custom view list, select the custom view you want to clone.

  4. Click Edit.

  5. In the Name box, type the name of your new custom view.

  6. In the Bulk report list, select the bulk report you want to use.

  7. In the Saved search list, select the saved search you want to use.

  8. Optional: If you want to share your custom view, click the Share custom view check box.

  9. Optional: If you want to save this custom view temporarily, without having to remember to go back and delete it later, click the Save for today only check box.

  10. Click Save as New.

Update Custom View Grouping

To edit grouping on the Custom Views page, follow these steps:

  1. On the Reports menu, click Custom Views.

  2. Select the custom view you want to update in the Custom view list.

  3. Click . This opens the Configure Grouping and Aggregation dialog box where you'll see the columns found in your bulk report.

  4. Make the desired changes by omitting columns you don't want to see, and grouping or aggregating any columns you do want to see.

  5. Click Save & Apply.

Delete a Custom View

To delete a custom view, follow these steps:

  1. On the Reports menu, click Custom Views.

  2. In the Custom view list, click the custom view that you want to delete, and then click Edit.

  1. On the Edit Custom View dialog, click Delete.

Customize the Custom Views Page

As you work in a custom view, you can change to customize the way you see the data on the page in the following ways.

Maximize Your Work Area

If you have a large number of groups to view, you can expand your work area by clicking the button under the name of the view.

When you're ready to work in the normal view again, click the button.

Sort a Column in a Custom View

To sort a column, click the column headings you want to sort. You will see an up or down arrow next to the heading showing that the field is sorted in ascending or descending order.

Clear a Column Filter

If you want to undo a column that you've filtered, follow these steps:

  1. Click the filter button () that appears on the column heading.

  2. Click Clear.

Save Custom View Display Settings

You can save all of your display settings by clicking the button on the Custom Views page so you won't have to set up the view each time. All settings, including custom column widths, filter options, and sorting will be saved. If it's a shared custom view, all other users will also have these settings applied the next time they use the report.