Table functionality

Tables are used throughout Clinical Analytics to organize data and make it easier for users to find specific information. Tables serve a number of purposes in Clinical Analytics and all share the same functions, though the mix of functions in each table may vary. Data tables are used in scorecard sections like Physician Service Details and Coding Analytics, on Profiles pages, and as the main feature in the Details section.

Sort data

The small black arrows next to the column name sort the values numerically or alphabetically.

Click the arrows once to sort the column in ascending order and a click a second time to sort the column in descending order.

Filter data

Some table columns have a white box at the top where you can type in a search term. Enter a keyword to filter the data; only values in the column containing the characters you enter are returned.

NOTE: When filtering on a value (for example, 12), the system returns all values containing 12, including 123, 312, 3123, and 12. Keep this in mind when filtering.

See Details for information about Measure Value Filtering in that section.

Navigate through data pages

Navigation buttons are at the bottom of each data table. The double arrows pointing left and right go one page forward or back. The single arrows with the straight lines go all the way to the beginning or end of the data.

The numbers in the middle (here, 1/221) tell you what page you are on (1) and the total number of pages of data (221).

On the right side is a dropdown where you can change the number of entries displayed on each page; the image above indicates 100 items per page. You might select a higher number of rows per page so you have fewer pages to click through, or you might select a smaller numbers of rows per page so each page takes less time to load.

Select data: Check box functionality

Select items by checking one or more boxes in the first column. In a single-page table, click the check box in the heading row of the table to select or deselect all the items in the list.

When you click the box at the top of a multi-page table, a dropdown appears asking if you want to check all the items in the list (including on other pages), or all the visible items on the same page. If items are already checked, the dropdown gives you the option to clear all the items in the list (including on other pages), or all the visible items on the current page.

When there is only one page of items to select, only the Check/Clear Visible option appears without the Check/Clear All option.

Rearrange columns

Rearrange the columns by clicking a column title and dragging it to its new position.

Delete columns

To remove a column, click the blue (X) in the column title.