Career Profile Dashboard: Filtering for Performance Tiles and Analysis Not Working

Summary:

We're creating a Career Profile dashboard and would like tiles/drill down analysis to display for employees whose career profile is In progress (1-8 out of 9 sections completed) or completed (9 out of 9 sections completed). However it is not counting or filtering the analysis correctly for these two groups.

Content (required):

The client would like Performance Tiles displaying the status of employee's Career Profile. The count for all profiles and those not started are working correctly, but we're unable to get the in progress or completed to work. Within the analysis we are able to display how many are completed (Sections Complete column), but it does not sum correctly when filtering.