Skip to main content

Building a Report

A report is a set of filters. Each filter narrows your book a little more, such as active clients, with an MAPD plan, in Miami County.

Step 1 — Choose what to filter by

In the Report Builder, click Select... in the empty row under Filter by and pick a field. Fields are grouped: Individual, Address, Provider, Pharmacy, Rx, Policy and CMS Plan Changes.


Step 2 — Choose IS or IS NOT

Under Match, leave IS to include clients who match, or switch to IS NOT to leave them out.


Step 3 — Refine

What you see under Refine depends on the field:

  • A list of choices — click Select..., check one or more values, then click Add filter. Use the Search box to find a value in a long list.

  • A date range — pick a From date, a To date, or both, then click Add.

  • A text box — type part of the value, such as a doctor's last name, and press Enter.

Good to know: Lists such as Source, City, Company, Pharmacy and Rx only show values that are already in your book.


Step 4 — Add more filters and run

Each filter you add gets its own row, and a new empty row appears below it. When you're done, click Run Report.

Heads Up: Changing a filter doesn't update the results by itself. Click Run Report each time you change something.


How filters combine

  • Different rows all have to match. Status is Active Client and Policy Type is MAPD.

  • Values in the same row are either/or. County is Miami or Montgomery.

  • Policy filters have to match on the same policy. Policy Type MAPD plus Company Humana finds clients with a Humana MAPD plan, not clients who have an MAPD plan and a separate Humana plan.

  • IS NOT on a policy filter leaves out any client who has a matching policy, even if they have other policies too.


Changing or removing a filter

  • Click the x on a value to remove it, or the arrow at the end of the row to pick more.

  • Click the trash icon to remove the whole row.

  • Click Clear to remove every filter and show everyone in your book.

If a row is missing its Refine value, you'll see Please refine your filter selection before running the report. Finish or remove that row.

Did this answer your question?