Example 5.2

Question: How many employees at the university are veterans, work full-time, and are between 40 and 70 years old with salary rates between $20,000 and $70,000?

  • Start at the Veteran color key, click Veteran.
  • Move the mouse to the Part-Time/Full-Time color key, click Full-Time.
  • Move the cursor to the Salary Increment filter at the top right of the page, click on the existing value, enter 20000, hit enter.
  • Move the cursor left to the Salary Range filter, click the down arrow, click All to remove all of the checks, click $20,000, $40,000, and $60,000, click Apply.
  • Move the cursor to the upper left of the page to the Age Increment filter, use the slider or > to increase the increment to 20.
  • Move the cursor left to the Age Range filter, click the down arrow, click All to remove all of the checks, click 40 and 60, click Apply.
  • In the Current Headcounts column (left side of the dashboard), it shows 278 employees meet these criteria.
  • To view the results in tabular form, click on the Table button in the upper right corner of the page.  Click on the column heading Veteran, read in the Full-Time column that there are 278 full-time veterans at the university between 40 and 70 years old with salary rates between $20,000 and $70,000.
  • Print the dashboard if desired.
  • Click on the Revert button at the bottom or top of the page to undo the filters.