Business support

Creating an advanced filter to sort use data in Usage Analyst

You can build an advanced data filter—with ALL/ANY combinations, searchable strings, and up to 50 rows of criteria in Usage Analyst. Refine your data searches, zero in on key trends, and generate more insightful reports.

To set up data search conditions for an advanced filter, use Condition Builder. Every filter requires at least one condition. With Condition Builder, you use three components to set up a data filter condition:
 

  • Reporting field—a piece of data (e.g., area code, account number, duration, originating city).

  • Comparison operator—how the relationship between the reporting field and value will be tested (e.g., contains, does not contain, is equal to).

  • Value—what the reporting field is being compared to.

Examples:
 

  • Billing account number, is equal to, 0000000.

  • Call area, does not contain, 303.

To create an advanced filter for sorting use data:

  1. Click the Reports tab, then click the Voice Reports subtab. 
  1. Click Usage Analyst.

Control Center opens Usage Analyst in a separate window.

  1. Click the Setup tab.
  1. In the Tools box, click Filters.
  1. Click Add Filters

    You can have up to 50 rows for each filter. The last row cannot be a group. Each group needs a condition. A filter cannot be saved if a group ends without a condition row. If a group contains no condition and ends, you'll get an error message.
  1. Click Next for Condition Builder.
  1. Select how you want to create your filter:

    • From the Create a filter of report type list, select a report type.

    • From the Start with a copy of an existing filter list, select an existing filter.

      An existing filter will only apply to the related report type. For example, if you create a filter based on Call Usage LD, the filter will only work with CDR reports.
  1. Click Next.
  1. Enter a name for the filter, add conditions, then select the radio button for whether you want to share the filter. 

    When you share a filter with other users in your organization, those users who are at or below your level in the master hierarchy will be able to use it, but they won't be able to edit or delete it.
  1. Click Save.

New filters appear on the filter page (though you may need to scroll down to see them). If you've shared a filter, there'll be a notation in the shared column.

Not quite right?
Try one of these other, popular search topics:
        Billing support
        Call routing
        Notifications
        Repair tickets
        User profiles