Menu

Lumen help

Adding a filter to sort use data

You can use filters to refine and focus summary and detail reports in Hosted Usage Analyst. When you add a filter to a report, you can select any filter that is available for that report type.

Every filter requires at least one condition. 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) or whether the operator appears in a list.

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

 

Examples:
 

  • Charge, is greater than, $x.

  • Day of Week, is equal to, Tuesday.

  • Data Volume, is greater or equal, to 5GB.

To add a filter to sort use data:

  1. Click Reports, click Voice Reports, then click Hosted Usage Analyst. 
Billing account selection
  1. Click the icon on the right side of the row for the account you want to view.
Select the application you want to log in to.
  1. Click the Usage Analyst radio button, then click OK.

    Control Center opens Hosted Usage Analyst in a new tab.
Hosted Usage Analyst
  1. Click the Setup tab.
Setup
  1. In the Tools section, click Filters.
Filters
  1. Click Add Filter.
Create Filter
  1. To select how you want to create the filter, do one of the following:

    • Select the Start with a copy of an existing filter radio button, then from the Name list, select the existing filter.

    • Select the Start a new filter of type radio button, then from the Filter Type list, select the type of report.
  1. Click Continue. (For example, we selected Start a new filter of type.)
Create Filter
  1. In the Filter Name box, type a name for your filter.
  1. In the Criteria section, select your filtering parameters from the list (Any of the following are true or All of the following are true), then click Add Condition.
  1. From the first list, select the field you want to apply the filter to (e.g., Account Number, Amount Due, Bill Date).
  1. From the second list, select a comparison operator (e.g., contains, is equal to, starts with, etc.).
  1. In the third field, type a value (e.g., $5, Tuesday, 5GB).
  1. In the Sharing section, select whether you want others to be able to view and use this filter: click Share this filter to share it; click Don't share this filter to keep your filter private.

    A shared filter can only be edited or deleted by the person who created it.
  1. Click Save.

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